I started a forum ages ago using phpBB and then upgraded it to vBulletin. I recently acquired another forum on the same topic (which is phpBB 2.xx) and would like to import it into my current vB database.
I have configured and uploaded the most recent ImpEx and trying to get this new DB imported. It seems that something from the first import is causing this to fail as I am getting the following SQL syntax errors
If I try to run the remove import IDs option here is the error I get
What should I do so I can get a clean import?
Thanks in advance,
Andy
I have configured and uploaded the most recent ImpEx and trying to get this new DB imported. It seems that something from the first import is causing this to fail as I am getting the following SQL syntax errors
PHP Code:
ImpEx Database errormysql error: Invalid SQL:
INSERT INTO forums_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
)
VALUES
(
'69',
'Active Imported Users',
'',
'',
0,
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)
mysql error: Duplicate entry '0' for key 1
mysql error number: 1062
Date: Saturday 03rd of June 2006 06:17:12 AM
Database: XYZ_travel
MySQL error:
PHP Code:
ImpEx Database errormysql error: Invalid SQL: DELETE FROM datastore WHERE title='ImpExSession';
mysql error: Table 'ityt_travel.datastore' doesn't exist
mysql error number: 1146
Date: Saturday 03rd of June 2006 06:26:47 AM
Database: XYZ_travel
MySQL error: Table 'ityt_travel.datastore' doesn't exist
Thanks in advance,
Andy
Comment