MyBB Community Forums

Whenever I install a new plugin, it doesn't work, I keep getting some weird MySQL 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 MariaDB server version for the right syntax to use near 'rows FROM mybb_settinggroups' at line 1
Query:
SELECT COUNT(*) as rows FROM mybb_settinggroups
Please contact the MyBB Group for technical support.

Still getting this error.

strict mode is also turnedoff.

Maybe this thread can be of any help....

(2018-05-27, 10:59 AM)Jockl Wrote: [ -> ]Maybe this thread can be of any help....

Whenever I try to change that data field in the plugin, the plugin breaks

Is it just one plugin specifically this error happens? You should try and install multiple plugins to see if this issue is maybe a plugin issue rather than MyBB.

(2018-05-27, 05:15 PM)Ben Wrote: [ -> ]Is it just one plugin specifically this error happens? You should try and install multiple plugins to see if this issue is maybe a plugin issue rather than MyBB.

It's only like 2 plugins that it's happening to at the moment.