From e218208ea48e8e5cefe8dd40ac855807974d8590 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Mon, 28 Sep 2020 13:45:23 +0000 Subject: [PATCH] Bug 24223: (follow-up) Add date to OpacNav news entries This follow-up modifies the atomic update so that it inserts today's date as the "Published on" date. Without that information the system considers the item unpublished and will not display the content. Signed-off-by: David Nind --- installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl b/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl index 29a24a8747..72802aed77 100644 --- a/installer/data/mysql/atomicupdate/bug_24223-move-opacnav-to-news.perl +++ b/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 -- 2.11.0