[Tracker] a small patch to fix sqlite ERROR for trunk



When I build tracker trunk and run it today, I found that
it always prompts ERROR like this

ERROR: prepared query GetMimePrefixForServiceId not found
ERROR: incorrect no of parameters 1 supplied to GetMimePrefixForServiceId
ERROR: parameter 0 could not be bound to GetMimePrefixForServiceId
ERROR: execution of prepared query GetMimePrefixForServiceId failed due to not an error with return code 21


and I check the code, with the patch.

Index: data/sqlite-stored-procs.sql
===================================================================
--- data/sqlite-stored-procs.sql    (revision 1258)
+++ data/sqlite-stored-procs.sql    (working copy)
@@ -125,7 +125,7 @@
InsertMimePrefixes replace into FileMimePrefixes (MimePrefix) Values (?);

GetMimeForServiceId select Mime from FileMimes where ServiceTypeId = ?;
-GetMimePrefixeForServiceId select MimePrefix from FileMimesPrefix where ServiceTypeId = ?; +GetMimePrefixForServiceId select MimePrefix from FileMimePrefixes where ServiceTypeId = ?;

ExistsPendingFiles select count (*) from FilePending where Action <> 20;
InsertPendingFile INSERT INTO FilePending (FileID, Action, PendingDate, FileUri, MimeType, IsDir, IsNew, RefreshEmbedded, RefreshContents, ServiceTypeID) VALUES (?,?,?,?,?,?,?,?,?,?);





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]