关于提交bug后，上传bug截图时的问题

joywood

我用的是bugzilla2.20.1，请各位见谅。
我新建bug之后，选择create attachment，然后选择了各种提交方式，均出现以下错误，请高手指点。

错误：
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 '﨧%y?amp;9�\0犾�\0?�\0￣�\0�\0衯泾麮�\0畦�\0T%�塌�鸕弚?滫F碁4P磲)嘓諳��?' at line 4 [for Statement "INSERT INTO attachments
      (thedata, bug_id, creation_ts, filename, description,
       mimetype, ispatch, isprivate, submitter_id)
      VALUES (?, 114, '2009-02-23 17:39:33', '初始化任务失败（负的数据备份量）.jpg',
              'fail', 'image/pjpeg', 0,
              0, 12)"] at /var/www/html/bugzilla-2.20.1/attachment.cgi line 943
        main::insert() called at /var/www/html/bugzilla-2.20.1/attachment.cgi line 94

joywood

INSERT INTO attachments
      (thedata, bug_id, creation_ts, filename, description,mimetype, ispatch, isprivate, submitter_id)
      VALUES (?, 114, '2009-02-23 17:39:33', '初始化任务失败（负的数据备份量）.jpg','fail', 'image/pjpeg', 0,0, 12)"

我认为可能是第一个字段有问题，value里面是“？”不知道各位大侠有什么看法。

在查看attachments.cgi之后，我将?改为$thedata，结果报出新的错误：
Global symbol "$ACTION" requires explicit package name at /var/www/html/bugzilla-2.20.1/attachment.cgi line 74.
syntax error at /var/www/html/bugzilla-2.20.1/attachment.cgi line 74, near "$ACTION EQ "
Execution of /var/www/html/bugzilla-2.20.1/attachment.cgi aborted due to compilation errors.

zhyb_2008

没用过这个测试工具.顶一下.
我猜一下原因:
1是不是文件格式为bmp,太大,转为jpg
2文件名改用英文字符?
3数据库配置方面的问题,不写数据,或者存文件名的相关表被锁定?
4数据库和测试工具配置不合理?
参考上面老兄的意思.

bill_hen

It said the sql statement has a problem, try to change the Chinese file name into, say, test.jpg, and try again.
Maybe your mysql version is not supported by your bugzilla version.

------------------------
QQ:  546562584

shu123

没遇见过这种问题～