I am trying to import data from a vBulletin [source] (3.5.0 Release Candidate 2) forum to another vBulletin [target] (3.6.3) forum.
I am able to run modules 001 and 003 (skipping 002) but I'm getting this error on module 004.
I also get this error after running module 001, all the tables are green except vbfields, I'm not sure it this is related to my problem in module 004.
Here is my config file for reference.
I am able to run modules 001 and 003 (skipping 002) but I'm getting this error on module 004.
Code:
ImpEx Database errormysql error: Invalid SQL: UPDATE userfield SET field1 = '' WHERE userid=98045 mysql error: Unknown column 'field1' in 'field list' mysql error number: 1054 Date: Monday 20th of November 2006 03:25:57 PM Database: forum1 MySQL error:
Code:
Possiablly custom tables or incorrect prefix : vbfields NOT found. If you have all red tables, i.e. none correct this could possible be your table prefix : # tachy vBulletin® v3.6.3, Copyright ©2000-2006, Jelsoft Enterprises Ltd.
Code:
<?php #################################################################### |; # vBulletin - Licence Number ########### # ---------------------------------------------------------------- # |; # Copyright ©2000–2006 Jelsoft Enterprises Ltd. All Rights Reserved. |; # This file may not be redistributed in whole or significant part. # |; # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |; # http://www.vbulletin.com | http://www.vbulletin.com/license.html # |; #################################################################### |; # The following settings allow ImpEx to connect to the vBulletin 3 # database into which you will be importing data. # If impex is installed in vBulletin you can ignore the target details # as includes/config.php if (!defined('IDIR')) { die; } # For mysqli enter mysql $impexconfig['target']['databasetype'] = 'mysql'; $impexconfig['target']['server'] = 'localhost'; $impexconfig['target']['user'] = 'xxxxx'; $impexconfig['target']['password'] = 'xxxxx'; $impexconfig['target']['database'] = 'forum1'; $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; # mysql / mssql $impexconfig['source']['databasetype'] = 'mysql'; $impexconfig['source']['server'] = 'localhost'; $impexconfig['source']['user'] = 'xxxxx'; $impexconfig['source']['password'] = 'xxxxx'; $impexconfig['source']['database'] = 'forum2'; $impexconfig['source']['tableprefix'] = ''; # Error logging will log import errors to a database table impexerror # for use with support. # Language file is the file of phrases to be used, default is english. # pagespeed is the second(s) wait before the page refreshes. $impexconfig['system']['errorlogging'] = true; $impexconfig['system']['language'] = '/impex_language.php'; $impexconfig['system']['pagespeed'] = 1; 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); ?>
Comment