Page 1 of 1
Ver 3.70 SQL update error
Posted: Thu Mar 31, 2005 9:43 am
by BigBossMan
Not sure if this is a bug or me.
I moved in the new code for 3.70, fixed up the config.inc.php and restarted the web server.
On connect I got this:
MySQL create/upgarde error, Can't execute:
C:/Program Files/Apache Group/Apache2/htdocs/sql/incremental_upgrade_08.sql
Any Ideas ?
Posted: Thu Mar 31, 2005 12:06 pm
by wbartels
Sorry, there was a
; missing on the first line of incremental_upgrade_08.sql
I will fix this in netjukebox 3.70b.
In the meantime you can fix it yourself with a text editor.
Fixed incremental_upgrade_08.sql file:
Code: Select all
ALTER TABLE `configuration_users` CHANGE `stream_id` `stream_id` INT( 10 ) DEFAULT '0' NOT NULL ;
#
# Database version
#
INSERT INTO configuration_database VALUES (8) ;
Posted: Fri Apr 01, 2005 1:52 am
by BigBossMan
COOL
For future reference, this is interpreted by php, correct ?
This script adds the new updates to MySQL database?
If this is correct, PHP is like java, where all statements need to be closed with a ;
Just trying to learn and understand.
BBM
Posted: Fri Apr 01, 2005 8:42 am
by wbartels
There is a ; closing on every query in a sql file.
This is indeed the same closing as in Java, PHP and many other program languages.
If you are interested in how it works, take a look at the mysql.inc.php file.
The function QuerySqlFile() imports the sql file in the database.