Announcement

Collapse
No announcement yet.

Snitz Impex Error...Module 2

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

  • Snitz Impex Error...Module 2

    When running the import I get the following error from Module 2 - Associate Users:

    Database error in vBulletin:ImpEx Source 3.0.6:
    Invalid SQL:
    SELECT MEMBER_ID, M_NAME
    FROM MEMBERS
    ORDER BY MEMBER_ID
    LIMIT 0,25
    mysql error: Table 'sfstest1a.MEMBERS' doesn't exist
    mysql error number: 1146

    The sourcedatabase is 'sfstest1a' and I removed the 'FORUM_' table prefixes when I converted from MSSQL to MySQL. The database is there as 'members', I can access it through phpmyadmin. I also have tried many different tableprefix settings ('FORUM_', 'sfstest1a', etc) in the ImPexConfig.php, but I expect it should be blank. I have also tried recopying all the source files (just to be sure).

    Any assistance would be greatly appreciated.

    Thanks-
    JFaulk

  • #2
    I'm guessing its the case, is the MySQL table "MEMBERS" or "members" ?
    I wrote ImpEx.

    Blog | Me

    Comment

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