51Testing软件测试论坛

标题: 关于提交bug后，上传bug截图时的问题 [打印本页]

作者: joywood 时间: 2009-2-23 17:51
标题: 关于提交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
没遇见过这种问题～

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

作者: joywood 时间: 2009-2-26 15:19
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.

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)