Closed
Bug 295324
Opened 20 years ago
Closed 20 years ago
*Suddently* Attach binary file failed with Bugzilla 2.18!
Categories
(Bugzilla :: Attachments & Requests, defect)
Tracking
()
RESOLVED
INVALID
People
(Reporter: allenchen, Unassigned)
Details
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; zh-CN; rv:1.7.8) Gecko/20050511 Firefox/1.0.4
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.0; zh-CN; rv:1.7.8) Gecko/20050511 Firefox/1.0.4
My system detail as following,
Tao Linux (Update 4)
Bugzilla 2.18
MySQL 3.23.58
perl-DBD-MySQL 2.1021
Clinet: Windows 2000 Professional + IE 6.0/Firefox 1.0.4
The bug detail see the Reproduce Steps.
Reproducible: Always
Steps to Reproduce:
1.Click "Create a New Attachment"
in the Create New Attachment interface, select a Word file(or other binary file).
2.Click submit after input some Describe and select auto-detect, the error
message got
"Software error:
DBD::mysql::st execute failed: You have an error in your SQL syntax near '\0\0朶
'\0\0?\0\0?\0\0t+\0\0v+\0\0d-\0\0f-\0\0T/\0\0V/\0\0D1\0\0F1\0\043\0\063\' at
line 2 [for Statement "INSERT INTO attachments (bug_id, creation_ts, filename,
description, mimetype, ispatch, isprivate, submitter_id, thedata)
VALUES (90, '2005-05-24 18:20:50', 'test1.doc', 'test',
'application/msword', 0, 0, 1, '邢唷盶Z醆0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0>\0\0?
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Q\0\0\0\0\0\0\0\0\0\0S\0\0\0\0\0\0?\0\0\0\0P\0
\0\0
欹羂
0q`
\0\0餜
縗0\0\0\0\0\0\0\0\0\0\0\0\07\0\0\0bjbjqPqP\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\02<\0\0:\0:\0j\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0
\0\0z\0\0\0\0\0\0z\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0z
\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0r\0\0\0\0\0\0r\0\0\0\0\0\0r\0\0\0\0\0\0r
\0\0\0\0\0~\0\0,\0\0\0?\0\0\0\0\0\0!-\0\0.\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0
\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0?
\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0$\0\0\0O.\0\0h
\0\0?\0\0猏0\0\0?\0\0!\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0z\0\0\0\0\0
\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0x,\0\0\0\0\0\0x,\0\0\0\0\0\0x,\0\0\
...
0\0\0\0\0\0\0\0\0\0\0\0\0\0H\0\0\0\0\0\0\0\0\0\0\0C\0o\0m\0p\0O\0b\0j\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0m\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0?\n\0\0
\0\0\0\0\0繺0\0\0\0\0\0F\0\0\0Microsoft Office Word 文档\0\n\0\0\0MSWordDoc\0
\0\0\0Word.Document.8\0?瞦\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0')"]
at Bugzilla/DB.pm line 62
Bugzilla::DB::SendSQL('INSERT INTO attachments (bug_id, creation_ts, filename,
descr...') called at /var/www/html/bugzilla/attachment.cgi line 866
main::insert('\x{d0}\x{cf}\x{11}\x{e0}\x{a1}\x{b1}\x{1a}\x{e1}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}>\x{0}\x{3}\x{0}\x{fe}\x{ff}\x{9}\x{0}\x{6}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{1}\x{0}\x{0}\x{0}Q\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{10}\x{0}\x{0}S...')
called at /var/www/html/bugzilla/attachment.cgi line 123
For help, please send mail to the webmaster ...
...
3. If you select a text file, the bug not occurs.
Actual Results:
Software error:
DBD::mysql::st execute failed: You have an error in your SQL syntax near '\0\0朶
'\0\0?\0\0?\0\0t+\0\0v+\0\0d-\0\0f-\0\0T/\0\0V/\0\0D1\0\0F1\0\043\0\063\' at
line 2 [for Statement "INSERT INTO attachments (bug_id, creation_ts, filename,
description, mimetype, ispatch, isprivate, submitter_id, thedata)
VALUES (90, '2005-05-24 18:20:50', 'test1.doc', 'test',
'application/msword', 0, 0, 1, '邢唷盶Z醆0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0>\0\0?
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Q\0\0\0\0\0\0\0\0\0\0S\0\0\0\0\0\0?\0\0\0\0P\0
\0\0
欹羂
0q`
\0\0餜
縗0\0\0\0\0\0\0\0\0\0\0\0\07\0\0\0bjbjqPqP\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\02<\0\0:\0:\0j\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0
\0\0z\0\0\0\0\0\0z\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0z
\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0r\0\0\0\0\0\0r\0\0\0\0\0\0r\0\0\0\0\0\0r
\0\0\0\0\0~\0\0,\0\0\0?\0\0\0\0\0\0!-\0\0.\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0
\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0?
\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0$\0\0\0O.\0\0h
\0\0?\0\0猏0\0\0?\0\0!\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0z\0\0\0\0\0
\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0z\0\0\0\0\0\0z\0\0\0\0\0\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0?\0\0\0\0\0x,\0\0\0\0\0\0x,\0\0\0\0\0\0x,\0\0\
...
0\0\0\0\0\0\0\0\0\0\0\0\0\0H\0\0\0\0\0\0\0\0\0\0\0C\0o\0m\0p\0O\0b\0j\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0m\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0?\n\0\0
\0\0\0\0\0繺0\0\0\0\0\0F\0\0\0Microsoft Office Word 文档\0\n\0\0\0MSWordDoc\0
\0\0\0Word.Document.8\0?瞦\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0')"]
at Bugzilla/DB.pm line 62
Bugzilla::DB::SendSQL('INSERT INTO attachments (bug_id, creation_ts, filename,
descr...') called at /var/www/html/bugzilla/attachment.cgi line 866
main::insert('\x{d0}\x{cf}\x{11}\x{e0}\x{a1}\x{b1}\x{1a}\x{e1}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}>\x{0}\x{3}\x{0}\x{fe}\x{ff}\x{9}\x{0}\x{6}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{1}\x{0}\x{0}\x{0}Q\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{0}\x{10}\x{0}\x{0}S...')
called at /var/www/html/bugzilla/attachment.cgi line 123
For help, please send mail to the webmaster
Expected Results:
Attachment should be created for the bug.
The bug suddently occur today(2005/05/24) because it works fine with binary file
before.what changed between it working and not working? was mysql or bugzilla upgraded? what version of bugzilla are you running?
| Reporter | ||
Comment 2•20 years ago
|
||
I have changed the MySQL parameter "default-character" and I restore it, the bug is disappeared. I don't think it is Bugzilla bug. Maybe it is a MySQL one.
Status: UNCONFIRMED → RESOLVED
Closed: 20 years ago
Resolution: --- → INVALID
Updated•19 years ago
|
Severity: major → trivial
You need to log in
before you can comment on or make changes to this bug.
Description
•