how to fix bugzilla 4.4 to work with MySQL 5.6

Rafnews raf.news at gmail.com
Sun Apr 14 18:44:01 UTC 2013


Hi,

i fixed a bug to make bugzilla works under MySQL 5.6.
in fact, in /Bugzilla/DB/mysql.pm file on line 310, you need to replace 
(improve code) with the following code:
my ($innodb_on) = @{$self->selectcol_arrayref(
         # q{SHOW VARIABLES LIKE '%have_innodb%'}, {Columns=>[2]})};
         q{SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE LIKE 
'%Innodb'}, {Columns=>[2]})};
     #if ($innodb_on ne 'YES') {
     if ($innodb_on eq 'NO') {
         die install_string('mysql_innodb_disabled');
     }

in fact in MySQL 5.6 variable have_innodb does not exist anymore instead 
of that you need to use: SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE 
ENGINE LIKE '%Innodb' and to test with NO as it can be DEFAULT or YES 
for SUPPORT column.

HTH.

Alain R.
www.rogtek.com
www.facebook.com/rogtek




More information about the developers mailing list