tracker r1552 - in branches/xesam-support: . data

[pvanhoof svn gnome org]

Author: pvanhoof
Date: Fri May 30 13:58:18 2008
New Revision: 1552
URL: http://svn.gnome.org/viewvc/tracker?rev=1552&view=rev

Log:
2008-05-30  Philip Van Hoof  <pvanhoof gnome org>

        * data/sqlite-stored-procs.sql: Fixed syntax error of a stored
        procedure (LiveSearchStopSearch)



Modified:
   branches/xesam-support/ChangeLog
   branches/xesam-support/data/sqlite-stored-procs.sql

Modified: branches/xesam-support/data/sqlite-stored-procs.sql
==============================================================================
--- branches/xesam-support/data/sqlite-stored-procs.sql	(original)
+++ branches/xesam-support/data/sqlite-stored-procs.sql	Fri May 30 13:58:18 2008
@@ -34,7 +34,7 @@
 DeleteLiveSearchDeletedIDs DELETE FROM LiveSearches AS Y WHERE Y.ServiceID IN SELECT ServiceID FROM Events as E, LiveSearches as X WHERE E.ServiceID = X.ServiceID AND X.SearchID = ? AND E.EventType IS 'Delete'
 
 GetLiveSearchHitCount SELECT count(*) FROM LiveSearches WHERE SearchID = ?;
-LiveSearchStopSearch DELETE FROM LiveSearches as X WHERE E.SearchID = ?
+LiveSearchStopSearch DELETE FROM LiveSearches WHERE SearchID = ?
 
 GetNewEventID SELECT OptionValue FROM Options WHERE OptionKey = 'EventSequence';
 UpdateNewEventID UPDATE Options set OptionValue = ? WHERE OptionKey = 'EventSequence';