Import Errors for SMF to Vbulletin

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • halpern
    New Member
    • Apr 2006
    • 29

    Import Errors for SMF to Vbulletin

    Ok I exported the sql file from my SMF forum to my dev machine and created a table called "theo" and imported all of my info into it from my forum. I created a new database called "office" which is going to be the one that vbulletin uses for the new information from SMF to be stored..When getting to the 2nd stage of the import script I get this:

    ImpEx Database errormysql error: Invalid SQL:
    SELECT ID_MEMBER, memberName
    FROM members
    ORDER BY ID_MEMBER
    LIMIT 0,25

    mysql error: Table 'theo.members' doesn't exist

    mysql error number: 1146

    Date: Friday 12th of May 2006 06:43:28 PM
    Database: theo
    MySQL error: Table 'theo.members' doesn't exist


    What could this error be? After running the 1st step everything passes but there are multiple tables in red that it didn't seem to find but the screen gets refreshed so fast that I can't see what they were. Any suggestions? I wish I started on vbulletin but now I don't know if my upgrade will work? Thanks.
    Classic Film Fanatics
    http://www.classicfilmfanatics.com
  • Jerry
    Senior Member
    • Dec 2002
    • 9137
    • 1.1.x

    #2
    What could this error be? After running the 1st step everything passes but there are multiple tables in red that it didn't seem to find but the screen gets refreshed so fast that I can't see what they were. Any suggestions? I wish I started on vbulletin but now I don't know if my upgrade will work? Thanks.[/QUOTE]

    The error is that you don't have your table prefix, thats why the tables are red.

    You can change the page speed in the impex config file, I'm guessing your table prefix is "smf_".
    I wrote ImpEx.

    Blog | Me

    Comment

    • halpern
      New Member
      • Apr 2006
      • 29

      #3
      I am having some issues with my "live" upgrade with impex..

      Valid found tables :

      darknewday_calendar found.

      Possiablly custom tables or incorrect prefix :

      darknewday_attachments NOT found.
      darknewday_banned NOT found.
      darknewday_board_permissions NOT found.
      darknewday_boards NOT found.
      darknewday_calendar_holidays NOT found.
      darknewday_categories NOT found.
      darknewday_collapsed_categories NOT found.
      darknewday_im_recipients NOT found.
      darknewday_instant_messages NOT found.
      darknewday_log_actions NOT found.
      darknewday_log_activity NOT found.
      darknewday_log_banned NOT found.
      darknewday_log_boards NOT found.
      darknewday_log_errors NOT found.
      darknewday_log_floodcontrol NOT found.
      darknewday_log_karma NOT found.
      darknewday_log_mark_read NOT found.
      darknewday_log_notify NOT found.
      darknewday_log_online NOT found.
      darknewday_log_polls NOT found.
      darknewday_log_topics NOT found.
      darknewday_membergroups NOT found.
      darknewday_members NOT found.
      darknewday_messages NOT found.
      darknewday_moderators NOT found.
      darknewday_permissions NOT found.
      darknewday_poll_choices NOT found.
      darknewday_polls NOT found.
      darknewday_settings NOT found.
      darknewday_smileys NOT found.
      darknewday_themes NOT found.
      darknewday_topics NOT found.
      darknewday_log_search NOT found.
      darknewday_sessions NOT found.

      If you have all red tables, i.e. none correct this could possible be your table prefix :

      darknewday_


      I am then getting an error:
      ImpEx Database errormysql error: Invalid SQL:
      SELECT * FROM darknewday_membergroups
      ORDER BY ID_GROUP
      LIMIT 0,50

      mysql error: Table 'darknewday_vbul.darknewday_membergroups' doesn't exist

      mysql error number: 1146

      Date: Saturday 13th of May 2006 01:28:31 PM
      Database: darknewday_vbul
      MySQL error: Table 'darknewday_vbul.darknewday_membergroups' doesn't exist


      How do i fix this? I didn't get this error yesterday when I tested the import on a dev machine..
      Last edited by halpern; Sat 13 May '06, 5:29am.
      Classic Film Fanatics
      http://www.classicfilmfanatics.com

      Comment

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

        #4
        This means that your table prefix is wrong. You need to use the correct one.
        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

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