← Back to team overview

zeitgeist team mailing list archive

[Bug 799531] Re: API for deletion of events within a timerange?

 

** Summary changed:

- OperationalError: too many SQL variables
+ API for deletion of events within a timerange?

** Changed in: activity-log-manager
       Status: New => Invalid

** Also affects: zeitgeist
   Importance: Undecided
       Status: New

** Changed in: zeitgeist
   Importance: Undecided => Wishlist

-- 
You received this bug notification because you are a member of Activity
Log Manager, which is the registrant for Activity Log Manager.
https://bugs.launchpad.net/bugs/799531

Title:
  API for deletion of events within a timerange?

Status in Activity Log Manager for Zeitgeist:
  Invalid
Status in Zeitgeist Framework:
  New

Bug description:
  If I try to select date range more then a month it just freezes.

  $ activity-log-manager 
  INFO:zeitgeist.client:Reconnected to Zeitgeist engine...
  Error from Zeitgeist engine: org.freedesktop.DBus.Python.sqlite3.OperationalError: Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/dbus/service.py", line 702, in _message_cb
      retval = candidate_method(self, *args, **keywords)
    File "/usr/share/zeitgeist/_zeitgeist/engine/remote.py", line 337, in DeleteEvents
      timestamps = self._engine.delete_events(event_ids, sender=sender)
    File "/usr/share/zeitgeist/_zeitgeist/engine/main.py", line 838, in delete_events
      % ",".join(["?"] * len(ids)), ids)
    File "/usr/share/zeitgeist/_zeitgeist/engine/sql.py", line 74, in execute
      return super(UnicodeCursor, self).execute(statement, parameters)
  OperationalError: too many SQL variables

  Version: 0.8.0-0ubuntu1~ppa2~natty

To manage notifications about this bug go to:
https://bugs.launchpad.net/activity-log-manager/+bug/799531/+subscriptions