Zeitgeist-daemon doesn't work

[JLR]

I ge this
INFO:zeitgeist.engine.base:Creating database: sqlite:/home/artir/.local/share/zeitgeist/database.sqlite
INFO:root:Checking for another running instance...
INFO:root:No other instances found.
INFO:root:Starting Zeitgeist service...
DEBUG:zeitgeist.logger.datasources.firefox:Monitoring Firefox history: /home/artir/.mozilla/firefox/f1tqjheq.default/places.sqlite
DEBUG:zeitgeist.logger.database.tomboy:watching '/home/artir/.tomboy' for tomboy notes
DEBUG:root:Updating database with new Firefox History items
Traceback (most recent call last):
  File "/home/artir/Escritorio/zeitgeist/zeitgeist/../zeitgeist-datahub", line 97, in _update_db_async
    self._insert_events(self._sources_queue[0].get_name(), items)
  File "/home/artir/Escritorio/zeitgeist/zeitgeist/../zeitgeist-datahub", line 115, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
dbus.exceptions.DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/artir/Escritorio/zeitgeist/zeitgeist/engine/remote.py", line 176, in InsertEvents
    result = _engine.insert_events([dictify_data(x) for x in event_list])
  File "/home/artir/Escritorio/zeitgeist/zeitgeist/engine/engine.py", line 240, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/artir/Escritorio/zeitgeist/zeitgeist/engine/engine.py", line 210, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

[Siegfried Gevatter (rainct)]

You need python-sqlite3, not python-pysqlite2 nor anything else.

In version 0.1.0 you can workaround this and use pysqlite2 by running:
 sed -i 's/sqlite3/pysqlite2.dbapi2/g' zeitgeist/*/*.py zeitgeist/*/*/*.py

(However in future versions, when we kick out Storm, we'll probably only support python-sqlite3).