310755 - Checksetup.pl fails with the error "DO: Something wrong while try to prepare query This command is not supported in"

Status: RESOLVED INVALID

(Bugzilla :: Installation & Upgrading, defect)

Description

[sanjeevns]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Build Identifier: 

./checksetup.pl fails on my setup.

I'm trying to install bugzilla on the following system:

OS: Fedora Core 4 (linux)
MySQL server/client version: 4.1.14
Perl version: 5.8.6
Apache httpd version: 2.0.54
Bugzilla version trying to install: 2.20

I downloaded the latest bugzilla tarball bugzilla-2.20.tar.gz and extracted the 
contents under /var/www/html/.

With MySQL server running and all the necessary perl modules installed, I 
run ./checksetup.pl.

================================================================
[root@p1330ux310 bugzilla-2.20]#
[root@p1330ux310 bugzilla-2.20]# ./checksetup.pl

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.10
Checking for    Data::Dumper (any)     ok: found v2.121_02
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.38)   ok: found v1.48
Checking for      File::Spec (v0.84)   ok: found v3.01
Checking for      File::Temp (any)     ok: found v0.16
Checking for        Template (v2.08)   ok: found v2.14
Checking for      Text::Wrap (v2001.0131) ok: found v2001.09292
Checking for    Mail::Mailer (v1.65)   ok: found v1.67
Checking for        Storable (any)     ok: found v2.13

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v2.28
Checking for     Chart::Base (v1.0)    ok: found v2.3
Checking for     XML::Parser (any)     ok: found v2.34
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18
Checking for     PatchReader (v0.9.4)  ok: found v0.9.5

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for      DBD::mysql (v2.9003) ok: found v3.0002_3
Checking for           MySQL (v3.23.41) ok: found v4.1.14-standard
Creating database bugs ...
DO: Something wrong while try to prepare query This command is not supported in
the prepared statement protocol yet
Use of uninitialized value in concatenation (.) or string at ./checksetup.pl lin
e 1518.

The 'bugs' database could not be created.  The error returned was:



This might have several reasons:

* MySQL is not running.
* MySQL is running, but there is a problem either in the
  server configuration or the database access rights. Read the Bugzilla
  Guide in the doc directory. The section about database configuration
  should help.
* There is a subtle problem with Perl, DBI, or MySQL. Make
  sure all settings in './localconfig' are correct. If all else fails, set
  '$db_check' to zero.

[root@p1330ux310 bugzilla-2.20]#

==============================================================================

The MySQL database the table 'bugs' isn't created yet.

mysql>
mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.00 sec)

===============================================================================

I created the database 'bugs' by hand, 

mysql> create database bugs;
Query OK, 1 row affected (0.00 sec)

===============================================================================

Ran the ./checksetup.pl again.

[root@p1330ux310 bugzilla-2.20]# ./checksetup.pl

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.10
Checking for    Data::Dumper (any)     ok: found v2.121_02
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.38)   ok: found v1.48
Checking for      File::Spec (v0.84)   ok: found v3.01
Checking for      File::Temp (any)     ok: found v0.16
Checking for        Template (v2.08)   ok: found v2.14
Checking for      Text::Wrap (v2001.0131) ok: found v2001.09292
Checking for    Mail::Mailer (v1.65)   ok: found v1.67
Checking for        Storable (any)     ok: found v2.13

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v2.28
Checking for     Chart::Base (v1.0)    ok: found v2.3
Checking for     XML::Parser (any)     ok: found v2.34
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18
Checking for     PatchReader (v0.9.4)  ok: found v0.9.5

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for      DBD::mysql (v2.9003) ok: found v3.0002_3
Checking for           MySQL (v3.23.41) ok: found v4.1.14-standard

DBD::mysql::db selectrow_array warning:  [for Statement "SELECT COUNT(*) FROM bz
_schema"] at Bugzilla/DB.pm line 799.
Building Schema object from database...
Adding new table bz_schema ...
Initializing the new Schema storage...
panic: malloc at Bugzilla/DB.pm line 860.
        (in cleanup) panic: malloc.
DBI handle 0x8487a54 cleared whilst still active.
DBI handle 0x8487a54 has uncleared implementors data.
    dbih_clearcom (sth 0x8487a54, com 0x91a4f00, imp DBD::mysql::st):
       FLAGS 0x12a097: COMSET IMPSET Active Warn HandleError RaiseError PrintWar
n ShowErrorStatement TaintIn
       PARENT DBI::db=HASH(0x93557c4)
       KIDS 0 (0 Active)
       IMP_DATA undef
       NUM_OF_FIELDS 2
       NUM_OF_PARAMS 0
[root@p1330ux310 bugzilla-2.20]#

===============================================================================

Looks like some issue with the setup (perhaps the versions of Perl, DBI and 
MySQL). Can someone please look into this issue?

Reproducible: Always

Comment 1

[Max Kanat-Alexander]

> Checking for      DBD::mysql (v2.9003) ok: found v3.0002_3

  You are using a developer (unstable) release of DBD::mysql. Try using just the
normal 3.0002, not an unreleased version.

  If that doesn't fix it, re-open the bug.