[Rejected] Plugin install errors when switching hosts

[BrianR]

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.

[BrianR]

Still getting this error.

strict mode is also turnedoff.

[Jockl]

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

[BrianR]

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

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

[Ben]

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.

[BrianR]

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.