sql error phpbb2.0.17 to vb3.0.8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Oncall24
    New Member
    • Aug 2005
    • 5
    • 3.0.8

    sql error phpbb2.0.17 to vb3.0.8

    hi

    im now working to send the phpbb database into the vb,
    001 i think its success as 19 had been imprted.

    when i come to the second step 002, i got this error, please help.

    Code:
     
    Invalid SQL: 
       SELECT user_id,username
       FROM users
       ORDER BY user_id
       LIMIT 0,25
    mysql error: Unknown column 'user_id' in 'field list'
    mysql error number: 1054

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

    #2
    It looks like you did not enter the correct sourceprefix info in ImpExConfig.php. Generally phpBB databases use: phpbb_
    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

    • Oncall24
      New Member
      • Aug 2005
      • 5
      • 3.0.8

      #3
      yup ur right , i forgot that, let me complete, and ill get back to you if ill face other errors.

      thx

      Comment

      • Oncall24
        New Member
        • Aug 2005
        • 5
        • 3.0.8

        #4
        how can i move the imported users, to registred users, moderators and admins?

        Comment

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

          #5
          Please read the Importing HOWTO thread:

          Latest build version and updates (http://www.vbulletin.com/forum/showthread.php?t=209508) HOWTO ImpEx (Import / Export) Here are some things to think about when doing an import and steps to follow. First there are some things to realise : Testing an import before shutting down the source forum is the best way to


          Take special note of The End Game section. Following these steps should solve those issues.
          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

          • Oncall24
            New Member
            • Aug 2005
            • 5
            • 3.0.8

            #6
            thx mate, done

            Comment

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