MyBB Community Forums

Hello!

I'm using a Focus theme in my myBB forum. I installed a few plugins but when I try to install "Latest Posts in sidebar (1.1) by SvePu" I have that message error:

Quote: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 mb_settinggroups' at line 1
Query:
SELECT COUNT(*) as rows FROM mb_settinggroups
If you're a visitor of this website, please wait a few minutes and try again. If this problem persists, please contact the site owner.

If you are the site owner, please check the MyBB Documentation for help resolving common issues, or get technical help on the MyBB Community Forums.

Can anyone help me with this?

rows is a reserved keyword, change its occurences with "nbrows" (it's an example) in the plugin, both in SQL queries and in PHP use of the query result.

I didn't find the plugin link on the extend part, so I can't help you anymore

(2021-09-17, 11:12 PM)Crazycat Wrote: [ -> ]rows is a reserved keyword, change its occurences with "nbrows"  (it's an example) in the plugin, both in SQL queries and in PHP use of the query result.

I didn't find the plugin link on the extend part, so I can't help you anymore

Thank you a lot! That's a very kind of you, but I've managed it by myself. And also I deleted a problem with doubled sidebar.
If anyone have a trouble like this - here, this is the fixed file. Just copy this into your inc/plugin folder and replace the old one of course. 

Thank you again and that's all, problem solved!