All queries report "ARRAY(0x...) instead of query terms. 4.0.7 buglist.cgi

[eir...@gmail.com]

I'm migrating a Bugzilla 4.0.7 installation from Linux to Windows. I plan to get it running on Windows and then upgrade one major Bugzilla release at a time until I reach the latest stable Bugzilla version.

When I do any queries right now, I get "Zarro bugs found" and each field I search by is followed by "ARRAY(0x...) where "..." is the end of a hex value that changes every time I repeat the search. For example:

Product: ARRAY(0x4187738)

Any idea what's wrong here? I don't know. Happy to provide more details if needed.

Perl is provided via ActiveState 5.22.2.2202.

[eir...@gmail.com]

If I enter a bug # in the header's search field, that bug displays in show_bug.cgi and nothing looks amiss.

[Thorsten Schöning]

Guten Tag eir...@gmail.com,
am Mittwoch, 7. Februar 2018 um 17:11 schrieben Sie:

> Product: ARRAY(0x4187738)

That is a bug somewhere, the software expects to have one so called
scalar value only, very likely a plain string in this case, but got a
reference to a array which gets stringified because the software
expects printing a string. That shouldn't happen, someone is simply
providing wrong data for some reason.

This might be a bug in Bugzilla in your version or some feature of
Perl is used which was either removed in your version of Perl or not
yet added. Perl provides control structures to iterate arrays and
those e.g. didn't support iterating array references directly, but
that has been added in some versions of Perl to make handling easier
and than removed again because it broke things or such.

So you have two choices: Compare the both versions of Perl you are
using on the old and new system and read about the changes between
both.

Upgrade Bugzilla now to see if this behaviour has been changed in
newer versions. You don't need to upgrade step by step anyway,
directly use the latest stable version. Direct upgrades of this kind
are supported.

https://bugzilla.readthedocs.io/en/5.0/installing/upgrading.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

[eir...@gmail.com]

Thank you, Thorsten. I'll probably go the Bugzilla upgrade route.

[eir...@gmail.com]

Could this checksetup.pl error be related?

