@@ -, +, @@ entries --- .../data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl +++ a/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl @@ -20,7 +20,7 @@ if( CheckVersion( $DBversion ) ) { foreach my $lang ( @langs ) { print "Inserting OpacNav contents into $lang news item...\n"; # If there is a value in the OpacNav preference, insert it into opac_news - $dbh->do("INSERT INTO opac_news (branchcode, lang, title, content ) VALUES (NULL, ?, '', ?)", undef, "OpacNav_$lang", $opacnav); + $dbh->do("INSERT INTO opac_news (branchcode, lang, title, content, published_on ) VALUES (NULL, ?, '', ?, CAST(NOW() AS date))", undef, "OpacNav_$lang", $opacnav); } } # Remove the OpacNav system preference --