Suite 4.0 Upgrade database error step 4
 

Hi everyone* hope you can help.

Upgrading from 3.8.4 to 4.0 and got this database error. I do append 'IT' to each table* thats the reason for the table name difference.

Here's the error

Database error in vBulletin 3.8.4:
Invalid SQL:
UPDATE ituser SET options = options |;
MySQL 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 '' at line 1
Error Number : 1064
Request Date : Tuesday* December 29th 2009 @ 02:20:09 PM
Error Date : Tuesday* December 29th 2009 @ 02:20:09 PM
Script : ---
Referrer :
IP Address : ---
Username :
Classname : vB_Database
MySQL Version : 5.1.30