Sql Error on userdb convert

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • netmikey
    New Member
    • May 2004
    • 21
    • 3.0.1

    Sql Error on userdb convert

    Hello,

    i am converting from ipb db to vb.

    everything works fine with no problems, however, i went to convert 1-500 usernames...and it did...
    so when i clicked import/export to get to the main menu...i got this...



    Database error in vBulletin:ImpEx Source 3.0.1:

    Invalid SQL:
    SELECT * FROM gcfan_members
    ORDER BY id
    LIMIT 0,
    mysql error: You have an error in your SQL syntax near '' at line 4

    mysql error number: 1064

    Date: Friday 21st of May 2004 12:17:53 PM
    Script: http://www.gcnaptown.com/v3/impex/index.php
    Referer: http://www.gcnaptown.com/v3/admincp/index.php?do=nav
    Username: admin
    IP Address: 207.87.81.254
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    It looks like you have not setup your impexconfig file correctly. Confirm that the data in it is 100% correct

    Comment

    • netmikey
      New Member
      • May 2004
      • 21
      • 3.0.1

      #3
      i have deleted, reinstalled, mysqldumped, mysqlimported over and over again for both the source and target databases...everything conneting fine..i can convert every other table except users..

      it says, converting 1-500..then it never moves after that....
      then when i click import/export, i get that sql error, then im stuck untill i drop and re-create the vB database...

      Comment

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