libreport version: 2.0.6 abrt_version: 2.0.4.981 cmdline: /usr/bin/python /usr/bin/gourmet executable: /usr/bin/gourmet kernel: 3.1.0-7.fc16.i686 reason: default.py:325:do_execute:OperationalError: (OperationalError) no such function: REGEXP u'SELECT DISTINCT recipe.id, recipe.title, recipe.instructions, recipe.modifications, recipe.cuisine, recipe.rating, recipe.description, recipe.source, recipe.preptime, recipe.cooktime, recipe.servings, recipe.yields, recipe.yield_unit, recipe.image, recipe.thumb, recipe.deleted, recipe.recipe_hash, recipe.ingredient_hash, recipe.link, recipe.last_modified \nFROM recipe \nWHERE recipe.deleted = ? AND (recipe.id IN (SELEC time: Sat Nov 19 13:29:28 2011 uid: 500 username: krissa backtrace: :default.py:325:do_execute:OperationalError: (OperationalError) no such function: REGEXP u'SELECT DISTINCT recipe.id, recipe.title, recipe.instructions, recipe.modifications, recipe.cuisine, recipe.rating, recipe.description, recipe.source, recipe.preptime, recipe.cooktime, recipe.servings, recipe.yields, recipe.yield_unit, recipe.image, recipe.thumb, recipe.deleted, recipe.recipe_hash, recipe.ingredient_hash, recipe.link, recipe.last_modified \nFROM recipe \nWHERE recipe.deleted = ? AND (recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.ingkey REGEXP ?) OR recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.item REGEXP ?) OR recipe.id IN (SELECT categories.recipe_id \nFROM categories \nWHERE categories.category REGEXP ?) OR (recipe.cuisine REGEXP ?) OR (recipe.title REGEXP ?) OR (recipe.instructions REGEXP ?) OR (recipe.modifications REGEXP ?) OR (recipe.source REGEXP ?) OR (recipe.link REGEXP ?))' (0, u'a', u'a', u'a', u'a', u'a', u'a', u'a', u'a', u'a') : :Traceback (most recent call last): : File "/usr/lib/python2.7/site-packages/gourmet/recindex.py", line 444, in <lambda> : gobject.idle_add(lambda *args: (self.do_search(txt, searchBy) or parent.window.set_cursor(None))) : File "/usr/lib/python2.7/site-packages/gourmet/recindex.py", line 465, in do_search : sort_by=self.sort_by) : File "/usr/lib/python2.7/site-packages/gourmet/backends/db.py", line 813, in search_recipes : order_by=make_order_by(sort_by,self.recipe_table,), : File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/expression.py", line 2660, in execute : return e._execute_clauseelement(self, multiparams, params) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2292, in _execute_clauseelement : return connection._execute_clauseelement(elem, multiparams, params) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1532, in _execute_clauseelement : compiled_sql, distilled_params : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_context : context) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1633, in _execute_context : context) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 325, in do_execute : cursor.execute(statement, parameters) :OperationalError: (OperationalError) no such function: REGEXP u'SELECT DISTINCT recipe.id, recipe.title, recipe.instructions, recipe.modifications, recipe.cuisine, recipe.rating, recipe.description, recipe.source, recipe.preptime, recipe.cooktime, recipe.servings, recipe.yields, recipe.yield_unit, recipe.image, recipe.thumb, recipe.deleted, recipe.recipe_hash, recipe.ingredient_hash, recipe.link, recipe.last_modified \nFROM recipe \nWHERE recipe.deleted = ? AND (recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.ingkey REGEXP ?) OR recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.item REGEXP ?) OR recipe.id IN (SELECT categories.recipe_id \nFROM categories \nWHERE categories.category REGEXP ?) OR (recipe.cuisine REGEXP ?) OR (recipe.title REGEXP ?) OR (recipe.instructions REGEXP ?) OR (recipe.modifications REGEXP ?) OR (recipe.source REGEXP ?) OR (recipe.link REGEXP ?))' (0, u'a', u'a', u'a', u'a', u'a', u'a', u'a', u'a', u'a') : :Local variables in innermost frame: :cursor: <pysqlite2.dbapi2.Cursor object at 0xa958b60> :self: <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0xa87130c> :statement: u'SELECT DISTINCT recipe.id, recipe.title, recipe.instructions, recipe.modifications, recipe.cuisine, recipe.rating, recipe.description, recipe.source, recipe.preptime, recipe.cooktime, recipe.servings, recipe.yields, recipe.yield_unit, recipe.image, recipe.thumb, recipe.deleted, recipe.recipe_hash, recipe.ingredient_hash, recipe.link, recipe.last_modified \nFROM recipe \nWHERE recipe.deleted = ? AND (recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.ingkey REGEXP ?) OR recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.item REGEXP ?) OR recipe.id IN (SELECT categories.recipe_id \nFROM categories \nWHERE categories.category REGEXP ?) OR (recipe.cuisine REGEXP ?) OR (recipe.title REGEXP ?) OR (recipe.instructions REGEXP ?) OR (recipe.modifications REGEXP ?) OR (recipe.source REGEXP ?) OR (recipe.link REGEXP ?))' :parameters: (0, u'a', u'a', u'a', u'a', u'a', u'a', u'a', u'a', u'a') :context: <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0xa93366c> comment: :(1) open gourmet :(2) type text in the search bar, hit enter :(3) boom! : :100% repeatable since upgrade to F16. : :terminal spew: : :sqlalchemy.exc.OperationalError: (OperationalError) no such function: REGEXP u'SELECT DISTINCT recipe.id, recipe.title, recipe.instructions, recipe.modifications, recipe.cuisine, recipe.rating, recipe.description, recipe.source, recipe.preptime, recipe.cooktime, recipe.servings, recipe.yields, recipe.yield_unit, recipe.image, recipe.thumb, recipe.deleted, recipe.recipe_hash, recipe.ingredient_hash, recipe.link, recipe.last_modified \nFROM recipe \nWHERE recipe.deleted = ? AND (recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.ingkey REGEXP ?) OR recipe.id IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.item REGEXP ?) OR recipe.id IN (SELECT categories.recipe_id \nFROM categories \nWHERE categories.category REGEXP ?) OR (recipe.cuisine REGEXP ?) OR (recipe.title REGEXP ?) OR (recipe.instructions REGEXP ?) OR (recipe.modifications REGEXP ?) OR (recipe.source REGEXP ?) OR (recipe.link REGEXP ?))' (0, u'almond', u'almond', u'almond', u'almond', u'almond', u'almond', u'almond', u'almond', u'almond') :Traceback (most recent call last): : File "/usr/lib/python2.7/site-packages/gourmet/recindex.py", line 444, in <lambda> : gobject.idle_add(lambda *args: (self.do_search(txt, searchBy) or parent.window.set_cursor(None))) : File "/usr/lib/python2.7/site-packages/gourmet/recindex.py", line 470, in do_search : sort_by=self.sort_by) : File "/usr/lib/python2.7/site-packages/gourmet/backends/db.py", line 813, in search_recipes : order_by=make_order_by(sort_by,self.recipe_table,), : File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/expression.py", line 2660, in execute : return e._execute_clauseelement(self, multiparams, params) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2292, in _execute_clauseelement : return connection._execute_clauseelement(elem, multiparams, params) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1532, in _execute_clauseelement : compiled_sql, distilled_params : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_context : context) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1633, in _execute_context : context) : File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 325, in do_execute : cursor.execute(statement, parameters) smolt_data: : : :General :================================= :UUID: 8b112cb2-528d-48af-a4f5-d0f07b61db46 :OS: Fedora release 16 (Verne) :Default run level: Unknown :Language: en_US.utf8 :Platform: i686 :BogoMIPS: 1196.86 :CPU Vendor: GenuineIntel :CPU Model: Intel(R) Pentium(R) M processor 1.60GHz :CPU Stepping: 8 :CPU Family: 6 :CPU Model Num: 13 :Number of CPUs: 1 :CPU Speed: 1600 :System Memory: 1500 :System Swap: 1999 :Vendor: IBM :System: 1869BCU ThinkPad X41 Tablet :Form factor: Notebook :Kernel: 3.1.0-7.fc16.i686 :SELinux Enabled: 1 :SELinux Policy: targeted :SELinux Enforce: Enforcing :MythTV Remote: Unknown :MythTV Role: Unknown :MythTV Theme: Unknown :MythTV Plugin: :MythTV Tuner: -1 : : :Devices :================================= :(32902:16928:32902:10001) pci, ipw2200, NETWORK, PRO/Wireless 2200BG [Calexico2] Network Connection :(4480:1142:4116:1365) pci, yenta_cardbus, PCI/CARDBUS, RL5c476 II :(5348:5757:4116:1399) pci, tg3, ETHERNET, ThinkPad Z60t :(32902:9618:4116:1410) pci, i915, VIDEO, Mobile 915GM/GMS/910GML Express Graphics Controller :(32902:10130:4116:1410) pci, None, VIDEO, Mobile 915GM/GMS/910GML Express Graphics Controller :(32902:9824:0:0) pci, pcieport, PCI/PCI, 82801FB/FBM/FR/FW/FRW (ICH6 Family) PCI Express Port 1 :(32902:9793:4116:1384) pci, None, PCI/ISA, 82801FBM (ICH6M) LPC Interface Bridge :(32902:9811:4116:1386) pci, ata_piix, STORAGE, 82801FBM (ICH6M) SATA Controller :(32902:9834:4116:1387) pci, i801_smbus, SERIAL, 82801FB/FBM/FR/FW/FRW (ICH6 Family) SMBus Controller :(32902:9288:0:0) pci, None, PCI/PCI, 82801 Mobile PCI Bridge :(32902:9838:4116:1409) pci, snd_intel8x0, MULTIMEDIA_AUDIO, 82801FB/FBM/FR/FW/FRW (ICH6 Family) AC'97 Audio Controller :(32902:9837:4116:1398) pci, snd_intel8x0m, SIMPLE, 82801FB/FBM/FR/FW/FRW (ICH6 Family) AC'97 Modem Controller :(32902:9817:4116:1381) pci, uhci_hcd, USB, 82801FB/FBM/FR/FW/FRW (ICH6 Family) USB UHCI #2 :(32902:9816:4116:1381) pci, uhci_hcd, USB, 82801FB/FBM/FR/FW/FRW (ICH6 Family) USB UHCI #1 :(32902:9616:4116:1397) pci, agpgart-intel, HOST/PCI, ThinkPad Z60t :(32902:9818:4116:1381) pci, uhci_hcd, USB, 82801FB/FBM/FR/FW/FRW (ICH6 Family) USB UHCI #3 :(4480:2082:4116:1366) pci, sdhci-pci, BASE, ThinkPad X60s / Z60t :(32902:9819:4116:1381) pci, uhci_hcd, USB, 82801FB/FBM/FR/FW/FRW (ICH6 Family) USB UHCI #4 :(32902:9820:4116:1382) pci, ehci_hcd, USB, 82801FB/FBM/FR/FW/FRW (ICH6 Family) USB2 EHCI Controller : : :Filesystem Information :================================= :device mtpt type bsize frsize blocks bfree bavail file ffree favail :------------------------------------------------------------------- :/dev/sda3 / ext4 4096 4096 8983714 4342041 4250806 2285568 2166154 2166154 :/dev/sda1 /boot ext4 1024 1024 495844 459835 434235 128016 127777 127777 :
Retitling with more informative title. Other possibly related bugs (all SQL-related, at least) are at bug 746513, bug 752534, and bug 722727.
Updating version to F17 since this still occurs there.
This message is a reminder that Fedora 17 is nearing its end of life. Approximately 4 (four) weeks from now Fedora will stop maintaining and issuing updates for Fedora 17. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At that time this bug will be closed as WONTFIX if it remains open with a Fedora 'version' of '17'. Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, simply change the 'version' to a later Fedora version prior to Fedora 17's end of life. Bug Reporter: Thank you for reporting this issue and we are sorry that we may not be able to fix it before Fedora 17 is end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora, you are encouraged change the 'version' to a later Fedora version prior to Fedora 17's end of life. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete.
Fedora 17 changed to end-of-life (EOL) status on 2013-07-30. Fedora 17 is no longer maintained, which means that it will not receive any further security or bug fix updates. As a result we are closing this bug. If you can reproduce this bug against a currently maintained version of Fedora please feel free to reopen this bug against that version. Thank you for reporting this bug and we are sorry it could not be fixed.