[*SOLVED*]This error is caused by an incompatibility with another 3rd party plugin.
Someone else brought this to my attention after installing VbSSO, but new users cannot register and it throws a databases error.
*update* The new user actually is created, however there seem to be missing/broken tables for that user. Upon logging in there are more database errors before the forums can be accessed.
Should there be a value at the end of the SQL line before the 'LIMIT 1?'
Or can SELECT TOP 1 * be used instead of LIMIT all together?
Code:
<!--
Database error in vBulletin 3.8.6:
Invalid SQL:
SELECT * FROM `vbsso_users` WHERE `vbuserid` = LIMIT 1;
MySQL 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 'LIMIT 1' at line 1
Error Number : 1064
Script : http://www.mysite.com/forums/register.php?do=addmember
Referrer : https://www.mysite.com/forums/register.php?do=register
-->
Oh and I'm running SQL version 5.1.63, thanks.