Impex Problems IPB -> vBulletin 4.2.0

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ix Soulcist xI
    New Member
    • Oct 2011
    • 13
    • 4.2.X

    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
  • Ix Soulcist xI
    New Member
    • Oct 2011
    • 13
    • 4.2.X

    #2
    What to do?

    Comment

    • AliMadkour
      Senior Member
      • Dec 2004
      • 1588
      • 6.X

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

      Former vBulletin Support Staff
      Need Help?, Or P.M. Me

      Comment

      • Ix Soulcist xI
        New Member
        • Oct 2011
        • 13
        • 4.2.X

        #4
        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.

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          I've removed your database details for security...

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

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

          • Ix Soulcist xI
            New Member
            • Oct 2011
            • 13
            • 4.2.X

            #6
            Originally posted by Trevor Hannant
            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

            Comment

            • Trevor Hannant
              vBulletin Support
              • Aug 2002
              • 24325
              • 5.7.X

              #7
              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.
              Vote for:

              - Admin Settable Paid Subscription Reminder Timeframe (vB6)
              - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

              Comment

              • Ix Soulcist xI
                New Member
                • Oct 2011
                • 13
                • 4.2.X

                #8
                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?

                Comment

                • Ix Soulcist xI
                  New Member
                  • Oct 2011
                  • 13
                  • 4.2.X

                  #9
                  What do I do?

                  Comment

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