MyBB Community Forums
[Rejected] Plugin install errors when switching hosts - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Development (https://community.mybb.com/forum-161.html)
+--- Forum: MyBB 1.8 Development (https://community.mybb.com/forum-165.html)
+---- Forum: 1.8 Bugs and Issues (https://community.mybb.com/forum-157.html)
+----- Forum: Rejected (https://community.mybb.com/forum-184.html)
+----- Thread: [Rejected] Plugin install errors when switching hosts (/thread-217652.html)



Plugin install errors when switching hosts - BrianR - 2018-05-19

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.



RE: Plugin install errors when switching hosts - BrianR - 2018-05-27

Still getting this error.

strict mode is also turnedoff.


RE: Plugin install errors when switching hosts - Jockl - 2018-05-27

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


RE: Plugin install errors when switching hosts - BrianR - 2018-05-27

(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


RE: Plugin install errors when switching hosts - Ben - 2018-05-27

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.


RE: Plugin install errors when switching hosts - BrianR - 2018-05-27

(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.