Attachment 587939 Details for Bug 826829 – 20120531-bugzilla-query-error.txt

20120531-bugzilla-query-error.txt

20120531-bugzilla-query-error.txt (text/plain), 3.50 KB, created by Qin Guan on 2012-05-31 05:22:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Qin Guan

Created: 2012-05-31 05:22:08 UTC

Size: 3.50 KB

patch

obsolete

>Please stand by ...
>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 ')
>        AND bugs.bug_id IN (SELECT bug_id FROM longdescs WHERE INSTR(thetext, ' at line 17 [for Statement "SELECT bugs.bug_id AS bug_id, bugs.bug_severity AS bug_severity, bugs.priority AS priority, bugs.bug_status AS bug_status, bugs.resolution AS resolution, map_product.name AS product, map_component.name AS component, bugs.short_desc AS short_desc, map_assigned_to.login_name AS assigned_to, GROUP_CONCAT(DISTINCT CONCAT(map_flagtypes.name, map_flags.status) ORDER BY CONCAT(map_flagtypes.name, map_flags.status) SEPARATOR ', ') AS flagtypes_name, GROUP_CONCAT(DISTINCT map_cf_verified.value ORDER BY map_cf_verified.value SEPARATOR ', ') AS cf_verified, bugs.status_whiteboard AS status_whiteboard
>  FROM bugs
>LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id
>LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 311350
>INNER JOIN products AS map_product ON bugs.product_id = map_product.id
>INNER JOIN components AS map_component ON bugs.component_id = map_component.id
>INNER JOIN profiles AS map_assigned_to ON bugs.assigned_to = map_assigned_to.userid
>LEFT JOIN flags AS map_flags ON bugs.bug_id = map_flags.bug_id AND map_flags.attach_id IS NULL
>LEFT JOIN flagtypes AS map_flagtypes ON map_flags.type_id = map_flagtypes.id
>LEFT JOIN bug_cf_verified AS map_cf_verified ON bugs.bug_id = map_cf_verified.bug_id
> WHERE bugs.creation_ts IS NOT NULL
>   AND ( (security_map.group_id IS NULL OR security_map.group_id IN (7,94,147,76,68,144,15,155,146,123,122,21,12,106,150,243,41,85,92,50,83,183,133,79,81,182,192,25,75,148,91,108,119,145,218,124,11,207,171,149,161,142,140,80,44,134,215,22,139,138,127,78,126,93,10,48,217,208,209,74,121))
>        OR (bugs.reporter_accessible = 1 AND bugs.reporter = 311350)
>        OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
>        OR bugs.assigned_to = 311350
>        OR bugs.qa_contact = 311350)
>   AND ( map_product.classification_id IN (SELECT classifications.id FROM classifications WHERE  classifications.name IN ('Red Hat') ) AND  bugs.bug_status IN ('NEW','ASSIGNED','MODIFIED','ON_DEV','ON_QA','VERIFIED','RELEASE_PENDING','POST')  AND bugs.bug_id IN (SELECT bug_id FROM longdescs WHERE )
>        AND bugs.bug_id IN (SELECT bug_id FROM longdescs WHERE INSTR(thetext, 'pin') > 0) AND ( (bugs.component_id IN (SELECT components.id FROM components WHERE  components.name IN ('kernel') ) OR bugs.bug_id IN (SELECT bug_cf_extra_component.bug_id FROM bug_cf_extra_component WHERE  bug_cf_extra_component.value IN ('kernel') )) ) AND bugs.product_id IN (SELECT products.id FROM products WHERE  products.name IN ('Red Hat Enterprise Linux 6') ) )
>GROUP BY bugs.bug_id
>ORDER BY bug_id DESC
>LIMIT 1000
>"] at Bugzilla/DB.pm line 1276
>	Bugzilla::DB::__ANON__() called at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/Timeout.pm line 31
>	eval {...} called at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/Timeout.pm line 31
>	DBIx::Timeout::call_with_timeout('undef', 'dbh', 'Bugzilla::DB::Mysql=HASH(0xb6e29e0)', 'code', 'CODE(0xb6a1bd0)', 'timeout', 118) called at Bugzilla/DB.pm line 1277
>	Bugzilla::DB::bz_call_with_timeout('Bugzilla::DB::Mysql=HASH(0xb6e29e0)', 'DBI::st=HASH(0xbb114d0)') called at /var/www/html/bugzilla/buglist.cgi line 851
>
>For help, please send mail to the webmaster (bugzilla-owner@redhat.com), giving this error message and the time and date of the error.

Actions: View

Attachments on bug 826829: 587939