1874590 - Error running checksetup.pl with MySql Db

Status: RESOLVED DUPLICATE of bug 1592129

(Bugzilla :: Database, defect)

Description

[Abdel Diaz]

DBD::mysql::db do failed: 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 'groups (
id mediumint auto_increment PRIMARY KEY NOT NULL,
name varchar(255) N' at line 1 [for Statement "CREATE TABLE groups (
id mediumint auto_increment PRIMARY KEY NOT NULL,
name varchar(255) NOT NULL,
description mediumtext NOT NULL,
isbuggroup tinyint NOT NULL,
userregexp tinytext DEFAULT '' NOT NULL,
isactive tinyint DEFAULT 1 NOT NULL,
icon_url tinytext
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT=Compact"] at Bugzilla/DB.pm line 64.
Bugzilla::DB::ANON(Bugzilla::DB::Mysql=HASH(0x283b04e5850), "CREATE TABLE groups (\x{a}\x{9}id\x{9}mediumint auto_increment PRIMARY KE"...) called at Bugzilla/DB.pm line 883
Bugzilla::DB::_bz_add_table_raw(Bugzilla::DB::Mysql=HASH(0x283b04e5850), "groups", HASH(0x283b06cac38)) called at Bugzilla/DB.pm line 844
Bugzilla::DB::bz_add_table(Bugzilla::DB::Mysql=HASH(0x283b04e5850), "groups", HASH(0x283b06cac38)) called at Bugzilla/DB.pm line 553
Bugzilla::DB::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x283b04e5850)) called at Bugzilla/DB/Mysql.pm line 586
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x283b04e5850)) called at .\checksetup.pl line 123

Comment 2

[Dave Miller [:justdave]]

The short version is, until this is fixed, use MariaDB instead.