@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_22577.perl | 4 ++++ 1 file changed, 4 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_22577.perl +++ a/installer/data/mysql/atomicupdate/bug_22577.perl @@ -1,6 +1,10 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { $dbh->do( "INSERT INTO `borrowers` (borrowernumber, surname, firstname) VALUES ('-1', 'CRON', 'CRON')" ); + $dbh->do( "UPDATE `statistics` SET borrowernumber = '-1' WHERE borrowernumber = '0'" ); + $dbh->do( "UPDATE `statistics` SET borrowernumber = '-1' WHERE borrowernumber = '0'" ); + $dbh->do( "UPDATE `accountlines` SET manager_id = '-1' WHERE manager_id = '0'" ); + $dbh->do( "UPDATE `action_logs` SET user = '-1' WHERE user = '0'" ); SetVersion( $DBversion ); print "Upgrade to $DBversion done (Bug 22577 - Add internal user for cron)\n"; --