using gourmet recipe manager on two almost identical configuration, one is ok whereas the other systematically crashes when searching. OS for both computer is ubuntu 12.04 i386. The problem seems identical to what is reported in the following bug for fedora : https://bugzilla.redhat.com/show_bug.cgi?id=755234
Here is the output from terminal :
Traceback (most recent call last):
File "/usr/share/gourmet/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/share/gourmet/gourmet/recindex.py", line 465, in do_search
File "/usr/share/gourmet/gourmet/backends/db.py", line 813, in search_recipes
File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/expression.py", line 2734, in execute
return e._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2304, in _execute_clauseelement
return connection._execute_clauseelement(elem, multiparams, params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1538, in _execute_clauseelement
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in do_execute
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'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c', u'c')
Reinstalling both sql-alchemy and gourmet does not eliminate the error.
Gourmet is a very good application. Thanks for future help resolvoving this issue.
Finally, i found a way to have or avoid the error on both PC.
Error always and only occurs when the search option "use regular expression in search" is activated !
So it is possible to easily bypass the problem.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.