http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10185 Bug ID: 10185 Summary: updatedatabase.pl remove all reserves Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.10 Hardware: All OS: All Status: ASSIGNED Severity: critical Priority: P5 - low Component: Database Assignee: julian.maurice@biblibre.com Reporter: julian.maurice@biblibre.com Update number 3.09.00.025 can remove all reserves from reserves table when there is no entries in old_reserves. This is due to @ai which is set to NULL in SET @ai = ( SELECT MAX( reserve_id ) FROM tmp_reserves ) and reserve_id > NULL returns no results in INSERT INTO reserves SELECT * FROM tmp_reserves WHERE reserve_id > @ai This can be fixed easily by using COALESCE INSERT INTO reserves SELECT * FROM tmp_reserves WHERE reserve_id > COALESCE(@ai, 0) -- You are receiving this mail because: You are watching all bug changes.