Bug 821043 - XMLRPC fault - Malformed sql query
Summary: XMLRPC fault - Malformed sql query
Keywords:
Status: CLOSED DUPLICATE of bug 821155
Alias: None
Product: Bugzilla
Classification: Community
Component: WebService
Version: devel
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: 4.2-1
Assignee: Simon Green
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks: BZ42
TreeView+ depends on / blocked
 
Reported: 2012-05-11 15:52 UTC by Pavel Slama
Modified: 2018-12-09 06:29 UTC (History)
2 users (show)

Fixed In Version: 4.2.1-0.rc3
Clone Of:
Environment:
Last Closed: 2012-05-13 22:55:56 UTC
Embargoed:

Attachments (Terms of Use)
reproducer (1019 bytes, text/x-python)
2012-05-11 15:52 UTC, Pavel Slama 		no flags Details
View All

Description Pavel Slama 2012-05-11 15:52:21 UTC 
Created attachment 583877 [details]
reproducer

Description of problem:
bugzilla.runQuery call faults with 'DBD::mysql::st execute failed: FUNCTION bugs.0AND does not exist

Version-Release number of selected component (if applicable):
devel

How reproducible:
100%

Steps to Reproduce:
reproducer script attached 


Actual results:
DBD::mysql::st execute failed: FUNCTION bugs.0AND does not exist 

* notice 0AND together in the statement

..(SELECT bug_id FROM flags INNER JOIN flagtypes ON flags.type_id = flagtypes.id WHERE INSTR(CONCAT(flagtypes.name, flags.status), \'jboss-brms-5.1.0\') > 0AND (flagtypes.view_group_id IS NULL..



Expected results:
no error

Additional info:
Comment 1 Simon Green 2012-05-13 22:55:56 UTC 
Will be fixed in the next release (rc3)

*** This bug has been marked as a duplicate of bug 821155 ***
Note You need to log in before you can comment on or make changes to this bug.