Announcement

Collapse
No announcement yet.

Importing from IPB 2.1.3 TO 3.5.2

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

  • Importing from IPB 2.1.3 TO 3.5.2

    I get this error on module 002

    Code:
    [B]Warning[/B]: mysql_query(): supplied argument is not a valid MySQL-Link resource in [B]/impex/db_mysql.php[/B] on line [B]247  [/B]
     
    [B]There seems to have been a problem with the database.[/B]
     
    ImpEx Database errormysql error: Invalid SQL: 
       SELECT id, name
       FROM members
       ORDER BY id
       LIMIT 0,25
    mysql error: 
    mysql error number: 0
    Date: Wednesday 04th of January 2006 11:29:34 AM
    Can anyone help me on this please

  • #2
    still sat here waiting for support

    Comment


    • #3
      This is generally caused by having the wrong source db info in your ImpExConfig.php correct. Recheck these details and make sure that
      $impexconfig['sourceexists'] = true; and if your source database has a table prefix this is entered correctly too.

      Comment


      • #4
        I've checked that and reistalled the forum twice - impex works fine up until that point and i get the same error - i maybe a brunette but i think im blonde moment - i know most of the basic which isn't bad for a lady !!

        Comment


        • #5
          Can you paste what you have in impexconfig file here?

          Comment


          • #6
            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 ---------------- # |;
            # [URL="http://www.vbulletin.com/"]http://www.vbulletin.com[/URL] | [URL="http://www.vbulletin.com/license.html"]http://www.vbulletin.com/license.html[/URL] # |;
            #################################################################### |;
            # 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
            $impexconfig['target']['databasetype'] = 'mysql';
            $impexconfig['target']['server'] = 'localhost';
            $impexconfig['target']['user'] = 'stloader_admin';
            $impexconfig['target']['password'] = '********';
            $impexconfig['target']['database'] = 'stloader_forum';
            $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'] = 'stloader_admin';
            $impexconfig['source']['password'] = '********';
            $impexconfig['source']['database'] = 'stloader_forum';
            $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/impex_language.php';
            $impexconfig['system']['pagespeed'] = 1;
            ?>
            Last edited by Zachery; Thu 5 Jan '06, 8:39am.

            Comment


            • #7
              The source and target databases are the same. The source database needs to be the name of your IPB database and the target will be the new vBulletin database name.

              Comment


              • #8
                tried that, still the smae error

                Comment


                • #9
                  Can you fill out a support ticket at:
                  http://www.vbulletin.com/members/me...contactform.php so I can take a look at what is going on.

                  Be sure to include the login info to your Admin CP, phpMyAdmin and FTP.

                  Comment


                  • #10
                    sent a ticket for your attention Boxy !!

                    Thanks

                    Comment


                    • #11
                      As far as I can see the only thing that was wrong was that you had the source and target details mixed up. I've replied to your ticket with what the values should be.

                      Comment


                      • #12
                        sent you a reply back - it didnt work

                        Comment


                        • #13
                          did you include the prefix of your ipb, this is very very important, as without it the impex won't work, try using ibf_ or what ever you database prefix of IPB is ! I am sure you will have some luck here.

                          Thanks,
                          DC

                          Comment


                          • #14
                            by default its "ibf_" !

                            Comment


                            • #15
                              cheers - sorted it

                              Comment

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