trouble during step 1 impex

[Addicted2HD]

I am running vBulletin 3.7.2 and originally installed vB around 3.6.8 and did my first import then. We have been trying to pinpoint our migration date from Snitz and it's coming up this Friday. I am running another test import, click the "delete imported data" link and started the new import process.

I got the following error in step one "Check and Update 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
(
'69',
'Imported Users',
'Usergroup description',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)


mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1

mysql error number: 1366

Date: Monday 11th 2008f August 2008 01:49:38 PM
Database: vbulletin
MySQL error:

Any ideas?

Thanks,
Scott

[Jerry]

ImpExConfig.php



define('forcesqlmode', true);

[Addicted2HD]

Jerry,

Thanks! That fixed that problem. Now ImpEx won't see any of the tables in the source DB on the same MySQL server, same user, user has full privileges to the source db, I made sure the case was correct on the table prefix just in case but that hasn't made a difference.

Any ideas?

Thanks again.

Edit: Nevermind, I found the define('lowercase_table_names', true); setting

[Jerry]

There have been a few updates to the Snitz importer over the last week or so, look out for the 1.91 release in the next few days.