3.6.0 to 3.6.8 Import error

[aranthorn]

I'm moving servers and decided now would be a good time to update vB as well. I did a backup of my existing DB, then FTP'd up to the new server and did a restore to "BACKUP1" database. I then use the 3.6.8 build as the target and the "BACKUP1" as the source. Connectivity looks fine (it passes phase 1 of checking/updating), but I get this when I try to do the usergroups:


Importing 18 Usergroups

From : 0 :: To : 18

84.21 %Usergroup -> ImpEx - Unregistered / Not Logged In
86.84 %Usergroup -> ImpEx - Registered Users
81.58 %Usergroup -> ImpEx - Users Awaiting Email Confirmation
81.58 %Usergroup -> ImpEx - (COPPA) Users Awaiting Moderation
There seems to have been a problem with the database.


ImpEx Database errormysql error: Invalid SQL:
INSERT INTO usergroup
(
importusergroupid, title, description,
usertitle, passwordexpires, passwordhistory,
pmquota, pmsendmax,
opentag, closetag, canoverride,
ispublicgroup, forumpermissions, pmpermissions,
calendarpermissions, wolpermissions, adminpermissions,
genericpermissions, genericoptions, attachlimit,
avatarmaxwidth, avatarmaxheight, avatarmaxsize,
profilepicmaxwidth, profilepicmaxheight, profilepicmaxsize,
signaturepermissions, sigpicmaxwidth, sigpicmaxheight,
sigpicmaxsize, sigmaximages, sigmaxsizebbcode, sigmaxchars,
sigmaxrawchars, sigmaxlines
)
VALUES
(
'5',
'ImpEx - Super Moderators',
'',
'Super Moderator',
0,
'0',
'2000',
'0',
'<span style='color:Green'><b>',
'</b></span>',
'0',
'0',
'470810623',
'3',
'63',
'15',
'1',
'1038049263',
'63',
'0',
'150',
'150',
'655350',
'500',
'500',
'655350',
'237023',
'600',
'200',
'655350',
'4',
'5',
'500',
'1000',
'5'
)


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 'color:Green'><b>',
'</b></span>',
'0',
'0',
'470810623',' at line 26

mysql error number: 1064

Date: Monday 06th 2007f August 2007 04:07:37 PM
Database: vb_368
MySQL error:




I also notice that it only gives the option for 3.6.7pl1 or 3.5.8 or 3.0.17. I was just assuming 3.6.7pl1 would be OK. Am I mistaken?

[Jerry]

ImpEx should only be used between versions of vBulletin as a last resort, you should always upgrade.

Though I have updated ImpEx, you'll need to down load it again then upload and overwrite ImpExDatabaseCore.php.

[aranthorn]

weird... I downloaded impex this afternoon and had the issue, I re-downloaded as per your instructions and updated only the ImpExDatabaseCore.php file and it's running now :)

Thanks Jerry