I was wondering if someone can give me a hand?
Ive had the biggest trouble trying to import my YAF forums to VB using impex.
Ive tried everything and i just can get impex to read the yaf tables in module 1. I know the prefix in the source is "yaf_" . so for the life of me i can't understand why it can read it.
YAF is on a mssql database and vb in on mysql. Same server.
heres some info on the problem
my IMpex config file
any suggestions?
Ive had the biggest trouble trying to import my YAF forums to VB using impex.
Ive tried everything and i just can get impex to read the yaf tables in module 1. I know the prefix in the source is "yaf_" . so for the life of me i can't understand why it can read it.
YAF is on a mssql database and vb in on mysql. Same server.
heres some info on the problem
my IMpex config file
Code:
$impexconfig['target']['server'] = 'joeyrenda1.db.3853129.hostedresource.com';
$impexconfig['target']['user'] = 'joeyrenda1';
$impexconfig['target']['password'] = 'xxxxxxxx';
$impexconfig['target']['database'] = 'joeyrenda1';
$impexconfig['target']['tableprefix'] = '';
# If the system that is being imported from uses a database,
# enter the details for it here and set 'sourceexists' to true.
# If the source data is NOT stored in a database, set 'sourceexists' to false
$impexconfig['sourceexists'] = true;
####
#
# SOURCE - The source is the old forum database (where the data is coming from)
#
####
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mssql'; // mysql OR mssql
$impexconfig['source']['server'] = 'fla0903809464194.db.3853129.hostedresource.com';
$impexconfig['source']['user'] = 'fla0903809464194';
$impexconfig['source']['password'] = 'xxxxxxxx';
$impexconfig['source']['database'] = 'fla0903809464194';
$impexconfig['source']['tableprefix'] = 'yaf_';
####
#
# DUPLICATE CHECKING
# Where unique import id's are available ImpEx can check for duplicates with some
# Tier2 systems this will need to be set to false.
#
# yahoo_groups, YaBB 2.1, Ikonboard 3.1.5 (for attachments)
#
####
define('dupe_checking', true);
###############################################################################
####
#
# ADVANCED - For a standard import or a novice user leave the settings below.
#
####
// Advanced Target
$impexconfig['target']['databasetype'] = 'mysql'; // currently mysql only
$impexconfig['target']['charset'] = '';
$impexconfig['target']['persistent'] = false; // (true/false) use mysql_pconnect
// Advanced Source
$impexconfig['source']['charset'] = '';
$impexconfig['source']['persistent'] = false;
# pagespeed is the second(s) wait before the page refreshes.
$impexconfig['system']['language'] = '/impex_language.php';
$impexconfig['system']['pagespeed'] = 1;
$impexconfig['system']['errorlogging'] = false;
define('impexdebug', false);
define('emailcasesensitive', false);
define('forcesqlmode', false);
define('skipparentids', false);
define('shortoutput', false);
define('do_mysql_fetch_assoc', false);
define('step_through', false);
define('lowercase_table_names', false);
define('use_utf8_encode', false);
define('use_utf8_decode', true);
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 references 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 original 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
yaf_AccessMask NOT found.
yaf_Active NOT found.
yaf_Attachment NOT found.
yaf_BannedIP NOT found.
yaf_Board NOT found.
yaf_Category NOT found.
yaf_CheckEmail NOT found.
yaf_Choice NOT found.
yaf_Forum NOT found.
yaf_ForumAccess NOT found.
yaf_Group NOT found.
yaf_Mail NOT found.
yaf_Message NOT found.
yaf_NntpForum NOT found.
yaf_NntpServer NOT found.
yaf_NntpTopic NOT found.
yaf_PMessage NOT found.
yaf_Poll NOT found.
yaf_Rank NOT found.
yaf_Registry NOT found.
yaf_Replace_Words NOT found.
yaf_Smiley NOT found.
yaf_Topic NOT found.
yaf_User NOT found.
yaf_UserForum NOT found.
yaf_UserGroup NOT found.
yaf_UserPMessage NOT found.
yaf_WatchForum NOT found.
yaf_WatchTopic NOT found.any suggestions?