Attachment 688190 Details for Bug 904676 – File: backtrace

File: backtrace

backtrace (text/plain), 4.49 KB, created by Luis Villa on 2013-01-27 00:39:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Luis Villa

Created: 2013-01-27 00:39:30 UTC

Size: 4.49 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'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c')
>
>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 2841, in execute
>    return e._execute_clauseelement(self, multiparams, params)
>  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2453, 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'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c')
>
>Local variables in innermost frame:
>cursor: <sqlite3.Cursor object at 0x3239960>
>self: <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x2f29210>
>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'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c')
>context: <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x3243f50>

Actions: View

Attachments on bug 904676: 688190 | 688191 | 688192 | 688193