Error in first step (Check and update database)

[chelssi]

Type of import (clean or merge): clean
Source board system and version:Phpbb 2.0.21
Target version: vBulletin 3.6.0
Module issue occurred on: Check and update database
Any SQL error reported:Check all as completed but at bottom says:

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
(
'69',
'Active Imported Users',
'',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)


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

mysql error number: 1366

Date: Friday 25th 2006f August 2006 12:10:31 AM
Database: bddforomujervb
MySQL error:

[Jerry]

Your MySQL is running it strict mode, in your ImpExConfig, set this :



define('forcesqlmode', true);

[chelssi]

Thanks, now it works fine.

I've imported all my old database from phpbb2, but the new forum was not working up to tomorrow.

When I upload my new forum vbulletin, will I have to import again?, can I do it again or I must empty the database of vbulletin and then reimport.

Sorry for my english.

thanks

[Jerry]

Thanks, now it works fine.

I've imported all my old database from phpbb2, but the new forum was not working up to tomorrow.

When I upload my new forum vbulletin, will I have to import again?, can I do it again or I must empty the database of vbulletin and then reimport.

Sorry for my english.

thanks

I would advise doing a final import into a clean database.