@@ -, +, @@ --- C4/Letters.pm | 2 +- .../Bug-14723_-_Additional_delivery_notes_to_messages.perl | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt | 12 +++++++++++- 3 files changed, 13 insertions(+), 3 deletions(-) --- a/C4/Letters.pm +++ a/C4/Letters.pm @@ -960,7 +960,7 @@ sub EnqueueLetter { INSERT INTO message_queue ( borrowernumber, subject, content, metadata, letter_code, message_transport_type, status, time_queued, to_address, from_address, reply_address, content_type, delivery_note ) VALUES -( ?, ?, ?, ?, ?, ?, ?, NOW(), ?, ?, ?, ?, ? ) +( ?, ?, ?, ?, ?, ?, ?, CAST(NOW() AS DATE), ?, ?, ?, ?, ? ) ENDSQL my $sth = $dbh->prepare($statement); --- a/installer/data/mysql/atomicupdate/Bug-14723_-_Additional_delivery_notes_to_messages.perl +++ a/installer/data/mysql/atomicupdate/Bug-14723_-_Additional_delivery_notes_to_messages.perl @@ -1,6 +1,6 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { - $dbh->do("ALTER TABLE message_queue ADD delivery_note mediumtext"); + $dbh->do("ALTER TABLE message_queue ADD delivery_note mediumtext AFTER content_type"); # Always end with this (adjust the bug info) SetVersion( $DBversion ); --- a/koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/members/notices.tt @@ -77,7 +77,17 @@