I just did the upgrade and the output showed all okay but only gave this error.
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 'CHANGE `lastthreadid` `lastthreadid` INT( 11 ) DEFAULT '0'' at line 1
Dont know if thats something to be concerned about..
Comments on You have an error in your SQL syntax
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
Hi paul,
I just did the upgrade and the output showed all okay but only gave this error.
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 'CHANGE `lastthreadid` `lastthreadid` INT( 11 ) DEFAULT '0'' at line 1
Dont know if thats something to be concerned about..
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Try running this SQL in phpmyadmin:
ALTER TABLE wsnlinks_categories CHANGE `lastthreadid` `lastthreadid` INT( 11 ) DEFAULT '0';
Does it give an error in phpmyadmin? What mysql version are you running?
It's only supposed to run on upgrades from before 4.1.34 anyway (though no harm after).
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
well i saw that after the last upgrade to 4.1.54
i did run it now and was succesful.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Fixed the version check there so it won't try to run (just to save a few milliseconds).