Closed Bug 457524 Opened 16 years ago Closed 15 years ago

Reports don't calculate totals correctly if one of the axes contain utf-8 data

Categories

(Bugzilla :: Reporting/Charting, defect)

3.1.4
defect
Not set
major

Tracking

()

RESOLVED FIXED
Bugzilla 3.4

People

(Reporter: masha_s84, Assigned: LpSolit)

References

Details

(Whiteboard: [requires TT 2.22][relnote for 3.2.5])

Attachments

(1 file, 7 obsolete files)

User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ru; rv:1.9.0.2) Gecko/2008091620 Firefox/3.0.2 Build Identifier: 3.1.4 I have installed Bugzilla 3.1.4 on FreeBSD 7.0. I installed Russian Localization. I have created some Components with Russian names and some components with English names. After that I have created bug with Russian component and have created bug with English component. After that I select table report and select Components for X axis and Status for Y axis and Generate report. Where was the table with Russian and English components(Rows) and Status of the bugs(Colums).But At Russian Components there are nothing (no count of the bugs) and At English Components - count of the bugs was correct. Reproducible: Always Steps to Reproduce: 1.Install Bugzilla 3.1.4 2.Install Russian localization for ver. 3.1.4 3.Create some Comonents with Russian names (on russian language). 4.Create some bugs with selecting this russian components. 5.Generate table report with Components for X axis and Status of the bug for Y axis; Actual Results: At the total will be null and at the cells will be nothing. Expected Results: Count of the bugs in the table should be correct (as with english names) code - utf8 (all properties are default)
Attached image Table report (obsolete) (deleted) —
Table report
Version: unspecified → 3.1.4
Vitaly, can you reproduce?
Yesterday I have installed the version 3.0.5.And at 3.0.5 this bug doesn't reproduse, but 3.0.5 have another bug: If my Product have name "Мой продукт" (Russian name of "My product") at the Search(My bugs) with list of bugs( with column Product) it displayed as "Мой ?" (Russian name as "My ?"). Please can you help me?
(In reply to comment #4) > but 3.0.5 have another bug: ... displayed as "Мой ?" (Russian name as "My ?"). You describe a symptom of bug 363153. > Please can you help me? Mary, kindly keep this topic around comment 0. With Bugzilla-ru support questions you are welcome at http://forum.mozilla-russia.org/viewforum.php?id=31. or http://sourceforge.net/tracker/?group_id=66973 if you prefer English :-)
So, Vitaly, is this a valid core Bugzilla bug or not? Or is it a bug with bugzilla-ru?
Unable to reproduce for 3.2rc1+, with MySQL v5.0.27-community-nt Results do not depend on client locale. Moreover, attachment 340783 [details] looks quite peculiar, as my tests do not show lines with empty sets at all. Mary, we need more data on your MySQL version and environment.
Marking as WFM. Reopen if you can reproduce the problem.
Status: UNCONFIRMED → RESOLVED
Closed: 16 years ago
Resolution: --- → WORKSFORME
My environment: server - FreeBSD 7.0, mysql ver 5.1.26, bugzilla ver 3.1.4 + localization for it. Client:Windows XP (rus)+ SP2, Mozilla or IE - for connect to bugzilla. (In reply to comment #7) as my tests do not show lines > with empty sets at all. > If I hadn't create bugs -and at my report they had not been shown on it. But this bug is :" I have created bug with Russian components but at report are empty rows, but should be an sum of the bugs for this Component". When I click to cell "Total" with number "0" I will be moved to the Search Page and in this page all of the bugs will be shown exactly. Tomorrow I'll attach video with this bug. What environment are you need from me more?
I could reproduce with Japanese named component. (3.2RC1+) Bar and line are ok, but table and csv are wrong.
error on Apache log. [error] report.cgi: Argument "" isn't numeric in addition (+) at template/en/default/reports/report-table.html.tmpl line 112. [error] report.cgi: Argument "" isn't numeric in addition (+) at template/en/default/reports/report-table.html.tmpl line 114. I think this is something a bug in templates. # but i couldn't find something to resolv this...
reopening this with discussions on irc.
Status: RESOLVED → UNCONFIRMED
Resolution: WORKSFORME → ---
(In reply to comment #11) > I could reproduce with Japanese named component. (3.2RC1+) > Bar and line are ok, but table and csv are wrong. This is the same for the pure english template and japanese localization (without customizations).
Confirmed NOT reproducible on CVS tip: * This is Bugzilla 3.3 on perl 5.8.7 * Running on WinXP/.Net Build 2600 (Service Pack 2) Checking perl modules... Checking for CGI.pm (v3.21) ok: found v3.38 Checking for TimeDate (v2.21) ok: found v2.22 Checking for DateTime (v0.28) ok: found v0.4304 Checking for PathTools (v0.84) ok: found v3.05 Checking for DBI (v1.41) ok: found v1.53 Checking for Template-Toolkit (v2.15) ok: found v2.15 Checking for Email-Send (v2.16) ok: found v2.181 Checking for Email-MIME (v1.861) ok: found v1.861 Checking for Email-MIME-Modifier (v1.442) ok: found v1.442 Checking available perl DBD modules... Checking for DBD-Pg (v1.45) not found Checking for DBD-mysql (v4.00) ok: found v4.005 Checking for DBD-Oracle (v1.19) not found The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.16 Checking for Chart (v1.0) ok: found v2.3 Checking for Template-GD (any) ok: found v1.56 Checking for GDTextUtil (any) ok: found v0.86 Checking for GDGraph (any) ok: found v1.43 Checking for XML-Twig (any) ok: found v3.26 Checking for MIME-tools (v5.406) ok: found v5.411 Checking for libwww-perl (any) ok: found v2.033 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 SASL-Authen (any) not found Checking for RadiusPerl (any) not found Checking for SOAP-Lite (any) ok: found v0.55 Checking for HTML-Parser (v3.40) ok: found v3.46 Checking for HTML-Scrubber (any) ok: found v0.08 Checking for Email-MIME-Attachment-Stripper (any) not found Checking for Email-Reply (any) not found Checking for mod_perl (v1.999022) ok: found v2.000003 Checking for CGI.pm (v3.11) ok: found v3.38 Checking for DBD-mysql (v4.00) ok: found v4.005 Checking for MySQL (v4.1.2) ok: found v5.0.27-community-nt Troubled hash works: $VAR2 = { "\x{420}\x{430}\x{437}\x{434}\x{435}\x{43b} 1" => { 'Product 1' => 1, 'TestProduct' => 0, "\x{41f}\x{440}\x{43e}\x{434}\x{443}\x{43a}\x{442} 4" => 1, "\x{41f}\x{440}\x{43e}\x{434}\x{443}\x{43a}\x{442} 3" => 1, 'Product 2' => 1 },
Not reproduced on 3.1.4 in the same environment either.
At My computer (server) where this bug is reprodused: freeserver# ./checksetup.pl * This is Bugzilla 3.1.4 on perl 5.8.8 * Running on FreeBSD 7.0-RELEASE FreeBSD 7.0-RELEASE #3: Fri Aug 22 22:20:09 MSD 2008 root@freeserver:/usr/obj/usr/src/sys/MIKEKERN Checking perl modules... Checking for CGI.pm (v2.93) ok: found v3.15 Checking for TimeDate (v2.21) ok: found v2.22 Checking for PathTools (v0.84) ok: found v3.12 Checking for DBI (v1.41) ok: found v1.604 Checking for Template-Toolkit (v2.15) ok: found v2.20 Checking for Email-Send (v2.00) ok: found v2.192 Checking for Email-MIME (v1.861) ok: found v1.861 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 (v4.00) ok: found v4.006 Checking for DBD-Oracle (v1.19) not found The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.39 Checking for Chart (v1.0) ok: found v2.4.1 Checking for Template-GD (any) ok: found v1.56 Checking for GDTextUtil (any) ok: found v0.86 Checking for GDGraph (any) ok: found v1.44 Checking for XML-Twig (any) ok: found v3.32 Checking for MIME-tools (v5.406) not found Checking for libwww-perl (any) ok: found v5.814 Checking for PatchReader (v0.9.4) not found Checking for PerlMagick (any) not found Checking for perl-ldap (any) not found Checking for SASL-Authen (any) not found Checking for RadiusPerl (any) not found Checking for SOAP-Lite (any) ok: found v0.710.08 Checking for HTML-Parser (v3.40) ok: found v3.56 Checking for HTML-Scrubber (any) ok: found v0.08 Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.315 Checking for Email-Reply (any) ok: found v1.202 Checking for mod_perl (v1.999022) not found Checking for CGI.pm (v3.11) ok: found v3.15 ********************************************************************** * 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) * *********************************************************************** * MIME-tools * Move Bugs Between Installations * * PatchReader * Patch Viewer * * PerlMagick * Optionally Convert BMP Attachments to PNGs * * perl-ldap * LDAP Authentication * * SASL-Authen * SMTP Authentication * * RadiusPerl * RADIUS Authentication * * mod_perl * mod_perl * *********************************************************************** COMMANDS TO INSTALL: MIME-tools: /usr/bin/perl install-module.pl MIME::Parser PatchReader: /usr/bin/perl install-module.pl PatchReader PerlMagick: /usr/bin/perl install-module.pl Image::Magick perl-ldap: /usr/bin/perl install-module.pl Net::LDAP SASL-Authen: /usr/bin/perl install-module.pl Authen::SASL RadiusPerl: /usr/bin/perl install-module.pl Authen::Radius mod_perl: /usr/bin/perl install-module.pl mod_perl2 To attempt an automatic install of every required and optional module with one command, do: /usr/bin/perl install-module.pl --all 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.006 Checking for MySQL (v4.1.2) ok: found v5.1.26-rc
Himorin, if this bug is valid, mark it as NEW. If the bug summary is inaccurate, please fix it. Else mark it as WFM or INVALID.
I think this might relate on perl (and/or) Template-Toolkit version. The problem is bugzilla uses mutl-byte utf8 in hash key. Like, default/reports/report-table.html.tmpl line 112 > [% FOREACH col = col_names %] > [% row_total = row_total + data.$tbl.$col.$row %] > [% NEXT IF col == "" %] > [% col_totals.$col = col_totals.$col + data.$tbl.$col.$row %] $col or $row here are the values of specified category (like products, components, etc) for axes. I don't test we can fix this with 'use utf8' (not utf8-flags) in the template itself. But i think it's related on issue of utf8 values, because i've once have some serious problem (such as dataloss or something) when using utf8 flagged values at hash key.
Status: UNCONFIRMED → NEW
Ever confirmed: true
Summary: Table reports didn't calculation correctly if Products or Components are in Russian language → Bugzilla should not use multi-byte utf-8 as keys of hash which are used in TT
Do you have a reduced testcase showing this problem?
http://landfill.bugzilla.org/bugzilla30l10n/ shows non-UTF-8 strings in debug and works OK. I suspect one of these: 1. Perl on Windows platform vs. Unix (my tests on CVS tip against Mary and himorin) 2. Patch from attachment 286357 [details] [diff] [review] to bug 363153 (3.0 against 3.2-branch on landfill) 3. CGI.pm version (mine is higher) Neither templates nor report.cgi were changed between. Could someone post landfill module versions for bugzilla30l10n and bugzilla-3.2-branch? Shortest known testcase (would work on many landfill instances): https://landfill.bugzilla.org/bugzilla-3.2-branch/report.cgi?x_axis_field=classification&y_axis_field=product&z_axis_field=&query_format=report-table&product=Spider+S%C3%A9%C3%A7ret%C3%AD%C3%B8ns&format=table&action=wrap&debug=1
I can reproduce on Win, tip, without localization. (With product instead of component for rows; I don't have UTF-8 components at hand on that install. Should be the same issue, though, I assume.) * This is Bugzilla 3.3 on perl 5.10.0 * Running on WinXP/.Net Build 2600 (Service Pack 2) Checking perl modules... Checking for CGI.pm (v3.33) ok: found v3.34 Checking for TimeDate (v2.21) ok: found v2.22 Checking for DateTime (v0.28) ok: found v0.41 Checking for PathTools (v0.84) ok: found v3.2501 Checking for DBI (v1.41) ok: found v1.602 Checking for Template-Toolkit (v2.15) ok: found v2.19 Checking for Email-Send (v2.16) ok: found v2.192 Checking for Email-MIME (v1.861) ok: found v1.861 Checking for Email-MIME-Modifier (v1.442) ok: found v1.442 Checking available perl DBD modules... Checking for DBD-Pg (v1.45) not found Checking for DBD-mysql (v4.00) ok: found v4.005 Checking for DBD-Oracle (v1.19) not found The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.35 Checking for Chart (v1.0) not found Checking for Template-GD (any) not found Checking for GDTextUtil (any) ok: found v0.86 Checking for GDGraph (any) ok: found v1.44 Checking for XML-Twig (any) not found Checking for MIME-tools (v5.406) ok: found v5.425 Checking for libwww-perl (any) ok: found v2.036 Checking for PatchReader (v0.9.4) not found Checking for PerlMagick (any) not found Checking for perl-ldap (any) not found Checking for SASL-Authen (any) not found Checking for RadiusPerl (any) not found Checking for SOAP-Lite (any) ok: found v0.69 Checking for HTML-Parser (v3.40) ok: found v3.56 Checking for HTML-Scrubber (any) ok: found v0.08 Checking for Email-MIME-Attachment-Stripper (any) not found Checking for Email-Reply (any) not found Checking for mod_perl (v1.999022) not found
This one's affected, too: * Dies ist Bugzilla 3.2rc1 auf perl 5.8.8 * auf Win2000 Build 2195 (Service Pack 4) Ueberpruefe Perl-Module... Ueberpruefe auf CGI.pm (v2.93) in Ordnung: v3.20 gefunden Ueberpruefe auf TimeDate (v2.21) in Ordnung: v2.22 gefunden Ueberpruefe auf PathTools (v0.84) in Ordnung: v3.12 gefunden Ueberpruefe auf DBI (v1.41) in Ordnung: v1.602 gefunden Ueberpruefe auf Template-Toolkit (v2.15) in Ordnung: v2.19 gefunden Ueberpruefe auf Email-Send (v2.16) in Ordnung: v2.185 gefunden Ueberpruefe auf Email-MIME (v1.861) in Ordnung: v1.861 gefunden Ueberpruefe auf Email-MIME-Modifier (v1.442) in Ordnung: v1.442 gefunden Ueberpruefe verfuegbare Perl-DBD-Module... Ueberpruefe auf DBD-Pg (v1.45) nicht gefunden Ueberpruefe auf DBD-mysql (v4.00) in Ordnung: v4.005 gefunden Ueberpruefe auf DBD-Oracle (v1.19) nicht gefunden Die folgenden Perl-Module sind optional: Ueberpruefe auf GD (v1.20) in Ordnung: v2.35 gefunden Ueberpruefe auf Chart (v1.0) in Ordnung: v2.3 gefunden Ueberpruefe auf Template-GD (beliebig) in Ordnung: v1.56 gefunden Ueberpruefe auf GDTextUtil (beliebig) in Ordnung: v0.86 gefunden Ueberpruefe auf GDGraph (beliebig) in Ordnung: v1.4308 gefunden Ueberpruefe auf XML-Twig (beliebig) nicht gefunden Ueberpruefe auf MIME-tools (v5.406) in Ordnung: v5.420 gefunden Ueberpruefe auf libwww-perl (beliebig) in Ordnung: v2.033 gefunden Ueberpruefe auf PatchReader (v0.9.4) in Ordnung: v0.9.5 gefunden Ueberpruefe auf PerlMagick (beliebig) nicht gefunden Ueberpruefe auf perl-ldap (beliebig) nicht gefunden Ueberpruefe auf SASL-Authen (beliebig) nicht gefunden Ueberpruefe auf RadiusPerl (beliebig) in Ordnung: v0.13 gefunden Ueberpruefe auf SOAP-Lite (beliebig) in Ordnung: v0.69 gefunden Ueberpruefe auf HTML-Parser (v3.40) in Ordnung: v3.55 gefunden Ueberpruefe auf HTML-Scrubber (beliebig) in Ordnung: v0.08 gefunden Ueberpruefe auf Email-MIME-Attachment-Stripper (beliebig) nicht gefunden Ueberpruefe auf Email-Reply (beliebig) nicht gefunden Ueberpruefe auf mod_perl (v1.999022) nicht gefunden Ueberpruefe auf CGI.pm (v3.11) in Ordnung: v3.20 gefunden
Attached file testcase (cgi) (obsolete) (deleted) —
testcase (cgi) usage 1. place three files (cgi, template, dat) into the same dir. 2. execute via a command line or via a http access.
Attached file testcase (html) (obsolete) (deleted) —
Attached file testcase (sample dat) (obsolete) (deleted) —
Attachment #343086 - Attachment mime type: application/octet-stream → text/plain
Attachment #343085 - Attachment mime type: application/binary → text/plain
Attachment #343087 - Attachment mime type: application/octet-stream → text/plain
Comment on attachment 343086 [details] testcase (html) aaah,,, it's over-written by template-toolkit..
Attachment #343086 - Attachment is obsolete: true
Attached file testcase (html template) (obsolete) (deleted) —
# mm,, attaching with .tar or something archive was better??
justdave, mkanat: could you post `checksetup.pl --check-modules` for http://landfill.bugzilla.org/bugzilla-3.2-branch/ here?
Downgrading CGI.pm to v3.34 didn't help (In reply to comment #16) > Confirmed NOT reproducible on CVS tip: > * This is Bugzilla 3.3 on perl 5.8.7 > * Running on WinXP/.Net Build 2600 (Service Pack 2) > Checking perl modules... > Checking for CGI.pm (v3.21) ok: found v3.38 (In reply to comment #23) > I can reproduce on Win, tip, without localization. > * This is Bugzilla 3.3 on perl 5.10.0 > * Running on WinXP/.Net Build 2600 (Service Pack 2) > Checking perl modules... > Checking for CGI.pm (v3.33) ok: found v3.34
Let's keep the bug summary describing the bug, not a proposed fix.
Summary: Bugzilla should not use multi-byte utf-8 as keys of hash which are used in TT → Reports don't calculate totals correctly if one of the axes involve utf-8 characters
Summary: Reports don't calculate totals correctly if one of the axes involve utf-8 characters → Reports don't calculate totals correctly if one of the axes contain utf-8 data
(In reply to comment #16) > Confirmed NOT reproducible on CVS tip: > * This is Bugzilla 3.3 on perl 5.8.7 > * Running on WinXP/.Net Build 2600 (Service Pack 2) Finally reproduced on that same OS, after Perl upgrade: * This is Bugzilla 3.3 on perl 5.10.0 * Running on WinXP/.Net Build 2600 (Service Pack 2) Checking perl modules... Checking for CGI.pm (v3.33) ok: found v3.41 Checking for TimeDate (v2.21) ok: found v2.22 Checking for DateTime (v0.28) ok: found v0.45 Checking for PathTools (v0.84) ok: found v3.2501 Checking for DBI (v1.41) ok: found v1.607 Checking for Template-Toolkit (v2.15) ok: found v2.20 Checking for Email-Send (v2.16) ok: found v2.192 Checking for Email-MIME (v1.861) ok: found v1.861 Checking for Email-MIME-Modifier (v1.442) ok: found v1.442 Checking available perl DBD modules... Checking for DBD-Pg (v1.45) not found Checking for DBD-mysql (v4.00) ok: found v4.005 Checking for DBD-Oracle (v1.19) ok: found v1.21 The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.41 Checking for Chart (v1.0) ok: found v2.4.1 Checking for Template-GD (any) ok: found v1.56 Checking for GDTextUtil (any) ok: found v0.86 Checking for GDGraph (any) ok: found v1.44 Checking for XML-Twig (any) not found Checking for MIME-tools (v5.406) not found Checking for libwww-perl (any) ok: found v5.814 Checking for PatchReader (v0.9.4) ok: found v0.9.5 Checking for PerlMagick (any) not found Checking for perl-ldap (any) not found Checking for Authen-SASL (any) not found Checking for RadiusPerl (any) not found Checking for SOAP-Lite (any) not found Checking for HTML-Parser (v3.40) ok: found v3.56 Checking for HTML-Scrubber (any) not found Checking for Email-MIME-Attachment-Stripper (any) not found Checking for Email-Reply (any) not found Checking for mod_perl (v1.999022) not found Checking for DBD-mysql (v4.00) ok: found v4.005 Checking for MySQL (v4.1.2) ok: found v5.0.27-community-nt
(In reply to comment #15) > Instance details: > http://pastebin.mozilla.org/545612 $ ./checksetup.pl --check-modules * This is Bugzilla 3.2rc2+ on perl 5.8.5 * Running on Linux 2.6.9-78.0.1.ELsmp #1 SMP Tue Aug 5 11:02:47 EDT 2008 Checking perl modules... Checking for CGI.pm (v3.21) ok: found v3.38 Checking for TimeDate (v2.21) ok: found v2.22 Checking for PathTools (v0.84) ok: found v3.2501 Checking for DBI (v1.41) ok: found v1.56 Checking for Template-Toolkit (v2.15) ok: found v2.19 Checking for Email-Send (v2.00) ok: found v2.185 Checking for Email-MIME (v1.861) ok: found v1.861 Checking for Email-MIME-Modifier (v1.442) ok: found v1.442 Checking available perl DBD modules... Checking for DBD-Pg (v1.45) not found Checking for DBD-mysql (v4.00) ok: found v4.008 Checking for DBD-Oracle (v1.19) not found The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.35 Checking for Chart (v1.0) ok: found v2.4.1 Checking for Template-GD (any) ok: found v1.56 Checking for GDTextUtil (any) ok: found v0.86 Checking for GDGraph (any) ok: found v1.44 Checking for XML-Twig (any) ok: found v3.29 Checking for MIME-tools (v5.406) ok: found v5.420 Checking for libwww-perl (any) ok: found v2.033 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 Authen-SASL (any) not found Checking for RadiusPerl (any) not found Checking for SOAP-Lite (any) ok: found v0.69 Checking for HTML-Parser (v3.40) ok: found v3.56 Checking for HTML-Scrubber (any) ok: found v0.08 Checking for Email-MIME-Attachment-Stripper (any) ok: found v1.313 Checking for Email-Reply (any) ok: found v1.201 Checking for mod_perl (v1.999022) not found Checking for CGI.pm (v3.11) ok: found v3.38
Attached file Software versions comparison (obsolete) (deleted) —
Here are compared module versions. Quick look: Not a Perl version by itself, maybe Perl + OS? Template Toolkit version? mod_perl?
Testing on another perl modules doesn't help. The bug is reproduced on this settings: freeserver# ./checksetup.pl --check-module * This is Bugzilla 3.2 on perl 5.8.8 * Running on FreeBSD 7.0-RELEASE FreeBSD 7.0-RELEASE #3: Fri Aug 22 22:20:09 MSD 2008 root@freeserver:/usr/obj/usr/src/sys/MIKEKERN Checking perl modules... Checking for CGI.pm (v3.21) ok: found v3.38 Checking for TimeDate (v2.21) ok: found v2.22 Checking for PathTools (v0.84) ok: found v3.12 Checking for DBI (v1.41) ok: found v1.53 Checking for Template-Toolkit (v2.15) ok: found v2.15 Checking for Email-Send (v2.00) ok: found v2.190 Checking for Email-MIME (v1.861) ok: found v1.861 Checking for Email-MIME-Modifier (v1.442) ok: found v1.442 Checking available perl DBD modules... Checking for DBD-Pg (v1.45) not found Checking for DBD-mysql (v4.00) ok: found v4.005 Checking for DBD-Oracle (v1.19) not found The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.16 Checking for Chart (v1.0) ok: found v2.4.1 Checking for Template-GD (any) ok: found v1.56 Checking for GDTextUtil (any) ok: found v0.86 Checking for GDGraph (any) ok: found v1.43 Checking for XML-Twig (any) ok: found v3.26 Checking for MIME-tools (v5.406) ok: found v5.406 Checking for libwww-perl (any) ok: found v2.033 Checking for PatchReader (v0.9.4) ok: found v0.9.5 Checking for PerlMagick (any) not found Checking for perl-ldap (any) not found Checking for Authen-SASL (any) not found Checking for RadiusPerl (any) not found 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.08 Checking for Email-MIME-Attachment-Stripper (any) not found Checking for Email-Reply (any) not found Checking for mod_perl (v1.999022) ok: found v2.000003 Checking for CGI.pm (v3.11) ok: found v3.38 ********************************************************************** * 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) * *********************************************************************** * PerlMagick * Optionally Convert BMP Attachments to PNGs * * perl-ldap * LDAP Authentication * * Authen-SASL * SMTP Authentication * * RadiusPerl * RADIUS Authentication * * Email-MIME-Attachment-Stripper * Inbound Email * * Email-Reply * Inbound Email * *********************************************************************** COMMANDS TO INSTALL: PerlMagick: /usr/bin/perl install-module.pl Image::Magick perl-ldap: /usr/bin/perl install-module.pl Net::LDAP Authen-SASL: /usr/bin/perl install-module.pl Authen::SASL RadiusPerl: /usr/bin/perl install-module.pl Authen::Radius Email-MIME-Attachment-Stripper: /usr/bin/perl install-module.pl Email::MIME::Attachment::Stripper Email-Reply: /usr/bin/perl install-module.pl Email::Reply To attempt an automatic install of every required and optional module with one command, do: /usr/bin/perl install-module.pl --all freeserver#
You could be hitting a bug that's specific to a particular distro or platform's Perl. For example, can this be reproduced on both FreeBSD and Fedora/RHEL? Does it also happen on Ubuntu? Does it happen with a Perl compiled directly from the perl.org tarball?
To date it did NOT happen only once, with Windoze and ActivePerl. However, himorin insists that regression was caused by attachment 286357 [details] [diff] [review] (patch to bug bz-utf8). This is another possibility for definite test (check out CVS before that patch) but I still have not performed such test.
(In reply to comment #38) > However, himorin insists that regression was caused by attachment 286357 [details] [diff] [review] (patch to bug bz-utf8). That wouldn't surprise me. In any case, all that matters is that we find a system where we can reproduce it, and then track down the cause with various types of debugging code.
I am a Korean user and can reproduce this bug on my system. When I use the 3.0.x versions, there had been no problem like this. After I upgraded to the upper version like 3.3.x or 3.4.x, this has happened. I use the bugzilla on english template(en/default) and UTF-8 mode. I entered Korean characters on field values. Row or col fields including Korea or 2 byte(?) characters seem not to evaluate the correct bug counts.But when I click the count numbers, the bug lists are correct. My system informations are as follows : - OS : Ubuntu - Bugzilla 3.3.4 on Perl 5.8.8 - Linux 2.6.22-16 generic - CGI.pm : v3.43 .... - Template-Toolkit : v2.19 ... - DBD-mysql : v4.004
Hi all, same behaviour for Czech names - summaries in tabular report are all marked with "." (dot) but when you click on the Total, all bugs will show. We're having this trouble just after upgrade to 3.2.3, previous version was 3.0.x and was working correctly
I got the same problem right now with New Charts where the select fields for subcategory and names are no populated if one name has UTF8 characters in them. From the MySQL command-line, replacing "fermés" by "fermes" (french word for "closed") fixed the problem. The root cause is the same for Reports and New Charts. The code uses names for hash keys, but TT < 2.22 doesn't support UTF8 characters in them: https://rt.cpan.org/Public/Bug/Display.html?id=45842 This bug has been fixed and is available in the development version TT 2.21_02: http://cpansearch.perl.org/src/ABW/Template-Toolkit-2.21_02/Changes So this bug will be fixed once we require TT 2.22. mkanat, as bug 469794 requires TT 2.21 and as TT 2.21 doesn't pass its own tests on Windows, which means we have to wait for TT 2.22 anyway, I suggest we require TT 2.22 on all platforms, not only Windows. What do you think? If not for the 3.2 branch, we should at least take it for 3.4. Marking as a 3.4 blocker for now to keep track of this bug, but probably not a hard blocker (well, it is for all countries/users who use UTF8 extensively).
Flags: blocking3.4+
OS: Other → All
Hardware: x86 → All
Whiteboard: [requires TT 2.22]
Target Milestone: --- → Bugzilla 3.2
OK, I tested with TT 2.21_02, and it indeed correctly fixes the problem reported in this bug as well as the problem reported in comment 43 about new charts.
Attached patch patch, v1 (obsolete) (deleted) — Splinter Review
This requires TT 2.22 on all platforms, as Linux is affected too. This patch cannot land till TT 2.22 is released and available on both CPAN and via PPM.
Assignee: charting → LpSolit
Attachment #340783 - Attachment is obsolete: true
Attachment #343085 - Attachment is obsolete: true
Attachment #343087 - Attachment is obsolete: true
Attachment #343089 - Attachment is obsolete: true
Attachment #348140 - Attachment is obsolete: true
Status: NEW → ASSIGNED
Attachment #389172 - Flags: review?(mkanat)
Comment on attachment 389172 [details] [diff] [review] patch, v1 Add a comment as to why we require that version. (Normally this wouldn't be an r-, but I figure we have enough time before 3.4 and this is a tiny enough patch.) But yeah, I'm in support of requiring 2.22 for all platforms on 3.4.
Attachment #389172 - Flags: review?(mkanat) → review-
Attached patch patch, v2 (deleted) — Splinter Review
Now with a comment.
Attachment #389172 - Attachment is obsolete: true
Attachment #389178 - Flags: review?(mkanat)
Attachment #389178 - Flags: review?(mkanat) → review+
Comment on attachment 389178 [details] [diff] [review] patch, v2 I think we usually put the comment over the version number, don't we?
Flags: approval3.4+
Flags: approval+
Keywords: relnote
Whiteboard: [requires TT 2.22] → [requires TT 2.22][relnote for 3.2.5]
Target Milestone: Bugzilla 3.2 → Bugzilla 3.4
DateTime, DateTime::TimeZone and HTML::Parser have it as I did here. CGI has it right before the version.
FYI, TT 2.22 will soon be released (I hope this week). I got an email from the maintainer of TT, and he has one minor bug to fix about POD and 2.22 be ready.
tip: Checking in Bugzilla/Install/Requirements.pm; /cvsroot/mozilla/webtools/bugzilla/Bugzilla/Install/Requirements.pm,v <-- Requirements.pm new revision: 1.64; previous revision: 1.63 done 3.4rc1: Checking in Bugzilla/Install/Requirements.pm; /cvsroot/mozilla/webtools/bugzilla/Bugzilla/Install/Requirements.pm,v <-- Requirements.pm new revision: 1.60.2.3; previous revision: 1.60.2.2 done
Status: ASSIGNED → RESOLVED
Closed: 16 years ago15 years ago
Resolution: --- → FIXED
I have tested this bug on 3.4.2 version. It is not reproduced. This bug have been fixed at that moment (at 3.4.2 version). Bugzilla calculates table reports with Russian names of the components\products correctly.
Blocks: 493242
Keywords: relnote
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: