Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Error: 1064 - You have an error in your SQL syntax
#1
Hello there

I switched to a new server when I enter the add-ons in the admin panel.

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 mybb_settinggroups WHERE name = 'myinsertbuttons'' at line 1 Query: SELECT COUNT(*) as rows FROM mybb_settinggroups WHERE name = 'myinsertbuttons'
Please contact the MyBB Group for technical support.

why is this the cause and how can I fix it

do not look up for english
Reply
#2
The keyword rows is a reserved keyword. See here.
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.
Reply
#3
(08-10-2018, 11:59 AM)Wires Wrote: The keyword rows is a reserved keyword. See here.

Thank you for your interest

I do not understand from the link you give me how to find a solution
Reply
#4
Unfortunately this issue is because of reserved words for MariaDB which cannot be used. This will be fixed in one of future releases.
[MyBB 1.8 Czech translation] [MyBB 1.8 plugins]: Prune old PMs + optimize DB plugin --- Thank you/like system
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)