Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Checksetup.pl error -- not an ARRAY reference

6 views
Skip to first unread message

MarkHB

unread,
Jan 2, 2008, 11:31:16 AM1/2/08
to
My case is similar to Nigel's in another thread, but different enough
that I didn't want to conmingle the two. I have been running a
departmental Bugzilla instance for several years (starting with 2.16
or 2.18, I think). We are in the process of migrating it to a vastly
superior piece of hardware, and have hit the "Not an ARRAY reference"
bug in cehcksetup.pl. Here are the steps I went through:

1. Upgraded MySQL on the old machine step-by-step from 3.23 to 5.0.
2. Upgraded bugzilla on the old machine to 3.0.2 from (whichever was
the last release to support MySQL 3.23)
3. Migrated the bugs DB from the old machine to the new server, and
then connecting remotely using the Bugzilla front end on the old
machine.
4. Installed Bugzilla 3.0.2 on the new machine, brought over the
localconfig info from the old machine per the instructions and
installed it.

So far, everything went fine. The issue comes when trying to run what
should be the final checksetup.pl on the new machine. We are at the
point of potentially letting checksetup create a fresh database; if
anyone has any suggestions about the best way to import my data from
an old db into a freshly-built one, please sing out. Or, of course,
if you have any info on this error. We have already checked for
multiple DBI installations.

Here is the complete output I am getting:

* This is Bugzilla 3.0.2 on perl 5.8.8
* Running on Linux 2.6.9-34.ELsmp #1 SMP Thu Mar 9 06:23:23 GMT 2006

Checking perl modules...
Checking for CGI (v2.93) ok: found v3.29
Checking for TimeDate (v2.21) ok: found v2.22
Checking for DBI (v1.41) ok: found v1.601
Checking for PathTools (v0.84) ok: found v3.25
Checking for Template-Toolkit (v2.12) ok: found v2.19
Checking for Email-Send (v2.00) ok: found v2.00
Checking for Email-MIME-Modifier (any) ok: found v1.442

Checking available perl DBD modules...
Checking for DBD-Pg (v1.45) not found
Checking for DBD-mysql (v2.9003) ok: found v3.0002

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.32
Checking for Template-GD (any) ok: found v1.56
Checking for Chart (v1.0) ok: found v2.4.1
Checking for GDGraph (any) ok: found v1.43
Checking for GDTextUtil (any) ok: found v0.86
Checking for XML-Twig (any) not found
Checking for MIME-tools (v5.406) ok: found v5.406
Checking for libwww-perl (any) ok: found v2.036
Checking for PatchReader (v0.9.4) ok: found v0.9.5
Checking for PerlMagick (any) not found
Checking for perl-ldap (any) ok: found v0.34
Checking for SOAP-Lite (any) ok: found v0.55
Checking for HTML-Parser (v3.40) ok: found v3.56
Checking for HTML-Scrubber (any) ok: found v0.07
Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.3
Checking for Email-Reply (any) ok: found v1.202
Checking for mod_perl (v1.999022) not found
Checking for CGI (v3.11) ok: found v3.29
Checking for Apache-DBI (v0.96) ok: found v1.05

* NOTE: You must run any commands listed below as root.

**********************************************************************
* OPTIONAL MODULES *
**********************************************************************
* Certain Perl modules are not required by Bugzilla, but by *
* installing the latest version you gain access to additional *
* features. *
* *
* The optional modules you do not have installed are listed below, *
* with the name of the feature they enable. If you want to install *
* one of these modules, just run the appropriate command in the *
* "COMMANDS TO INSTALL" section. *
**********************************************************************

***********************************************************************
* MODULE NAME * ENABLES FEATURE(S)
*
***********************************************************************
* XML-Twig * Move Bugs Between Installations
*
* PerlMagick * Optionally Convert BMP Attachments to PNGs
*
* mod_perl * mod_perl
*
***********************************************************************
COMMANDS TO INSTALL:

XML-Twig: /opt/ActivePerl-5.8.8.822/bin/perl-static -MCPAN -e
'install XML::Twig'
PerlMagick: /opt/ActivePerl-5.8.8.822/bin/perl-static -MCPAN -e
'install Image::Magick'
mod_perl: /opt/ActivePerl-5.8.8.822/bin/perl-static -MCPAN -e
'install mod_perl2'
Reading ./localconfig...
Checking for DBD-mysql (v2.9003) ok: found v3.0002
Checking for MySQL (v4.1.2) ok: found v5.0.24-standard-log


WARNING: We are about to convert your table storage format to UTF8.
This
allows Bugzilla to correctly store and sort international
characters.
However, if you have any non-UTF-8 data in your database,
it ***WILL BE DELETED*** by this process. So, before
you continue with checksetup.pl, if you have any non-UTF-8
data (or even if you're not sure) you should press Ctrl-C now
to interrupt checksetup.pl, and run contrib/recode.pl to make
all
the data in your database into UTF-8. You should also back up
your
database before continuing. This will affect every single
table
in the database, even non-Bugzilla tables.

If you ever used a version of Bugzilla before 2.22, we
STRONGLY
recommend that you stop checksetup.pl NOW and run contrib/
recode.pl.

Press Enter to continue or Ctrl-C to exit...Converting table
storage format to UTF-8. This may take a while.
Converting bugs_activity.added to be stored as UTF-8...
Converting bugs_activity.removed to be stored as UTF-8...

Not an ARRAY reference at /opt/ActivePerl-5.8.8.822/site/lib/DBD/
mysql.pm line 324, <DATA> line 228.
Segmentation fault

Max Kanat-Alexander

unread,
Jan 2, 2008, 6:25:58 PM1/2/08
to support-...@lists.mozilla.org
On Wed, 2 Jan 2008 08:31:16 -0800 (PST) MarkHB <mar...@maine.rr.com>
wrote:

> Not an ARRAY reference at /opt/ActivePerl-5.8.8.822/site/lib/DBD/
> mysql.pm line 324, <DATA> line 228.

Why are you using ActiveState Perl on Linux?

Anyhow, this indicates that your DBD::mysql is broken, and you
need to either get it from another source or reinstall it.

-Max
--
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.

Jeff

unread,
Jan 14, 2008, 11:27:20 PM1/14/08
to
I had this issue and found it was mysql defaulted to latin1, I need to reset
all the DB's to utf8

Works perfect now
"MarkHB" <mar...@maine.rr.com> wrote in message
news:56e8c7cf-c618-4310...@u10g2000prn.googlegroups.com...

0 new messages