Upgrade database error

[Morrus]

I'm upgrading from 3.6.8 to 3.8 Beta 1.

I'm getting this error:


Step 4) Default Data Insertion

Updating phrasetype table
Altering usergroup Table (1 of 1)
Database errorThe Circvs Maximvs database has encountered a problem.

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 : Monday, October 20th 2008 @ 03:37:25 PM
Error Date : Monday, October 20th 2008 @ 03:37:27 PM
Script : http://www.circvsmaximvs.com/install/upgrade_370b2.php?step=4
Referrer :
IP Address : 90.195.202.202
Username :
Classname : vB_Database
MySQL Version : 4.0.23a

Any ideas?

[Morrus]

It refers to this line:


IF(adminpermissions & 1, , 0) |
64;


Where it looks like there's a missing number between the two commas? Is that the issue it's having?

[Morrus]

I've installed a fresh copy and am trying to import using ImPex. Of course, ImPex dopesn't have 3.6.8 - > 3.8 as an option, so it probably won't work. But I have to try something.

[Morrus]

At the same time, I'm attempting an upgrade to 3-7-3 on the original, just in case that works. If it does, the 3.8 upgrade might work after that.

[Morrus]

Upgrade to 3.7.3 successful. Now attempting to go to 3.8.

[Lenni]

You did beta on a live environment?

[Bounce]

You did beta on a live environment?


I have but only after I tested the upgrade went ok on my test forums :rolleyes:

[Zachery]

You should never use ImpEx to upgrade like this.

Did you make a backup before you began? If you try running it again does it produce the same error? If so I'll check the differences between the 3.8 upgrade files and 3.7, but they shouldn't differ that much.