youguo888 发表于 2007-11-7 16:07:37

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:27

我记得我们当时是可以上传附件的，是不是附件的格式或者大小不对啊！
期待正确的解答！

youguo888 发表于 2007-11-7 18:01:02

试过所有的格式和小到2k的图片都不行

bill_hen 发表于 2007-11-8 06:36:27

in mysql do:

mysql> desc attachments;

and see what data type of the column 'thedata' is.

---------------------------------------------
For bug tracking, use BUGZERO, fully supported.
http://www.websina.com/bugzero/

youguo888 发表于 2007-11-8 11:08:35

按照楼上所写进行操作：
mysql> desc attachments;
ERROR 1146 (42S02): Table 'mysql.attachments' doesn't exist

youguo888 发表于 2007-11-9 10:06:24

顶一下，大家帮忙看看是否是数据库内的问题

bill_hen 发表于 2007-11-9 11:30:38

You need use the bugzilla database, not the mysql database.
The attachments table is in bugzilla db.

------------------------------------------
For bug tracking, use BUGZERO, fully supported.
http://www.websina.com/bugzero/

youguo888 发表于 2007-11-12 15:49:35

bugzilla本身还带数据库吗？

youguo888 发表于 2007-11-15 12:14:59

没人遇到过这个问题吗？？？帮忙解决一下，多谢

junlingliu 发表于 2008-3-10 13:23:27

我也遇到了类似的问题,是说:
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


请高手们帮忙看看啊!谢谢了!
页: [1]
查看完整版本: bugzilla不能上传图片附件问题