hamster-applet crashed with OperationalError in execute(): no such module: fts3

Downgrading to pygobject 2.27.0+git20110108-0ubuntu1 fixes the issue. This is likely the same as bug #713115.

I can reproduce the crash, but it happens with the old pygobject as well:

ii python-gobject 2.27.0+git20110108-0ubuntu1 Python bindings for the GObject library
ii python-gobject-cairo 2.27.0+git20110108-0ubuntu1 Python Cairo bindings for the GObject library

rm -r ~/.local/share/hamster-applet
$ /usr/bin/hamster-service
hamster-service up
Traceback (most recent call last):
  File "/usr/bin/hamster-service", line 22, in <module>
    storage = db.Storage(loop)
  File "/usr/lib/pymodules/python2.7/hamster/db.py", line 82, in __init__
    self.run_fixtures()
  File "/usr/lib/pymodules/python2.7/hamster/db.py", line 1182, in run_fixtures
    USING fts3(id, name, category, description, tag)""")
  File "/usr/lib/pymodules/python2.7/hamster/db.py", line 921, in execute
    cur.execute(state, param)
sqlite3.OperationalError: no such module: fts3

Also, this doesn't look related to pygobject itself. Can yo u confirm that it works for you if you temporarily move away your ~/.local/share/hamster-applet, ensure that hamster-service isn't running, and start it like above?

It does work. Here is what I did to confirm:

1. removed hamster from my panel
2. logged out
3. verified no 'hamster' processes were running (ps auxww|grep hamster)
4. mv ~/.local/share/hamster-applet ~/.local/share/hamster-applet.bak
5. Then did:
$ /usr/bin/hamster-service
hamster-service up
updated database from version 7 to 9
^CTraceback (most recent call last):
  File "/usr/bin/hamster-service", line 23, in <module>
    loop.run()
KeyboardInterrupt
$ /usr/bin/hamster-service
hamster-service up
^CTraceback (most recent call last):
  File "/usr/bin/hamster-service", line 23, in <module>
    loop.run()
KeyboardInterrupt
$ rm -rf ./hamster-applet
$ /usr/bin/hamster-service
hamster-service up
updated database from version 7 to 9
^CTraceback (most recent call last):
  File "/usr/bin/hamster-service", line 23, in <module>
    loop.run()
KeyboardInterrupt

I thought the 'updated database from version 7 to 9' was weird, but hamster seems to output that when ~/.local/share/hamster-applet doesn't exist (as seen from the above).

Heh, step 2.5: log back in

:)

Hm, so this is a miracle to me... One patch which caused major disruption was http://git.gnome.org/browse/pygobject/commit/?id=f0a0b6c2eda89622de2b1e5ebb6a48103ad72a42 (see bug 713115 comment 4). Could you perhaps try rebuilding pygobject locally with the attached patch applied? does that help?

Applying the patch makes hamster work again.

This has been fixed for a while.

The fix for bug #713115 is what fixed this.