Clean import from PHPBB2.0.22 to VB3.6.8

[Alibi]

First thing. I didn't even see vb 3.6.8 included in the conversion list so I selected the nearest version to it.

Everything was smooth until I attempt to import usergroups

ImpEx Database errormysql error: Invalid SQL:
INSERT INTO apusergroup
(
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',
'Active Imported Users',
'Usergroup description',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)

mysql error: Incorrect integer value: '' for column 'passwordhistory' at row 1
mysql error number: 1366
Date: Sunday 26th 2003f January 2003 04:35:09 AM
Database: forum
MySQL error:

[Steve Machol]

If you are not using Impex 1.83, then please download and use that version.

Then if you still have this problem, edit the ImpExConfig.php file and change this line :

define('forcesqlmode', false);

to

define('forcesqlmode', true);

[Alibi]

Thank you. When I read the
"Using includes/config.php for target config."

I went and changed that forcesqlmode = true. Never thought about checking the impex config.

[Steve Machol]

Glad it worked.

[Jerry]

Thank you. When I read the
"Using includes/config.php for target config."

I went and changed that forcesqlmode = true. Never thought about checking the impex config.

Put on the todo list.