Announcement

Collapse
No announcement yet.

ImpEx Troubles

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ImpEx Troubles

    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.

    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:
    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.

    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.
    Here is my config file for reference.

    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);
    ?>
    Last edited by Longclaw; Tue 21 Nov '06, 1:27am. Reason: removed sensitive data

  • #2
    There is no userfield.field1 in the target database ?
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Originally posted by Jerry View Post
      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?

      Comment


      • #4
        Originally posted by Longclaw View Post
        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.
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          Jerry, FWIW many people delete the default user fields for some reason. Perhaps Impex can be rewritten to ignore the missing fields.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #6
            Originally posted by Steve Machol View Post
            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.
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              Originally posted by Jerry View Post
              Ah ok, will put in a "if there do it, otherwise bin it" check.
              This is in 1.73.
              I wrote ImpEx.

              Blog | Me

              Comment


              • #8
                Originally posted by Jerry View Post
                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?).

                Comment


                • #9
                  Originally posted by Longclaw View Post
                  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 wrote ImpEx.

                  Blog | Me

                  Comment


                  • #10
                    Thanks for that - updating Impex helped solve this issue.

                    Comment

                    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                    Working...
                    X