[GNUnet-SVN] r5540 - GNUnet/src/applications/sqstore_sqlite

[gnunet]

Author: grothoff
Date: 2007-08-25 02:45:19 -0600 (Sat, 25 Aug 2007)
New Revision: 5540

Modified:
   GNUnet/src/applications/sqstore_sqlite/sqlite.c
Log:
reset select statement before doing deletion -- trying to fix drupal node 
report 266, at least partially

Modified: GNUnet/src/applications/sqstore_sqlite/sqlite.c
===================================================================
--- GNUnet/src/applications/sqstore_sqlite/sqlite.c     2007-08-25 03:30:11 UTC 
(rev 5539)
+++ GNUnet/src/applications/sqstore_sqlite/sqlite.c     2007-08-25 08:45:19 UTC 
(rev 5540)
@@ -392,6 +392,7 @@
               GE_WARNING | GE_BULK | GE_USER,
               _("Invalid data in %s (NCS).  Trying to fix (by deletion).\n"),
               _("sqlite datastore"));
+      sqlite3_reset (stmt);
       if (sq_prepare (dbh,
                       "DELETE FROM gn070 WHERE size < ?", &stmt) == SQLITE_OK)
         {
@@ -414,7 +415,8 @@
               GE_WARNING | GE_BULK | GE_USER,
               _("Invalid data in %s.  Trying to fix (by deletion).\n"),
               _("sqlite datastore"));
-      if (sq_prepare (dbh,
+     sqlite3_reset (stmt);
+     if (sq_prepare (dbh,
                       "DELETE FROM gn070 WHERE NOT ((LENGTH(hash) = ?) AND 
(size = LENGTH(value) + ?))",
                       &stmt) == SQLITE_OK)
         {