Bug 447405
| Summary: | Summary: TB58ddd93c sqlutils.py:159:executeSQLQmark:OperationalError: unrecognized token: "' " | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | phracking |
| Component: | yum | Assignee: | Seth Vidal <skvidal> |
| Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | low | Docs Contact: | |
| Priority: | low | ||
| Version: | 8 | CC: | ffesti, james.antill, jhutar, katzj, petrosyan, pmatilai, tim.lauridsen |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2008-09-09 20:57:21 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: | |||
Well in the upstream code: yum search "'" ...now works, I'm 99% sure I fixed that post 3.2.8 though. So this will get fixed if/when we backrelease a Fed-9 release. Hello,
I was able to reproduce this with pirut-1.3.25-2.fc8 yum-3.2.7-1.fc8, and I'm still getting this with pirut-1.3.31-1.fc8 and yum-3.2.8-2.fc8
Steps:
1. run pirut
2. search for "'" (just one quotation mark)
Component: pirut
Summary: TB58ddd93c sqlutils.py:159:executeSQLQmark:OperationalError: unrecognized token: "' "
Traceback (most recent call last):
File "/usr/sbin/pirut", line 201, in _searchClicked
for (po, res) in self.searchGenerator(fields, t_list):
File "/usr/lib/python2.5/site-packages/yum/__init__.py", line 1306, in searchGenerator
narrowed_list.extend(sack.searchPrimaryFields(sql_fields, s))
File "/usr/lib/python2.5/site-packages/yum/sqlitesack.py", line 388, in searchPrimaryFields
executeSQL(cur, basestring)
File "/usr/lib/python2.5/site-packages/yum/sqlutils.py", line 159, in executeSQLQmark
return cursor.execute(query)
OperationalError: unrecognized token: "' "
Local variables in innermost frame:
cursor: <sqlite3.Cursor object at 0xa86d8c0>
query: select DISTINCT pkgId from packages where name like '%'%' or summary like '%'%' or description like '%'%'
params: None
please try this is in 3.2.17 from f8 updates-testing. Thank you, VERIFIED with: yum-3.2.18-1.fc8 pirut-1.3.25-2.fc8 VERIFIED means that the bug is still present. If the bug has been fixed change its status to CLOSED and not VERIFIED. |
Component: pirut Summary: TB58ddd93c sqlutils.py:159:executeSQLQmark:OperationalError: unrecognized token: "' " <--- the classic single quote Traceback (most recent call last): File "/usr/sbin/pirut", line 201, in _searchClicked for (po, res) in self.searchGenerator(fields, t_list): File "/usr/lib/python2.5/site-packages/yum/__init__.py", line 1306, in searchGenerator narrowed_list.extend(sack.searchPrimaryFields(sql_fields, s)) File "/usr/lib/python2.5/site-packages/yum/sqlitesack.py", line 388, in searchPrimaryFields executeSQL(cur, basestring) File "/usr/lib/python2.5/site-packages/yum/sqlutils.py", line 159, in executeSQLQmark return cursor.execute(query) OperationalError: unrecognized token: "' " Local variables in innermost frame: cursor: <sqlite3.Cursor object at 0x5551978> query: select DISTINCT pkgId from packages where name like '%'%' or summary like '%'%' or description like '%'%' params: None