Attachment 599824 Details for Bug 842378 – File: backtrace

File: backtrace

backtrace (text/plain), 4.50 KB, created by Sean Sheedy on 2012-07-23 16:03:39 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Sean Sheedy

Created: 2012-07-23 16:03:39 UTC

Size: 4.50 KB

patch

obsolete

>default.py:331: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't', u't', u't', u't', u't', u't', u't', u't', u't')
>
>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/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 2826, in execute
>    return e._execute_clauseelement(self, multiparams, params)
>  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2454, in _execute_clauseelement
>    return connection._execute_clauseelement(elem, multiparams, params)
>  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
>    compiled_sql, distilled_params
>  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
>    context)
>  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
>    context)
>  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, 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't', u't', u't', u't', u't', u't', u't', u't', u't')
>
>Local variables in innermost frame:
>cursor: <pysqlite2.dbapi2.Cursor object at 0x3307c90>
>self: <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x3176190>
>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't', u't', u't', u't', u't', u't', u't', u't', u't')
>context: <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x338f910>

Actions: View

Attachments on bug 842378: 599824