Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 587939 Details for
Bug 826829
Software error when doing anywords or allwords search that starts or ends with a space
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
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:
20120531-bugzilla-query-error.txt
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.
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 826829
: 587939