youguo888 2007-11-7 16:07
bugzilla不能上传图片附件问题
可以上传文本附件，但是上传图片附件的时候就报如下错误，无论上传什么形式的图片都不行，求高手们指点，多谢！！！！～
Software error:
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'id=\'W5M0MpCehiHzreSzNTczkc9d\'?>\n<?adobe-xap-filters esc=\"CR\"?>\n<x:xapmeta ' at line 4 [for Statement "INSERT INTO attachments
(thedata, bug_id, creation_ts, filename, description,
mimetype, ispatch, isprivate, submitter_id)
VALUES (?, 11, '2007-11-08 15:40:15', 'test.jpg',
'qqqqqqqqqqq', 'image/pjpeg', 0,
0, 1)"] at C:/Bugzilla/attachment.cgi line 966
main::insert() called at C:/Bugzilla/attachment.cgi line 94
zhangtao 2007-11-7 17:41
我记得我们当时是可以上传附件的，是不是附件的格式或者大小不对啊！
期待正确的解答！
youguo888 2007-11-7 18:01
试过所有的格式和小到2k的图片都不行
bill_hen 2007-11-8 06:36
in mysql do:
mysql> desc attachments;
and see what data type of the column 'thedata' is.
---------------------------------------------
For bug tracking, use BUGZERO, fully supported.
[url]http://www.websina.com/bugzero/[/url]
youguo888 2007-11-8 11:08
按照楼上所写进行操作：
mysql> desc attachments;
ERROR 1146 (42S02): Table 'mysql.attachments' doesn't exist
youguo888 2007-11-9 10:06
顶一下，大家帮忙看看是否是数据库内的问题
bill_hen 2007-11-9 11:30
You need use the bugzilla database, not the mysql database.
The attachments table is in bugzilla db.
------------------------------------------
For bug tracking, use BUGZERO, fully supported.
[url]http://www.websina.com/bugzero/[/url]
youguo888 2007-11-12 15:49
bugzilla本身还带数据库吗？
youguo888 2007-11-15 12:14
没人遇到过这个问题吗？？？帮忙解决一下，多谢
junlingliu 2008-3-10 13:23
我也遇到了类似的问题,是说:
Software error:
DBD::mysql::st execute failed: MySQL server has gone away [for Statement "INSERT INTO attach_data
(id, thedata) VALUES (16, ?)" with ParamValues: 0='BM6.$.....6...(.....................$.................辒&辒&鄇(鄇(鄇(鄇(鄇(鄇(鄇(鄇(鄇(醡)醡)鄇(鄇(鄇(鄇(鄇(鄇(鄇(鄇(鈔*鈔*醡)鈔*鈔*醡)醡)醡)鈔*醡)醡)鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鈔*鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鈔*鈔*鈔*鈔*鈔*鈔*鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鉹+鈔*鈔*醡)醡)鉹+鉹+鄇(辒&辒&辒&諿"諿".......................'] at Bugzilla/Attachment.pm line 816
Bugzilla::Attachment::insert_attachment_for_bug('Bugzilla::Attachment', 1, 'Bugzilla::Bug=HASH(0x261e5f0)', 'Bugzilla::User=HASH(0x25726c8)', '2008-03-10 13:13:55', 'REF(0x1ecdbf4)') called at C:/Bugzilla/attachment.cgi line 466
main::insert() called at C:/Bugzilla/attachment.cgi line 99
请高手们帮忙看看啊! 谢谢了!