ImpEx Troubles

[Longclaw]

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.

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:

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.

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.

Here is my config file for reference.

<?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);
?>

[Jerry]

There is no userfield.field1 in the target database ?

[Longclaw]

There is no userfield.field1 in the target database ?

Should there be a userfield table and a field1? That doesn't seem like a meaningful name or used for a table and field. Why would the script be looking for it?

[Jerry]

Should there be a userfield table and a field1? That doesn't seem like a meaningful name or used for a table and field. Why would the script be looking for it?

Because its a default field in a vBulletin database, ImpEx is designed to import into a default or extended vBulletin schema.

Not one that is partially complete or modified from the original that involves the removal of anything from the default schema.

Userfield.field1 is the User's Biography.

[Steve Machol]

Jerry, FWIW many people delete the default user fields for some reason. Perhaps Impex can be rewritten to ignore the missing fields.

[Jerry]

Jerry, FWIW many people delete the default user fields for some reason. Perhaps Impex can be rewritten to ignore the missing fields.

Ah ok, will put in a "if there do it, otherwise bin it" check.

[Jerry]

Ah ok, will put in a "if there do it, otherwise bin it" check.

This is in 1.73.

[Longclaw]

This is in 1.73.

When will 1.73 be available? In the mean time it should work if I just remove the tables (or create them in the target database?).

[Jerry]

When will 1.73 be available? In the mean time it should work if I just remove the tables (or create them in the target database?).

Next 24 hours.

[I, Brian]

Thanks for that - updating Impex helped solve this issue.