--- a/plugins/mod_storage_sql.lua	Tue Nov 30 01:22:14 2021 +0100
+++ b/plugins/mod_storage_sql.lua	Tue Nov 30 15:24:17 2021 +0100
@@ -624,8 +624,12 @@
 		end
 		return engine:delete(sql_query, unpack(args));
 	end);
-	local cache_key = jid_join(username, host, self.store);
-	archive_item_count_cache:set(cache_key, nil);
+	if username == true then
+		archive_item_count_cache:clear();
+	else
+		local cache_key = jid_join(username, host, self.store);
+		archive_item_count_cache:set(cache_key, nil);
+	end
 	return ok and stmt:affected(), stmt;
 end