Announcement

Collapse
No announcement yet.

Importing From phpBB2 Error

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

  • Importing From phpBB2 Error

    while importing i got error :
    Database error in vBulletin:ImpEx Source 3.0.1:

    Invalid SQL:
    SELECT user_id,username
    FROM users
    ORDER BY user_id
    LIMIT 0,25
    mysql error: Table 'kleozws_org_-_bb.users' doesn't exist

    mysql error number: 1146

    PS : I already have the users table on the databse so i dont know wtf ...
    Moreover after that impex showed me a blank page . i deleted impex and reinstalled but i got same blank page ... whats going on ?

  • #2
    Did you make sure you set your table prefix correctly? phpbb normaly has the prefix phpbb_

    Youll need to run this script to restart the impex process

    DELETE FROM datastore WHERE title='ImpExSession';

    Comment


    • #3
      write this where ?
      and how i set the prefix ?

      Comment


      • #4
        Erm i ment query, go into phpmyadmin and run this query

        DELETE FROM datastore WHERE title='ImpExSession';

        Comment


        • #5
          done now its ok but how i set prefix i dont see anywhere ... ?
          Last edited by kleoz; Tue 8th Jun '04, 9:54am.

          Comment


          • #6
            did the prefic but categories threats and posts not imported ... only users imported ...

            Comment


            • #7
              Did you update the thread and forum counters after importing?
              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


              • #8
                thats it thanx :>

                Comment

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