Comment 2 for bug 799531

Sorry for the late reply...
We have 2 ways of solving this... Either handle the overload of
variables internally by doing it over several iterations or we lessen the
variables given by ALM. I will look into it this week.
Cheers
Seif

2011/9/4 hdpq <email address hidden>

> Not a single reply since June? How sad.
> I can confirm this bug, except that for me it occurs every time I try to
> clear history with date range of 1 day or more.
> Setting it to 6 hours worked (but, obviously, it only removed the events
> from the last 6 hours).
>
> --
> 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:
> OperationalError: too many SQL variables
>
> Status in Activity Log Manager for Zeitgeist:
> 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
> _______________________________________________
> Dev mailing list
> <email address hidden>
> http://lists.zeitgeist-project.com/cgi-bin/mailman/listinfo/dev
>