Ver 3.70 SQL update error

General discussion about netjukebox
Post Reply
BigBossMan
User
Posts: 33
Joined: Wed Mar 30, 2005 9:27 am
Location: SLC, Utah, USA

Ver 3.70 SQL update error

Post 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 ?
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post 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) ;
BigBossMan
User
Posts: 33
Joined: Wed Mar 30, 2005 9:27 am
Location: SLC, Utah, USA

Post 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
User avatar
wbartels
netjukebox developer
Posts: 872
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Post 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.
Post Reply