MyBB Community Forums

Full Version: Plugin Issue after 1.8.23 Update
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have a MyBB SQL Error on the Admin CP Plugins page after I updated my forum (https://skylandsacademy.com/). Is there a fix?


Quote: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 mybb0u_settinggroups WHERE name = 'yuishoutbox'' at line 1 Query: SELECT COUNT(*) as rows FROM mybb0u_settinggroups WHERE name = 'yuishoutbox'
rows is a reserved keyword with mariadb. Modify the queries (and associated PHP) to use something like nbrows instead.
If you don't know how to do, ask the plugin developper (which have to upgrade his plugin).
Thanks! I looked around spotted the problem, I had to delete a plugin I tried out and stopped using ages ago. ^^;