@@ -, +, @@ items we want --- installer/data/mysql/atomicupdate/bug_27808.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_27808.perl +++ a/installer/data/mysql/atomicupdate/bug_27808.perl @@ -5,7 +5,7 @@ if( CheckVersion( $DBversion ) ) { UPDATE items LEFT JOIN issues ON issues.itemnumber=items.itemnumber SET items.onloan=CAST(issues.date_due AS DATE) - WHERE items.onloan IS NULL + WHERE items.onloan IS NULL AND issues.issue_id IS NOT NULL |); NewVersion( $DBversion, 27808, "Adjust items.onloan if needed"); --