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

RESOLVED INVALID

Status

()

Bugzilla
Installation & Upgrading
--
major
RESOLVED INVALID
11 years ago
11 years ago

People

(Reporter: Mark T. Tomczak, Unassigned)

Tracking

Details

(Reporter)

Description

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.
Status: UNCONFIRMED → RESOLVED
Last Resolved: 11 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.