If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

Bad table conversion in upgrade process




Installation & Upgrading
11 years ago
11 years ago


(Reporter: Mark T. Tomczak, Unassigned)





11 years ago
User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.10) Gecko/20060505 Firefox/1.0.4 (Debian package 1.0.4-2sarge7)
Build Identifier: Bugzilla debian 2.22-1

When using mysql-5.0 as the database backend, during the upgrade process from a previous version of bugzilla to this one the checksetup.pl script attempts to rename the table column votes.count to votes.vote_count. But the rename specifies '' as the default value, which is invalid for a SMALLINT field.

I'd fix it myself, but for the life of me I can't figure out where the configuration options are stored for the database column descriptions.

Reproducible: Always

Steps to Reproduce:
1. Install previous version of bugzilla and use it for a time.
2. Attempt to upgrade to this version
3. Read lots of perl; tear out hair ;)

Actual Results:  
The following error is reported:
"Changing column count in table votes to be named vote_count...
DBD::mysql::db do failed: Invalid default value for 'vote_count'"
(etc, etc)

Expected Results:  
Script should have renamed the 'votes' column to 'vote_count' and continued.

Comment 1

11 years ago
Wow, what version are you upgrading from? I think that code's pretty old.

Anyhow, all this means is that at some point you actually *set* that default on that column, or a broken mysqldump did for you. Just unset it before running checksetup.pl and you should be fine.
Last Resolved: 11 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.