MyBB Community Forums

Can anyone update this plug-in to work with latest MYBB and MYSQL (or Mariana) ?

What is the issue you find while using it or attempting to use it ?

(2023-07-23, 06:11 AM)Omar G. Wrote: [ -> ]What is the issue you find while using it or attempting to use it ?

when I open plug-in directory in ACP this error occur:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rows FROM mybb_settinggroups WHERE name='scd_hide_fg'' at line 1
>Query:
>SELECT COUNT(*) as rows FROM mybb_settinggroups WHERE name='scd_hide_fg'

any help?

ROWS is a reserved keyword in SQL, and should be changed to a different name.
https://en.wikipedia.org/wiki/List_of_SQ...rved_words

Obviously, if it is used elsewhere in the code, it should be changed accordingly.