MySQL error when importing users

raytrails

Well-known member
Got this while importing users from vBulletin 3.8.5:

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON (user.userid = userfield.userid) STRAIGHT_JOIN forumnameusertextfield A' at line 12
 
It looks like the change I made for 1.0.2 (fix major speed issues) may have ensured that the source DB needs to be 5.0, so that's going to be the best thing to do I think.
 
Hmm actually, STRAIGHT_JOIN is listed in the 3.23/4.0/4.1 MySQL manual.

I could try to debug this with FTP and admin CP details, though it may not be that important - bringing the data over to the current server is probably the easiest thing.
 
Top Bottom