Dear all, I had the same error. Here is the solution:
SET FOREIGN_KEY_CHECKS = 0; ALTER TABLE issues MODIFY COLUMN borrowernumber int(11) NOT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', MODIFY COLUMN itemnumber int(11) NOT NULL COMMENT 'foreign key, linking this to the items table for the item that was checked out' SET FOREIGN_KEY_CHECKS = 1; Best Regards, Eugen Bastron Am 04.12.22, 08:48 schrieb "Koha im Auftrag von Pablo Bianchi" <[email protected] <mailto:[email protected]> im Auftrag von [email protected] <mailto:[email protected]>>: Thank you all for the answers! On Sat, 3 Dec 2022 at 18:59, Katrin Fischer <[email protected] <mailto:[email protected]>> wrote: > Do you have entries in your issues table, where the borrowernumber is > NULL? > Nope. In fact, *issues* has only one row, with its integer on borrowernumber: issue_id: 2. *borrowernumber: 53805*. issuer_id: NULL. *itemnumber: 1581.* date_due: 2020-10-08 23:59:00. branchcode: BC. returndate: NULL. lastreneweddate: NULL. renewals: 0. unseen_renewals: 0. auto_renew: 0. auto_renew_error: NULL. timestamp: 2020-10-07 15:29:52. issuedate: 2020-10-07 15:29:52. onsite_checkout: 0. note: NULL. notedate: NULL. noteseen: NULL. On Sun, 4 Dec 2022 at 01:00, Tomas Cohen Arazi <[email protected] <mailto:[email protected]>> wrote: > That's a data issue. Maybe an old bug let things in wrongly on the db, it > incomplete data migration. > > You should do something with those checkouts with no linked patron, and > the upgrade script will continue where it left. > borrowernumber (and itemnumber) are not NULL in the only row of issues table. Also, the borrowernumber (53805) exists on borrowers table. Could be something else? As a last resource (I wish to avoid) I could DELETE the row. This will always cascade any action and can't break any consistency? JFTR, even of course upgrading to Debian 10 has nothing to do with this, I had some trouble with Apache and Memcached and new security features of systemd (like PrivateTmp). I had to disable them. _______________________________________________ Koha mailing list http://koha-community.org <http://koha-community.org> [email protected] <mailto:[email protected]> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha> _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
