• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

MySQL error when importing users

Garamond

Well-known member
#1
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
 

Mike

XenForo developer
Staff member
#4
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.
 

Mike

XenForo developer
Staff member
#5
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.