Tweet
Below are the results of my attempt at the first step of import. The only thing I can think of is that it's because my source database is 2.0.7 ? My problem is, I only have the database and to update it to 2.0.10 I have to upgrade the whole phpbb forum. Any suggestions? Or will impex work on 2.0.7?
Thanks!
Altering tables
ImpEx will now Alter the tables in the vB database to include import id numbers.
This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the origional phpBB userid.
moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
Database error in vBulletin:ImpEx Target 3.0.3:
Invalid SQL:
SELECT fieldname, vbmandatory, defaultvalue, dictionary
FROM vb3_vbfields
WHERE tablename = 'usergroup'
ORDER BY vbmandatory
mysql error: Table 'rc_vb3.vb3_vbfields' doesn't exist
mysql error number: 1146
Date: Tuesday 14th of December 2004 03:29:14 AM
Script: ***
Referer: ***
Username: ***
IP Address: ****
Thanks!
Altering tables
ImpEx will now Alter the tables in the vB database to include import id numbers.
This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the origional phpBB userid.
moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK
Database error in vBulletin:ImpEx Target 3.0.3:
Invalid SQL:
SELECT fieldname, vbmandatory, defaultvalue, dictionary
FROM vb3_vbfields
WHERE tablename = 'usergroup'
ORDER BY vbmandatory
mysql error: Table 'rc_vb3.vb3_vbfields' doesn't exist
mysql error number: 1146
Date: Tuesday 14th of December 2004 03:29:14 AM
Script: ***
Referer: ***
Username: ***
IP Address: ****
Comment