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