View | Details | Raw Unified | Return to bug 18121
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-8 / +3 lines)
Lines 13868-13883 if( CheckVersion( $DBversion ) ) { Link Here
13868
        $dbh->do(q|ALTER TABLE opac_news CHANGE COLUMN new content text NOT NULL|);
13868
        $dbh->do(q|ALTER TABLE opac_news CHANGE COLUMN new content text NOT NULL|);
13869
    }
13869
    }
13870
13870
13871
    my ( $used_in_templates ) = $dbh->selectrow_array(q|
13871
    $dbh->do(q|
13872
        SELECT COUNT(*) FROM letter WHERE content LIKE "%<<opac_news.new>>%";
13872
        UPDATE letter SET content = REPLACE(content, "<<opac_news.new>>", "<<opac_news.content>>") WHERE content LIKE "%<<opac_news.new>>%"
13873
    |);
13873
    |);
13874
    if ( $used_in_templates ) {
13875
        print "WARNING - It seems that you are using the opac_news.new column in your notice templates\n";
13876
        print "Since it has now been renamed with opac_news.content, you should update them.\n";
13877
    }
13878
13874
13879
    SetVersion( $DBversion );
13875
    SetVersion( $DBversion );
13880
    print "Upgrade to $DBversion done (Bug 17960 - Rename opac_news with opac_news.content)\n";
13876
    print "Upgrade to $DBversion done (Bug 17960 - Rename opac_news with opac_news.content (template notices have been updated!))\n";
13881
}
13877
}
13882
13878
13883
$DBversion = "16.12.00.008";
13879
$DBversion = "16.12.00.008";
13884
- 

Return to bug 18121