[Koha-bugs] [Bug 29457] Fee Cancellation records the wrong manager_id

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29457 --- Comment #29 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- This seems like overkill. But it worked for me without CAST warnings etc on alphanumeric userid's : UPDATE accountlines LEFT JOIN borrowers ON CAST(borrowers.userid AS INT) = accountlines.manager_id SET manager_id = borrowers.borrowernumber WHERE manager_id IS NOT NULL AND userid RLIKE "^[0-9]+$" AND borrowers.borrowernumber IS NOT NULL AND credit_type_code = 'CANCELLATION' -- You are receiving this mail because: You are watching all bug changes.