bugzilla installation error :“InnoDB is disabled your MySQL installation. Bugzilla requires InnoDb to be enabled.” even if innodb is enabled

[RAKHI N.R]

i have installed bugzilla4.2.5 in my windows7 machine. When i am ruuning
the checksetup.pl script of bugzilla , it showing that

Use of uninitialized value $innodb_on in string ne at
Bugzilla/DB/Mysql.pm line no 330."InnoDB is disabled your MySQL
installation. Bugzilla requires InnoDb to be enabled. Please enable it
and then re-runchecksetup.pl".

the code segement indicated by the line no in the Mysql.pm is the following

my ($innodb_on) = @{$self->selectcol_arrayref(
q{SHOW VARIABLES LIKE '%have_innodb%'}, {Columns=>[2]})};if
($innodb_on ne 'YES') {
die install_string('mysql_innodb_disabled');}

My Mysql installed version is 5.6.4-m7 . And i have found out that command SHOW
VARIABLES LIKE '%have_innodb% returns an empty set. But SHOW ENGINES shwing
the innodb and it is enabled and set as default.

I suppose the bugzilla showing error because SHOW VARIABLES LIKE
'%have_innodb% returns empty set inside the code in Mysql.pm file also.

http://bugs.mysql.com/bug.php?id=63383 this link showing that "have_innodb"
variable is removed from MySQL 5.6.1. Does that mean that i need to install
an older version of mysql that contain the "have_innodb" variable? Please
help me to solve the problem in the bugzilla installation.

[Thorsten Schöning]

Guten Tag RAKHI N.R,
am Dienstag, 12. März 2013 um 13:42 schrieben Sie:

> http://bugs.mysql.com/bug.php?id=63383 this link showing that "have_innodb"
> variable is removed from MySQL 5.6.1. Does that mean that i need to install
> an older version of mysql that contain the "have_innodb" variable?

That's what I would do in your place, you just have two options:
Change Bugzilla source code or use an older MySQL version.

Besides that, you should file a bug if not already done:

http://www.bugzilla.org/developers/reporting_bugs.html

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail:Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[danie...@gmail.com]

El martes, 12 de marzo de 2013 14:42:13 UTC+1, Thorsten Schöning escribió:
> Guten Tag RAKHI N.R,
>
> am Dienstag, 12. März 2013 um 13:42 schrieben Sie:
>
>
>
> > http://bugs.mysql.com/bug.php?id=63383 this link showing that "have_innodb"
>
> > variable is removed from MySQL 5.6.1. Does that mean that i need to install
>
> > an older version of mysql that contain the "have_innodb" variable?
>
>
>
> That's what I would do in your place, you just have two options:
>
> Change Bugzilla source code or use an older MySQL version.
>
>
>
> Besides that, you should file a bug if not already done:
>

Seems like someone filed a bug and there is a fix in
https://bugzilla.mozilla.org/show_bug.cgi?id=852560

I applied the changes described in the https://bugzilla.mozilla.org/attachment.cgi?id=726803&action=diff
diff section and it worked ok.
Regards,
Daniel Cañas