Hello,
I am having the hardest time getting the import to work coming from SMF 1.1.2 to vB 3.6.7 . I'm using the current Impex, version 1.81.
I suspect the problem exists when it tries to query the source database for tables, and only half are returned. In the ImpExConfig.php, I started without specifying a source table prefix, and then tested it again with a table prefix of 'SMF_'. I will go into more detail throughout this post.
When impex was first ran, without specifying a table prefix for the source db, I received the following results from module 001:
Code:
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 vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed
attachments NOT found.
board_permissions NOT found.
boards NOT found.
calendar NOT found.
calendar_holidays NOT found.
categories NOT found.
collapsed_categories NOT found.
log_actions NOT found.
log_activity NOT found.
log_banned NOT found.
log_boards NOT found.
log_errors NOT found.
log_floodcontrol NOT found.
log_karma NOT found.
log_mark_read NOT found.
log_notify NOT found.
log_online NOT found.
log_polls NOT found.
log_topics NOT found.
membergroups NOT found.
members NOT found.
messages NOT found.
moderators NOT found.
permissions NOT found.
poll_choices NOT found.
polls NOT found.
settings NOT found.
smileys NOT found.
themes NOT found.
topics NOT found.
sessions NOT found.
And of course, hardly any information was actually imported to my new vB database because most of the core data is stored conveniently in the tables that are 'NOT found'...grr imports are always fun.
So, I did some searching and found that you need to specify a table prefix for the source db. A quick check on my source db showed that all of the tables did indeed have a prefix of 'smf_', so I entered this into the ImpExConfig.php file under the source db and restarted the impex system. I re-ran module 001 and attained the following results:
Code:
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 vB userid.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed
smf_attachments NOT found.
smf_board_permissions NOT found.
smf_boards NOT found.
smf_calendar NOT found.
smf_calendar_holidays NOT found.
smf_categories NOT found.
smf_collapsed_categories NOT found.
smf_log_actions NOT found.
smf_log_activity NOT found.
smf_log_banned NOT found.
smf_log_boards NOT found.
smf_log_errors NOT found.
smf_log_floodcontrol NOT found.
smf_log_karma NOT found.
smf_log_mark_read NOT found.
smf_log_notify NOT found.
smf_log_online NOT found.
smf_log_polls NOT found.
smf_log_topics NOT found.
smf_membergroups NOT found.
smf_members NOT found.
smf_messages NOT found.
smf_moderators NOT found.
smf_permissions NOT found.
smf_poll_choices NOT found.
smf_polls NOT found.
smf_settings NOT found.
smf_smileys NOT found.
smf_themes NOT found.
smf_topics NOT found.
smf_sessions NOT found.
Those tables exist exactly how the are shown directly above, so, what am I doing wrong...or what can I do to fix the problem?
Is there any other information I can supply to assist in this matter?
Feel free to email me any responses at this email:
patrick.a.jones@hotmail.com
Thank you very much in advance,
Patrick Jones
Tue 5th Jun '07 5:48am
Please Wait