Announcement

Collapse
No announcement yet.

a problem occurred while importing

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

  • a problem occurred while importing

    Hello,

    I am freshly new user to vb forum. i just purchased it and downloaded it with the importer. I got the forum working right in the apache server in my computer. but when i tried to import my phpbb forum to convert it to the vb i got this error

    Warning: Supplied argument is not a valid MySQL-Link resource in \impex\db_mysql.php on line 248

    Invalid SQL:
    SELECT * FROM phpbb_users
    ORDER BY user_id
    LIMIT 0,500
    mysql error:

    mysql error number: 0

    Date: Friday 01st of April 2005 01:31:08 AM
    Script: http://localhost/vb/impex/index.php
    Referer: http://localhost/vb/impex/index.php
    Username: test



    can I get help here please?

    Thanks alot

  • #2
    What is the tableprefix in your vBulletin database and you phpBB database ?

    What have you put in your ImpExConfig ?
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      This is what I have for the ImpExConfig

      PHP Code:
      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      vb
      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 databaseset 'sourceexists' to FALSE

      sourceexists        
      false 
      mysql OR mssql
      sourcedatabasetype  
      mysql
      sourceserver        
      localhost
      sourceuser          
      ""
      sourcepassword      ""
      sourcedatabase      phpbb
      sourcetableprefix   
      phpbb_ 
      and this is my php config

      PHP Code:
      $dbms 'mysql'
      $dbhost 'localhost';
      $dbname 'phpbb';
      $dbuser '';
      $dbpasswd '';
      $table_prefix 'phpbb_'

      and this is my vb config

      PHP Code:
      $servername 'localhost';
      $dbusername '';
      $dbpassword '';
      $dbname 'vb';
      $technicalemail '[email protected]';
      $usepconnect 0;
      $admincpdir 'admincp';
      $modcpdir 'modcp';
      $canviewadminlog '1';
      $canpruneadminlog '1';
      $canrunqueries '';
      $undeletableusers '';
      $superadministrators '';
      $tableprefix '';
      $cookieprefix 'bb'

      Comment


      • #4
        This :
        Code:
        sourceexists        = false
        should be :

        Code:
        sourceexists        = true
        Did that not die on module 001 with an error explaining that it must be set ?
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          well, doing that gave me

          Code:
           The source database entered in ImpExConfig.php does not exist.
          and if i set it back to false it works but i still get the old problem.???

          Comment


          • #6
            Originally posted by QtrCafe
            well, doing that gave me

            Code:
             The source database entered in ImpExConfig.php does not exist.
            and if i set it back to false it works but i still get the old problem.???
            Well its not working its just hiding the fact that it can't connect to the source database beause it dosn't check it, then when you attempt to get the users it dies because the source isn't set, hence the origional error of :

            The source database entered in ImpExConfig.php does not exist.

            The database is on the same server I take it and you can connect with the details you have put in for username and password ?
            I wrote ImpEx.

            Blog | Me

            Comment


            • #7
              Problem Solved


              Thanks alot Jerry

              Comment

              Loading...
              Working...
              X