Closed
Bug 347871
Opened 18 years ago
Closed 18 years ago
Bad table conversion in upgrade process
Categories
(Bugzilla :: Installation & Upgrading, defect)
Tracking
()
RESOLVED
INVALID
People
(Reporter: mtomczak, Unassigned)
Details
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•18 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
Closed: 18 years ago
Resolution: --- → INVALID
You need to log in
before you can comment on or make changes to this bug.
Description
•