509548 - UTF-8 conversion errors in checksetup.pl

Status: RESOLVED DUPLICATE of bug 508181

(Bugzilla :: Installation & Upgrading, defect)

Description

[Charles Gillet]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.2) Gecko/20090803 Fedora/3.5.2-2.fc11 Firefox/3.5.2
Build Identifier: 3.4.1

checksetup.pl UTF-8 conversion stops while trying to convert the "setting" table with Errno 150

Reproducible: Always

Steps to Reproduce:
1. Start with 3.0.6 MySQL database instance with UTF-8 off
2. run contrib/recode --guess
3. run checksetup.pl (mainly converts to InnoDB during this run)
4. Turn on UTF-8 setting in bugzilla admin interface
5. run checksetup.pl again
Actual Results:  
DBD::mysql::db do failed: Error on rename of './bugs_dev/#sql-4e5_2fc0' to './bugs_dev/setting' (errno: 150) [for Statement "ALTER TABLE setting CHANGE COLUMN name name                                                                                                                                                                      
                              varchar(32) CHARACTER SET binary NOT NULL"] at Bugzilla/DB/Mysql.pm line 767                                                             
        Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0xb8bc0f4)') called at ./checksetup.pl line 140      

Expected Results:  
clean finish with no errors