142300 - failed to attach binary files

Status: RESOLVED WORKSFORME

(Bugzilla :: Creating/Changing Bugs, defect, P3)

Description

[Jiun-Yao Huang]

Attaching an image file got the following error message:

Software error:
insert into attachments (bug_id, filename, description, mimetype, ispatch, 
submitter_id, thedata) values (36,'D:\\tmp\\logo.gif', 'test', 'image/gif', 0, 
1, 'GIF89a}\0F\0æ\0\0ÿÿÿ÷÷ÿ÷÷÷ï÷÷ÿï÷ÿïïïïïïï÷æï÷ææ÷ææ?ÞæÞæï÷ÞÞÞÞïÞÞÞ÷ÖÖ÷ÖÞÖÞïæÖæÖÖ

[Snip]

quot;l]?YlKG?Yl^7?]b?N??]5D§l\'NlS?Y???\0;'): You have an error in 
your SQL syntax near 'N?\02öø#"ru©È‘ÎA?{Ñq?{VXg\0C&§à?Èu?quot;*ºW?ÖùÇÉŸà¥\0^™É�Á
‚{{?amp;—n‰ôù\\¥aÊɇî' at line 1 at globals.pl line 215, <STDIN> line 34.

I think this is because the sql syntax contains invalid string patterns
that causes $::currentquery->execute failed (in global.pl line 215),
even the string was translated by SqlQuote.

I have two Bugzilla installations with MySQL on different platforms.
One is on Linux, and the other is on Windows. Both MySQL versions are 3.23.49.
Attaching the image file failed on the Bugzilla with MySQL running on Linux,
but attaching the same file works on the Bugzilla with MySQL running on Windows.

Comment 1

[Andreas Franke (gone)]

Can you attach a file that triggers this bug when you try to upload it? If you
can't attach it as-is on bugzilla.mozilla.org, can you try to attach a .gz or
.tar file containing it, or maybe even the result of uuencode (a base64
encoder)? Does attaching it on http://landfill.tequilarista.org/bugzilla-tip/
work?

Comment 2

[Jiun-Yao Huang]

Attachment: the image file failed to attach on my machine

Comment 3

[Bradley Baetz (:bbaetz)]

So it fails on unix, but works on windows? Not the other way arround?

Comment 4

[Jiun-Yao Huang]

I have two installations:

1) Bugzilla 1.14.1 on Linux, MySQL 3.23.49 on Linux
2) Bugzilla 1.14.1 on Linux, MySQL 3.23.49 on Windows 2000

1) fails, but 2) works.

Comment 5

[Andreas Franke (gone)]

Apparently this works with the bugzilla-tip installation on landfill, see
http://landfill.tequilarista.org/bugzilla-tip/show_bug.cgi?id=274

Comment 6

[Gervase Markham [:gerv]]

[e-mail]: are you still seeing problems like this? We just started using
CGI.pm for the file upload interface, so that should be even more compatible...

Gerv

Comment 7

[Bradley Baetz (:bbaetz)]

Id this was the other way arround, it would be a dupe of bug 62000

Comment 8

[Gervase Markham [:gerv]]

No followup; WORKSFORME.

Gerv