Bug 455639

Summary: Error displayed when attempting to attach multiple BZ
Product: [Retired] Issue-Tracker Reporter: Mike Amburn <mamburn>
Component: Integration-BugzillaAssignee: Issue-Tracker Bug Watch List <issuetracker-bugs-watch>
Status: CLOSED WONTFIX QA Contact:
Severity: low Docs Contact:
Priority: medium    
Version: 4.6   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-06-26 20:48:26 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Mike Amburn 2008-07-16 18:44:05 UTC
Steps to reproduce:
1. Enable BZ section
2. Enter a CSV of two or more BZ ids
3. Commit the event

Expected Result:
If this functionality isn't supported, a simple error that "The Bugzilla ID you
provided was not found." would suffice. If this functionality is supported,
there should be no error if the BZs are correct.

Actual Result:
Sending Issue Tracker 107277 to Bugzilla 448983,448984, failed. Reason:
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 \'AND products.id = bugs.product_id AND components.id = bugs.component_\'
at line 26 [for Statement \" SELECT bugs.bug_id, bugs.alias, products.name AS
product, bugs.version, bugs.rep_platform, bugs.op_sys, bugs.bug_status,
bugs.resolution, bugs.priority, bugs.bug_severity, components.name AS component,
bugs.assigned_to, bugs.reporter, bugs.bug_file_loc, bugs.short_desc,
bugs.target_milestone, bugs.qa_contact, bugs.status_whiteboard,
bugs.devel_whiteboard, DATE_FORMAT(creation_ts, \'%Y-%m-%d %H:%i\') AS
creation_ts, DATE_FORMAT(delta_ts, \'%Y-%m-%d %H:%i\') AS delta_ts FROM bugs,
products, components WHERE bugs.bug_id = AND products.id = bugs.product_id AND
components.id = bugs.component_id \"] at Bugzilla/RPC/Bug.pm line 174
Bugzilla::RPC::Bug::getBugSimple(\'bugzilla\', \'448983,448984\',
\'tao\', \'uRan1#m@\') called at
/usr/lib/perl5/vendor_perl/5.8.5/SOAP/Lite.pm line 2474 eval {...} called at
/usr/lib/perl5/vendor_perl/5.8.5/SOAP/Lite.pm line 2462 eval {...} called at
/usr/lib/perl5/vendor_perl/5.8.5/SOAP/Lite.pm line 2433
SOAP::Server::handle(\'Bugzilla::RPC=HASH(0x1b5ca80)\',
\'\\x{a}\\x{a}bugzilla.getBu...\') called at
/usr/lib/perl5/vendor_perl/5.8.5/SOAP/Transport/HTTP.pm line 317
SOAP::Transport::HTTP::Server::handle(\'Bugzilla::RPC=HASH(0x1b5ca80)\') called
at /usr/lib/perl5/vendor_perl/5.8.5/SOAP/Transport/HTTP.pm line 408
SOAP::Transport::HTTP::CGI::handle(\'Bugzilla::RPC=HASH(0x1b5ca80)\') called at
/var/www/html/bugzilla/xmlrpc.cgi line 45

Comment 1 Mike Amburn 2012-06-26 20:48:26 UTC
Closing my open Issue-Tracker requests.