jfaulk
Sat 29th Jan '05, 4:16pm
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
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