2 if( CheckVersion( $DBversion ) ) {
4 if ( column_exists('opac_news', 'new' ) ) {
5 $dbh->do(q|ALTER TABLE opac_news CHANGE COLUMN new content text NOT NULL|);
8 my ( $used_in_templates ) = $dbh->selectrow_array(q|
9 SELECT COUNT(*) FROM letter WHERE content LIKE "%<<opac_news.new>>%";
11 if ( $used_in_templates ) {
12 print "WARNING - It seems that you are using the opac_news.new column in your notice templates\n";
13 print "Since it has now been renamed with opac_news.content, you should update them.\n";
16 SetVersion( $DBversion );
17 print "Upgrade to $DBversion done (Bug 17960 - Rename opac_news with opac_news.content)\n";