# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1686954165 -7200
# Node ID 841276d0cc2559ae985e5e1e57101aa949870132
# Parent  019cd1db9bec78e42326910adfdd3973893172ac
mod_storage_sql: Only remove old index if it exists

Avoids an error if the upgrade is performed twice..

diff -r 019cd1db9bec -r 841276d0cc25 plugins/mod_storage_sql.lua
--- a/plugins/mod_storage_sql.lua	Sat Jun 17 00:00:21 2023 +0200
+++ b/plugins/mod_storage_sql.lua	Sat Jun 17 00:22:45 2023 +0200
@@ -859,16 +859,18 @@
 					end
 				end
 			end)
-			if apply_changes then
-				local success = engine:transaction(function ()
-					return assert(engine:execute([[DROP INDEX "prosody_index";]]));
-				end);
-				if not success then
-					module:log("error", "Failed to delete obsolete index \"prosody_index\"");
-					return false;
+			if indices["prosody_index"] then
+				if apply_changes then
+					local success = engine:transaction(function ()
+						return assert(engine:execute([[DROP INDEX "prosody_index";]]));
+					end);
+					if not success then
+						module:log("error", "Failed to delete obsolete index \"prosody_index\"");
+						return false;
+					end
+				else
+					changes = true;
 				end
-			else
-				changes = changes or indices["prosody_index"];
 			end
 		end
 	return changes;