import error from phpbb

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stephend23
    New Member
    • Apr 2005
    • 7
    • 3.0.7

    import error from phpbb

    Hey
    ive just perchase the license for Vbulletin.

    After following the instruction to import all my data from phpnuke (phpBB 2.0.11)
    I keep getting the follwoing errors:

    THIS IS WHAT I GET ON TOP OF THE PAGE
    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /impex/db_mysql.php on line 248

    INSIDE THE BOX I GET THIS MESSAGE:
    Database error in vBulletin 3.0.7:
    Invalid SQL:
    SELECT user_id,username
    FROM nuke_users
    ORDER BY user_id
    LIMIT 0,25
    mysql error:
    mysql error number: 0


    Ive tried skipping to the other modules but i get the same errors again

    Any help would be great.

    Thanks in advance
    Stephen
  • stephend23
    New Member
    • Apr 2005
    • 7
    • 3.0.7

    #2
    Ive just re-tried to do the 001Check and update database module and noticed thw follwoing error below:

    ERROR with the database or file system, please check config.

    Below is my config file:

    targetdatabasetype = mysql

    targetserver = localhost

    targetuser = "oriental_vbullet"

    targetpassword = "#######"

    targetdatabase =oriental_vbulletin

    targettableprefix =vb3_

    [ 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 = false

    ; mysql OR mssql

    sourcedatabasetype = mysql

    sourceserver = localhost

    sourceuser = "oriental_vbulle1"

    sourcepassword = "######"

    sourcedatabase =oriental_vbulletin1

    sourcetableprefix =nuke_

    Comment

    • Steve Machol
      Former Customer Support Manager
      • Jul 2000
      • 154488

      #3
      Assuming all the other info is correct, change the sourceexists line to:

      sourceexists = true
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment

      • stephend23
        New Member
        • Apr 2005
        • 7
        • 3.0.7

        #4
        ive just did what you said. And the error in 001Check and update database module doesnt show up anymore however.

        i still get the following message:
        Database error in vBulletin:ImpEx Source 3.0.7:
        Invalid SQL:
        SELECT * FROM nuke_users
        ORDER BY user_id
        LIMIT 0,500
        mysql error: Table 'oriental_vbulletin1.nuke_users' doesn't exist
        mysql error number: 1146

        Ive also tried to change sourcetableprefix to
        nuke_bb

        But that still didnt work

        Comment

        • stephend23
          New Member
          • Apr 2005
          • 7
          • 3.0.7

          #5
          think i got it now. Had to change some of the prefix

          Thanks for your help

          Comment

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