Use of uninitialized value in pattern match (m//) at C:/Perl64/lib/ExtUtils/MM_Win32.pm line 40.
Use of uninitialized value in pattern match (m//) at C:/Perl64/lib/ExtUtils/MM_Win32.pm line 41.
Use of uninitialized value in pattern match (m//) at C:/Perl64/lib/ExtUtils/MM_Win32.pm line 42.

My full checksetup.pl output:

C:\bugzilla>.\checksetup.pl
Use of uninitialized value in pattern match (m//) at C:/Perl64/lib/ExtUtils/MM_Win32.pm line 40.
Use of uninitialized value in pattern match (m//) at C:/Perl64/lib/ExtUtils/MM_Win32.pm line 41.
Use of uninitialized value in pattern match (m//) at C:/Perl64/lib/ExtUtils/MM_Win32.pm line 42.
* This is Bugzilla 4.0.7 on perl 5.22.2
* Running on Win2012 Build 9600

Checking perl modules...
Checking for CGI.pm (v3.51) ok: found v4.26
Checking for Digest-SHA (any) ok: found v5.95
Checking for TimeDate (v2.21) ok: found v2.24
Checking for DateTime (v0.28) ok: found v1.36
Checking for DateTime-TimeZone (v0.79) ok: found v2.01
Checking for DBI (v1.614) ok: found v1.634
Checking for Template-Toolkit (v2.22) ok: found v2.26
Checking for Email-Send (v2.16) ok: found v2.201
Checking for Email-MIME (v1.904) ok: found v1.937
Checking for URI (any) ok: found v1.71
Checking for List-MoreUtils (v0.22) ok: found v0.413

Checking available perl DBD modules...
Checking for DBD-mysql (v4.00) ok: found v4.033
Checking for DBD-Pg (v1.45) ok: found v3.5.3
Checking for DBD-Oracle (v1.19) not found

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.56
Checking for Chart (v2.1) ok: found v2.4.10
Checking for Template-GD (any) ok: found v1.56
Checking for GDTextUtil (any) ok: found v0.86
Checking for GDGraph (any) ok: found v1.52
Checking for MIME-tools (v5.406) ok: found v5.507
Checking for libwww-perl (any) ok: found v6.15
Checking for XML-Twig (any) ok: found v3.49
Checking for PatchReader (v0.9.4) ok: found v0.9.6
Checking for perl-ldap (any) ok: found v0.65
Checking for Authen-SASL (any) ok: found v2.16
Checking for RadiusPerl (any) not found
Checking for SOAP-Lite (v0.712) ok: found v1.19
Checking for JSON-RPC (any) ok: found v0.96
Checking for JSON-XS (v2.0) ok: found v3.02
Checking for Test-Taint (any) ok: found v1.06
Checking for HTML-Parser (v3.67) ok: found v3.72
Checking for HTML-Scrubber (any) ok: found v0.15
Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.317
Checking for Email-Reply (any) ok: found v1.204
Checking for TheSchwartz (any) not found
Checking for Daemon-Generic (any) not found
Checking for mod_perl (v1.999022) not found
Checking for Apache-SizeLimit (v0.93) not found
Checking for Math-Random-Secure (v0.05) ok: found v0.06
Checking for Win32-API (any) ok: found v0.84
***********************************************************************
* 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. Below that table are the *
* commands to install each module. *
***********************************************************************
* MODULE NAME * ENABLES FEATURE(S) *
***********************************************************************
* RadiusPerl * RADIUS Authentication *
* TheSchwartz * Mail Queueing *
* Daemon-Generic * Mail Queueing *
* mod_perl * mod_perl *
* Apache-SizeLimit * mod_perl *
***********************************************************************
COMMANDS TO INSTALL OPTIONAL MODULES:

RadiusPerl: ppm install RadiusPerl
TheSchwartz: ppm install TheSchwartz
Daemon-Generic: ppm install Daemon-Generic
mod_perl: ppm install mod_perl
Apache-SizeLimit: ppm install Apache-SizeLimit

Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

http://cyberelk.net/tim/patchutils/

Checking for DBD-mysql (v4.00) ok: found v4.033

Removing existing compiled templates...
Precompiling templates...done.


Warning: You have set webservergroup in ./localconfig Please understand
that this does not bring you any security when running under Windows.
Verify that the file permissions in your Bugzilla directory are
suitable for your system. Avoid unnecessary write access.

Checking for GraphViz (any) not found
not a valid executable: /usr/bin

C:\bugzilla>

[Thorsten Schöning]

Guten Tag eir...@gmail.com,
am Mittwoch, 7. Februar 2018 um 20:27 schrieben Sie:

> Could this checksetup.pl error be related?

> Use of uninitialized value in pattern match (m//) at
> C:/Perl64/lib/ExtUtils/MM_Win32.pm line 40.

No, that's a different warning. It tells you that the module is
expecting to work on data which is not available in your case, seems
to be missing some compiler name or path or such. That might perfectly
be OK and only bad style of the module, as you don't run into any
compiler errors.

[eir...@gmail.com]

Thank you. Then I will upgrade Bz now.

My old box (Linux) is running Perl 5.8.8 and new box (Windows) is running Perl 5.22.2. I don't want to downgrade Perl — seems better to upgrade Bz.

[eir...@gmail.com]

Upgrading from Bugzilla 4.0.7 to Bugzilla 5.0.3 fixed both problems:

- checksetup.pl: Use of uninitialized value in pattern match (m//) at C:/Perl64/lib/ExtUtils/MM_Win32.pm line 40.
- buglist.cgi "ARRAY(0x...)" hex value instead of product name or other search term string.

Still running ActiveState ActivePerl 5.22.2.

Thanks again, Thorsten!