347871 - Bad table conversion in upgrade process

Status: RESOLVED INVALID

(Bugzilla :: Installation & Upgrading, defect)

Description

[Mark T. Tomczak]

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

[Max Kanat-Alexander]

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.