Merge pull request #563 from nextcloud/bugfix/558/pgsql-migration

avoid empty boolean value

1 files changed, 11 insertions, 0 deletions

diff --git a/lib/Migration/Version0002Date20190506000001.php b/lib/Migration/Version0002Date20190506000001.php
index 2a96312c..296f7b74 100644
--- a/lib/Migration/Version0002Date20190506000001.php
+++ b/lib/Migration/Version0002Date20190506000001.php
@@ -1223,6 +1223,13 @@ class Version0002Date20190506000001 extends SimpleMigrationStep {
 			'published_time'
 		];
 
+		$booleanFields = [
+			'local',
+			'public',
+			'accepted',
+			'hidden_on_timeline'
+		];
+
 		foreach ($fields as $field) {
 			$value = $this->get($field, $data, '');
 			if ($field === 'id_prim'
@@ -1236,6 +1243,10 @@ class Version0002Date20190506000001 extends SimpleMigrationStep {
 					$field,
 					$insert->createNamedParameter(new DateTime('now'), IQueryBuilder::PARAM_DATE)
 				);
+			} else if (in_array($field, $booleanFields) && $value === '') {
+				$insert->setValue(
+					$field, $insert->createNamedParameter('0')
+				);
 			} else {
 				$insert->setValue(
 					$field, $insert->createNamedParameter($value)