1464686 - error with syntax for create table groups

Status: RESOLVED DUPLICATE of bug 1424043

(Bugzilla :: Bugzilla-General, defect)

Description

[aitheory]

Attachment: error

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/17.17134

Steps to reproduce:

typed:

 sudo ./checksetup.pl


Actual results:

received a message that said "adding new table groups..." then saw:

DBD::MySQL::db failed because of a sql syntax error


Expected results:

checksetup.pl should have completed without any errors.

NOTE: the version I am using is version 5.0.4

Comment 1

[Ernst]

MySQL 8.0.2 has made the word “groups” a “reserved” word - - so the checksetup.pl aborts the table creation when it gets to that table. If you “show tables” you will find 32 tables were created.

PostgreSQL will allow table and column creation using the word “groups”.

The SQL 2011 standard has made the word “groups” reserved (as mentioned in the PostgreSQL documentation, Appendix C).

I spent quite a lot of time on this...and after tracking/tracing the scripts used to create the “bugs” database (I foolishly thought bugzilla might make a better database name) — this seems like a problem for the Perl experts on the Bugzilla team.

Perhaps using a older version of MySQL?