SQL error in ACP
#1
Hi,

one user of my plugin is having problem with SQL.
https://community.mybb.com/thread-189422...pid1279315

(07-19-2017, 08:38 PM)Azerkiller Wrote: Hello i have this error in admin panel plugins

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 WHERE name = 'rineditor'' at line 1
Query:
SELECT COUNT(*) as rows FROM mybb_settinggroups WHERE name = 'rineditor'

Unfortunately I have no idea what's wrong.

code of plugin here https://github.com/martec/Rin-Editor/blo...editor.php

If anyone can help me solve the problem I will be very grateful.
Reply
#2
looks like rows is a reserved word in mariaDB. changing it might help
Reply
#3
(07-20-2017, 02:36 PM).m. Wrote: looks like rows is a reserved word in mariaDB. changing it might help

thanks.
That must be it. Was added in MariaDB 10.2.4
https://mariadb.com/kb/en/mariadb/reserved-words/
Reply
#4
Other user experiencing an error that I can not solve.
Unfortunately I have no idea what's wrong.

https://community.mybb.com/thread-189422...pid1280372
https://community.mybb.com/thread-189422...pid1280584

If anyone can help me solve the problem I will be very grateful.
Reply
#5
(07-20-2017, 02:36 PM).m. Wrote: looks like rows is a reserved word in mariaDB. changing it might help

I have the same problem with 2 plugins.

My Insert Buttons

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 WHERE name = 'myinsertbuttons'' at line 1

Query:SELECT COUNT(*) as rows FROM mybb_settinggroups WHERE name = 'myinsertbuttons'


Online Today

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



@.m.  can u explain more in details

or

can i PM you Cpanel acess and forum to have a look ?
Reply
#6
^ if the plugin has a data field named rows then that should be changed to something else.

if you are not comfortable in modifying the plugin file(s) then you may PM me the temporary access
Reply
#7
THNX now all works gr8 Smile

I edited / modified PHP plugin files with notepad -replaced (CTRL + H) word rows with something else.



If somebody get the same error or similar one good to know ...



MariaDB / MySQL Reserved words https://mariadb.com/kb/en/the-mariadb-li...ved-words/

MariaDB / MySQL error codes  https://mariadb.com/kb/en/the-mariadb-li...ror-codes/
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)