Announcement

Collapse
No announcement yet.

Impex Problems IPB -> vBulletin 4.2.0

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

  • Ix Soulcist xI
    replied
    What do I do?

    Leave a comment:


  • Ix Soulcist xI
    replied
    Yes, that has worked and I think I have one last error before I can do this:

    I have IPB 3.4.1 - and I chose this: http://puu.sh/1SjL9

    What do I do?

    Leave a comment:


  • Trevor Hannant
    replied
    If you edit the file impex/index.php and change TYPE=MyISAM to ENGINE=MyISAM located at or near line 271, this should resolve this for you.

    Leave a comment:


  • Ix Soulcist xI
    replied
    Originally posted by Trevor Hannant View Post
    I've removed your database details for security...

    Open the file in Notepad++ and check that under Encoding it's set to ANSI
    I had to set it - it is now though.

    Edit: I supposed that worked or something, but now I'm getting this error:

    ImpEx Database error

    mysql error: Invalid SQL: CREATE TABLE valazar_impexerror (
    errorid bigint(20) unsigned NOT NULL auto_increment,
    errortype varchar(10) NOT NULL default '',
    classnumber varchar(3) NOT NULL default '',
    importid bigint(20) NOT NULL default 0,
    error varchar(250) default 'NULL',
    remedy varchar(250) default 'NULL',
    PRIMARY KEY (errorid)
    &nbsp TYPE=MyISAM


    mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9


    mysql error number: 1064


    Date: Thursday 24th 2013f January 2013 07:39:10 AM
    Database: REMOVED
    MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9

    Leave a comment:


  • Trevor Hannant
    replied
    I've removed your database details for security...

    Open the file in Notepad++ and check that under Encoding it's set to ANSI

    Leave a comment:


  • Ix Soulcist xI
    replied
    No, I don't think so, though there is a big red line going down the side the entire document: http://puu.sh/1RWO9

    Code:
    <?php
    if (!defined('IDIR')) { die; }
    
    
    #################################################################### |;
    # vBulletin  - Licence Number VBSEB28B50
    # ---------------------------------------------------------------- # |;
    # Copyright �2000�2013 vBulletin Solutions Inc. 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.
    
    
    ####
    #
    # TARGET - The target is the vBulletin database (where the  data is going to)
    #
    ####
    
    
    $impexconfig['target']['server']        = 'localhost';
    $impexconfig['target']['user']            = 'REMOVED';
    $impexconfig['target']['password']        = 'REMOVED';
    $impexconfig['target']['database']        = 'REMOVED';
    $impexconfig['target']['tableprefix']    = 'valazar_';
    
    
    # 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']    = 'mysql';  // mysql OR mssql
    $impexconfig['source']['server']        = 'localhost';
    $impexconfig['source']['user']            = 'REMOVED';
    $impexconfig['source']['password']        = 'REMOVED';
    $impexconfig['source']['database']        = 'REMOVED';
    $impexconfig['source']['tableprefix']   = 'valazar_';
    
    
    ####
    #
    # 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', false);
    
    
    ###############################################################################
    ####
    #
    # 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);
    ?>
    Last edited by Trevor Hannant; Thu 24 Jan '13, 4:26am.

    Leave a comment:


  • AliMadkour
    replied
    Edit ImpExConfig.php file and make sure than you haven't extra spaces before <?php you can use notepad++ to detect that.

    Leave a comment:


  • Ix Soulcist xI
    replied
    What to do?

    Leave a comment:


  • Ix Soulcist xI
    started a topic Impex Problems IPB -> vBulletin 4.2.0

    Impex Problems IPB -> vBulletin 4.2.0

    This is the error I'm having when I attempt to click 'import' and put in the customer number, it was another error before but I suppose I somehow fixed it, I'm not sure what to do, so please help me.

    Warning: Cannot modify header information - headers already sent by (output started at /home/valazar/public_html/vB/impex/ImpExConfig.php:1) in/home/valazar/public_html/vB/impex/impex_auth.php on line 22
    Regards,

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