From f84c633a126e8e4b71d31a4b707a8949db6d4b41 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 16 Jun 2020 15:12:50 -0400 Subject: [PATCH] don't allow systempreferences to be null --- kmig.d/bin/mig-import | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/kmig.d/bin/mig-import b/kmig.d/bin/mig-import index 1edab2c..1788226 100755 --- a/kmig.d/bin/mig-import +++ b/kmig.d/bin/mig-import @@ -682,8 +682,8 @@ sub restore_preferences { my $dom = $parser->parse_file($restore_file); foreach my $node ($dom->findnodes('//pref')) { - my $variable = domain_shift(sql_str($node->findvalue('./variable'))); - my $value = domain_shift(sql_str($node->findvalue('./value'))); + my $variable = domain_shift(sql_str_not_null($node->findvalue('./variable'))); + my $value = domain_shift(sql_str_not_null($node->findvalue('./value'))); my $query = "UPDATE systempreferences SET value = $value WHERE variable = $variable"; my $sth = $dbh->prepare($query); $sth->execute(); -- 1.7.2.5