X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=kmig.d%2Fbin%2Fmig-import;fp=kmig.d%2Fbin%2Fmig-import;h=17882263f24f027e648cd57a86357254aa5f2e32;hp=1edab2c868cb11b8dd6689890750a21fe0c7b59f;hb=f84c633a126e8e4b71d31a4b707a8949db6d4b41;hpb=c40cdac06a0639d034579f8d7351a3cdb82c69ee 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();