From ff612388820a8e5214a734ad18735be72006bad6 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 3 Nov 2020 08:16:18 +0100
Subject: [locations] install: Fix migration of openingtimes

---
 modules-available/locations/install.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/modules-available/locations/install.inc.php b/modules-available/locations/install.inc.php
index 5664c7ed..c5fd9688 100644
--- a/modules-available/locations/install.inc.php
+++ b/modules-available/locations/install.inc.php
@@ -50,7 +50,7 @@ if (tableHasColumn('locationinfo_locationconfig', 'openingtime')) {
 			"UPDATE location, locationinfo_locationconfig
 			SET location.openingtime = locationinfo_locationconfig.openingtime
 			WHERE location.locationid = locationinfo_locationconfig.locationid
-			  AND Length(location.openingtime) < 5
+			  AND (Length(location.openingtime) < 5 OR location.openingtime IS NULL)
 			  AND Length(locationinfo_locationconfig.openingtime) > 5") === false) {
 		finalResponse(UPDATE_FAILED, 'Could not migrate openingtime data from table to table');
 	}
-- 
cgit v1.2.3-55-g7522