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

(-)a/installer/data/mysql/atomicupdate/bug_26940.perl (-2 / +1 lines)
Lines 4-10 if( CheckVersion( $DBversion ) ) { Link Here
4
        SELECT d.borrowernumber, GROUP_CONCAT(comment SEPARATOR '\n') AS comment
4
        SELECT d.borrowernumber, GROUP_CONCAT(comment SEPARATOR '\n') AS comment
5
        FROM borrower_debarments d
5
        FROM borrower_debarments d
6
        LEFT JOIN borrowers b ON b.borrowernumber=d.borrowernumber
6
        LEFT JOIN borrowers b ON b.borrowernumber=d.borrowernumber
7
        WHERE b.debarredcomment IS NULL AND ( expiration > CURRENT_DATE() OR expiration IS NULL )
7
        WHERE ( b.debarredcomment IS NULL OR b.debarredcomment = "" ) AND ( expiration > CURRENT_DATE() OR expiration IS NULL )
8
        GROUP BY d.borrowernumber
8
        GROUP BY d.borrowernumber
9
    |, { Slice => {} });
9
    |, { Slice => {} });
10
10
11
- 

Return to bug 26940