joywood 发表于 2009-2-23 17:51:06

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

我用的是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

shu123 发表于 2009-2-23 19:23:55

没遇见过这种问题~

bill_hen 发表于 2009-2-24 03:28:22

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

zhyb_2008 发表于 2009-2-24 09:31:54

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

joywood 发表于 2009-2-26 15:19:03

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.
页: [1]
查看完整版本: 关于提交bug后,上传bug截图时的问题