crash on search under ubuntu

  • linusable

    linusable - 2012-08-01

    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 :

    Here is the output from terminal :
    Traceback (most recent call last):
      File "/usr/share/gourmet/gourmet/", 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/", line 465, in do_search
      File "/usr/share/gourmet/gourmet/backends/", line 813, in search_recipes
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/", line 2734, in execute
        return e._execute_clauseelement(self, multiparams, params)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/", line 2304, in _execute_clauseelement
        return connection._execute_clauseelement(elem, multiparams, params)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/", line 1538, in _execute_clauseelement
        compiled_sql, distilled_params
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/", line 1646, in _execute_context
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/", line 1639, in _execute_context
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/", line 330, in do_execute
        cursor.execute(statement, parameters)
    sqlalchemy.exc.OperationalError: (OperationalError) no such function: REGEXP u'SELECT DISTINCT, 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.last_modified \nFROM recipe \nWHERE recipe.deleted = ? AND ( IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.ingkey REGEXP ?) OR IN (SELECT ingredients.recipe_id \nFROM ingredients \nWHERE ingredients.item REGEXP ?) OR 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 ( 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.

  • linusable

    linusable - 2012-08-02

    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.