Ver 3.70 SQL update error

[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 ?

[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) ;

[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

[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.