QTI
Tue 9th Aug '05, 12:14am
I am trying to import from my phpbb database to vbulletin, and I got the following when I clicked the "check and update database" module:
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
phpbb_auth_access NOT found or a non standard table.
phpbb_banlist NOT found or a non standard table.
phpbb_categories NOT found or a non standard table.
phpbb_config NOT found or a non standard table.
phpbb_confirm NOT found or a non standard table.
phpbb_disallow NOT found or a non standard table.
phpbb_forum_prune NOT found or a non standard table.
phpbb_forums NOT found or a non standard table.
phpbb_groups NOT found or a non standard table.
phpbb_posts NOT found or a non standard table.
phpbb_posts_text NOT found or a non standard table.
phpbb_privmsgs NOT found or a non standard table.
phpbb_privmsgs_text NOT found or a non standard table.
phpbb_ranks NOT found or a non standard table.
phpbb_search_results NOT found or a non standard table.
phpbb_search_wordlist NOT found or a non standard table.
phpbb_search_wordmatch NOT found or a non standard table.
phpbb_sessions NOT found or a non standard table.
phpbb_smilies NOT found or a non standard table.
phpbb_themes NOT found or a non standard table.
phpbb_themes_name NOT found or a non standard table.
phpbb_topics NOT found or a non standard table.
phpbb_topics_watch NOT found or a non standard table.
phpbb_user_group NOT found or a non standard table.
phpbb_users NOT found or a non standard table.
phpbb_vote_desc NOT found or a non standard table.
phpbb_vote_results NOT found or a non standard table.
phpbb_vote_voters NOT found or a non standard table.
phpbb_words NOT found or a non standard table.
and doing the "associate user" module produced the following:
Database error in vBulletin:ImpEx Source 3.0.3:
Invalid SQL:
SELECT user_id,username
FROM users
ORDER BY user_id
LIMIT 0,25
mysql error: Table 'tempphpbb.users' doesn't exist
mysql error number: 1146
and pressing "refresh" would just show the following:
Database cleanup & restart ||| Online manual
Using includes/config.php for target config.
vBulletin v3.0.3, Copyright ©2000-2005, Jelsoft Enterprises Ltd.
could anyone please offer any help? I am pretty ignorant about php and all that I'm afraid.
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
phpbb_auth_access NOT found or a non standard table.
phpbb_banlist NOT found or a non standard table.
phpbb_categories NOT found or a non standard table.
phpbb_config NOT found or a non standard table.
phpbb_confirm NOT found or a non standard table.
phpbb_disallow NOT found or a non standard table.
phpbb_forum_prune NOT found or a non standard table.
phpbb_forums NOT found or a non standard table.
phpbb_groups NOT found or a non standard table.
phpbb_posts NOT found or a non standard table.
phpbb_posts_text NOT found or a non standard table.
phpbb_privmsgs NOT found or a non standard table.
phpbb_privmsgs_text NOT found or a non standard table.
phpbb_ranks NOT found or a non standard table.
phpbb_search_results NOT found or a non standard table.
phpbb_search_wordlist NOT found or a non standard table.
phpbb_search_wordmatch NOT found or a non standard table.
phpbb_sessions NOT found or a non standard table.
phpbb_smilies NOT found or a non standard table.
phpbb_themes NOT found or a non standard table.
phpbb_themes_name NOT found or a non standard table.
phpbb_topics NOT found or a non standard table.
phpbb_topics_watch NOT found or a non standard table.
phpbb_user_group NOT found or a non standard table.
phpbb_users NOT found or a non standard table.
phpbb_vote_desc NOT found or a non standard table.
phpbb_vote_results NOT found or a non standard table.
phpbb_vote_voters NOT found or a non standard table.
phpbb_words NOT found or a non standard table.
and doing the "associate user" module produced the following:
Database error in vBulletin:ImpEx Source 3.0.3:
Invalid SQL:
SELECT user_id,username
FROM users
ORDER BY user_id
LIMIT 0,25
mysql error: Table 'tempphpbb.users' doesn't exist
mysql error number: 1146
and pressing "refresh" would just show the following:
Database cleanup & restart ||| Online manual
Using includes/config.php for target config.
vBulletin v3.0.3, Copyright ©2000-2005, Jelsoft Enterprises Ltd.
could anyone please offer any help? I am pretty ignorant about php and all that I'm afraid.
thanks.