Geeklog Forums

Hi

Upgrading form 1.3.8 to 1.3.9, I get the following error from install.php:

1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( fid int unsigned NOT NULL auto_increment, type varchar(30

What do it means?

How can I correct it?

Best regards,
Ernesto.

Hmm, never seen this before. Which version of MySQL are you running on?

Try this:

Open the file sql/updates/mysql_1.3.8_to_1.3.9.php and find the line that reads

fid int unsigned NOT NULL auto_increment,

(near the start of that file) and add (10) after the int so that it looks like this:

fid int(10) unsigned NOT NULL auto_increment,

Then run the upgrade again.

bye, Dirk