SQL syntax error

[shaka]

on upgrading from 1.1.4 to 2.0 i get the following error and upgrade stops

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 's')' at line 4

any help on this would be much appreciated

thanks

[Grudge]

Can you try the updated upgrade script attached to my post near the end of the following topic?
http://www.simplemachines.org/community/index.php?topic=229262.0

[shaka]

seems to be ok now after i ran the upgrade in debug mode

thanks for the reply Grudge