Webmastersite.net
Register Log In

You have an error in your SQL syntax

Comments on You have an error in your SQL syntax

mariow
Forum Regular

Usergroup: Customer
Joined: Jul 09, 2008

Total Topics: 22
Total Comments: 110
mariow
Posted Jul 15, 2008 - 6:25 PM:

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..
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 17, 2008 - 10:28 AM:

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).
mariow
Forum Regular

Usergroup: Customer
Joined: Jul 09, 2008

Total Topics: 22
Total Comments: 110
mariow
Posted Jul 17, 2008 - 11:04 AM:

well i saw that after the last upgrade to 4.1.54
i did run it now and was succesful.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 18, 2008 - 10:56 PM:

Fixed the version check there so it won't try to run (just to save a few milliseconds).
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.