Announcement

Collapse
No announcement yet.

Dont understand Impex

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

  • #16
    Done...

    Comment


    • #17
      Zachery cant find the problem, someone else?

      Comment


      • #18
        I am getting the same problem on my boards when importing from PHPBB 2.07

        Basically it comes up with this, which is basically the same problem.

        Database error in vBulletin:ImpEx Target 3.0.2:
        Invalid SQL: SELECT title, data FROM rouse_datastore WHERE title = 'ImpExSession'
        mysql error: Table 'blueuniv_rouse.rouse_datastore' doesn't exist
        mysql error number: 1146
        Date: Friday 02nd of July 2004 02:38:26 PM
        Script: http://www.rouseindahouse.com/impex/index.php
        Referer:
        Username: ed
        IP Address: **.**.***.***
        Just fyi rouse_ is the table prefix I am installing with. blueuniv_rouse is the database name I am installing with. The old database has blueuniv_riseofnations as the database name, and rouseindahouseportal1_ as the table prefix.

        Thanks (also didn't mean to steal your topic, but the problems look identical at first glance)

        Comment


        • #19
          My config of the Impex system is a little bit changed now, i give it a try this way, when it seems to work u get the code

          Comment


          • #20
            Always make sure that you don't copy and paste the details in impexconfig as all the variable names are diffrent.
            I wrote ImpEx.

            Blog | Me

            Comment


            • #21
              I got mine sorted, turns out vbulletin didn't install with a table prefix as it said it would, and I had Impex set to look for it with a table prefix.

              Comment


              • #22
                Use this config layout:

                Code:
                ;vBulletin:Impex Config File<?php /*
                ;| #################################################################### |;
                ;| # vBulletin 3.0.1 - Licence Number 
                ;| # ---------------------------------------------------------------- # |;
                ;| # Copyright 20002004 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 # |;
                ;| #################################################################### |;
                
                [ Target Database ]
                ; The following settings allow ImpEx to connect to the vBulletin 3
                ; database into which you will be importing data.
                
                targetdatabasetype  = mysql
                targetserver        = localhost
                targetuser          = 
                targetpassword      = 
                targetdatabase      = 
                targettableprefix   =
                
                [ Source Database ]
                ; 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
                
                sourceexists        = TRUE
                
                sourcedatabasetype  = mysql
                sourceserver        = localhost
                sourceuser          = 
                sourcepassword      = 
                sourcedatabase      = 
                sourcetableprefix   = 
                
                
                ;targetuser          = 
                ;targetpassword   = 
                ;targetdatabase   = 
                ;targettableprefix  = 
                
                
                
                ;| #################################################################### |;
                ;| # File ends with closing PHP tag...                                # |;
                ;| #################################################################### |;
                ;*/ ?>
                Last edited by Zachery; Sat 3rd Jul '04, 10:11am. Reason: removed license number again

                Comment


                • #23
                  Use the original comfig file layout and just add the variables, do not copy a second set of target variables into the file, over or after the source ones.
                  I wrote ImpEx.

                  Blog | Me

                  Comment

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