crash on search under ubuntu

Help
linusable
2012-08-01
2013-05-14
  • 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 : 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
        sort_by=self.sort_by)
      File "/usr/share/gourmet/gourmet/backends/db.py", line 813, in search_recipes
        order_by=make_order_by(sort_by,self.recipe_table,),
      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
        compiled_sql, distilled_params
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
        context)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
        context)
      File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in do_execute
        cursor.execute(statement, parameters)
    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.

     
  • 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.