+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Extensions (https://community.mybb.com/forum-201.html)
+--- Forum: Plugins (https://community.mybb.com/forum-73.html)
+---- Forum: Plugin Support (https://community.mybb.com/forum-72.html)
+---- Thread: MySQL error... (/thread-149591.html)
MySQL error... - Makos - 2014-01-03
Link to forum here: http://www.doutaini.lindsiria.net
I have a user unable to login because she receives the following error:
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1064 - 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 '' at line 1
Query
ELECT as_canswitch FROM mybb_usergroups WHERE gid=Please contact the MyBB Group for support.
As far as I am aware, this error is not currently affecting anyone else. I do use the account switcher plugin. The user group she is in does have appropriate permissions for the AS. I'm not sure what I need to do to resolve this issue. She has attempting wiping cookies and everything and logging in after being shifted to a group I know is entirely functional. I have tried logging on to her account and also receive the same error. However, she is able to create new accounts just fine.
Thoughts?
RE: MySQL error... - SunDi3yansyah - 2014-01-04
problem your host
RE: MySQL error... - Makos - 2014-01-04
Any specifics?
RE: MySQL error... - Destroy666 - 2014-01-04
Which account switcher, made by who? Add URL to download it or show the code here.
See also this: http://community.mybb.com/thread-133701-post-967818.html#pid967818 You probably deleted someone, that's what created errors.
Additionally, you may want to disable it and try another (if that's not the same) plugin: https://github.com/doylecc/EnhancedAccountSwitcher