Jump to the post that solved this thread.
Solved: 1 Month, 1 Week, 1 Day ago SQL Error while installing siedbar plugin.
#1
Solved: 1 Month, 1 Week, 1 Day ago
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?
Reply
#2
Solved: 1 Month, 1 Week, 1 Day ago
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
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM or Discord
Reply
#3
Solved: 1 Month, 1 Week, 1 Day ago
(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!


Attached Files
.php   latestposts.php (Size: 7.86 KB / Downloads: 9)
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)