Upgrading from 3.6.2 to 3.8.0 RC1 database error

[cbiweb]

Started from 3.6.2, and got this error at 3.7.0 beta 2, Step 4 (Default Data Insertion)


Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET
forumpermissions = forumpermissions |
IF(forumpermissions & 16, 1048576, 0) |
IF(forumpermissions & 64, 2097152, 0) |
IF(forumpermissions & 512, 4194304, 0),
genericpermissions = genericpermissions |
IF(forumpermissions & 64
OR forumpermissions & 16, 1073741824, 0),

genericpermissions2 = genericpermissions2 |
IF(genericpermissions & 4096
OR genericpermissions & 268435456, 1, 0),

albumpermissions = albumpermissions |
IF(genericpermissions & 2
AND genericpermissions & 128, 1, 0) |
IF(genericpermissions & 1, 2, 0),
albumpicmaxwidth = 600,
albumpicmaxheight = 600,
albumpicmaxsize = 100000,
albummaxpics = 100,
albummaxsize = 0,

usercsspermissions = usercsspermissions |
IF(genericpermissions & 2
AND signaturepermissions & 8, 1, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 8, 2, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 2, 4, 0) |
IF(genericpermissions & 2
AND genericpermissions & 128
AND signaturepermissions & 2, 8, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 2, 16, 0),

visitormessagepermissions = visitormessagepermissions |
IF(forumpermissions & 64
OR forumpermissions & 32, 1, 0) |
IF(forumpermissions & 64, 2, 0) |
IF(forumpermissions & 128, 4, 0) |
IF(forumpermissions & 256, 8, 0) |
IF(forumpermissions & 131072, 16, 0) |
IF(forumpermissions & 128
OR forumpermissions & 256, 32, 0),

socialgrouppermissions = socialgrouppermissions |
IF(genericpermissions & 1, 1, 0) |
IF(forumpermissions & 16, 2, 0) |
IF(forumpermissions & 128, 4, 0) |
IF(forumpermissions & 512, 8, 0) |
IF(genericpermissions & 1, 16, 0) |
IF(forumpermissions & 128
OR forumpermissions & 256, 32, 0) |
IF(adminpermissions & 1, , 0) |
64;

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 ' 0) |
64' at line 55
Error Number : 1064
Request Date : Sunday, December 7th 2008 @ 12:47:58 PM
Error Date : Sunday, December 7th 2008 @ 12:47:58 PM
Script : http://xxx.com/forumdev/install/upgrade_370b2.php?step=4
Referrer : http://xxx.com/forumdev/install/upgrade_370b2.php?step=3
IP Address : 216.xxx.xxx.xxx
Username :
Classname : vb_database
MySQL Version : 5.0.67-community

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

[cbiweb]

If it happens again in the future I'll do just that. This was a test forum with very little (and useless) content, so I went ahead and wiped the whole thing, then clean installed 3.8.0RC1. Thanks. :)