Ryan’s Tech Notes

While upgrading Bugzilla, I also came across this error when I ran the checksetup.pl script.

Removing index 'groups_name_idx' from the groups table...

DBD::mysql::db do failed: Incorrect table definition; there can be only one auto column and it must be defined as a key [for Statement "ALTER TABLE groups DROP PRIMARY KEY"] at Bugzilla/Install/DB.pm line 1394

Bugzilla::Install::DB::_convert_groups_system_from_groupset() called at Bugzilla/Install/DB.pm line 262

Bugzilla::Install::DB::update_table_definitions('HASH(0x8bf49c8)') called at ./checksetup.pl line 195

What does this error mean?

This error means that the script was unable to DROP the PRIMARY KEY on the groups TABLE, because that field has auto_increment turned on.

How do I fix this?

Turn off auto_increment in the groups table.

1) Look at the groups table

Linux# mysql
mysql> use bugs;
mysql> desc groups;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| bit | bigint(20) | NO | | 0 | |
| name | varchar(255) | NO | | | |
| description | text | NO | | | |
| isbuggroup | tinyint(4) | NO | | 0 | |
| userregexp | tinytext | NO | | | |
| isactive | tinyint(4) | NO | | 1 | |
| id | mediumint(9) | NO | PRI | NULL | auto_increment |
+-------------+--------------+------+-----+---------+----------------+

2) Modify the ID field of the groups table.

mysql> alter table groups modify id mediumint(9) not null;

3) Verify the changes in the groups table

mysql> desc groups;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| bit | bigint(20) | NO | | 0 | |
| name | varchar(255) | NO | | | |
| description | text | NO | | | |
| isbuggroup | tinyint(4) | NO | | 0 | |
| userregexp | tinytext | NO | | | |
| isactive | tinyint(4) | NO | | 1 | |
| id | mediumint(9) | NO | PRI | | |
+-------------+--------------+------+-----+---------+-------+

4) Re-run the checksetup.pl command