Hi, same problem here. Googling around, I've found a related issue here: https://lists.katipo.co.nz/public/koha/2022-October/058542.html It seems to have to do with a constraint on a column, to be removed before the update can be applied, and then to be enforced again. But I wouldn't dare adapting that solution to this specific case without further guidance by someone more expert than me ... Could anyone help, please? Regards, Giuseppe (CC: Sami Rasheed)
Hi all, it looks like this is the same issue that Pablo Bianchi. I have filed a new bug report now linking it to bug 30483: *Bug 32399* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32399> - Database update for bug 30483 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30483> is failing But I am not sure how to resolve it. Could you check if you have any NULL entries in issues.borrowernumber? Hope this helps, Katrin On 03.12.22 05:41, Giuseppe Angilella wrote:
Hi,
same problem here.
Googling around, I've found a related issue here:
https://lists.katipo.co.nz/public/koha/2022-October/058542.html
It seems to have to do with a constraint on a column, to be removed before the update can be applied, and then to be enforced again.
But I wouldn't dare adapting that solution to this specific case without further guidance by someone more expert than me ...
Could anyone help, please?
Regards,
Giuseppe (CC: Sami Rasheed)
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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 03.12.22, 07:42 schrieb "Koha im Auftrag von Giuseppe Angilella" <koha-bounces@lists.katipo.co.nz <mailto:koha-bounces@lists.katipo.co.nz> im Auftrag von Giuseppe.Angilella@ct.infn.it <mailto:Giuseppe.Angilella@ct.infn.it>>: Hi, same problem here. Googling around, I've found a related issue here: https://lists.katipo.co.nz/public/koha/2022-October/058542.html <https://lists.katipo.co.nz/public/koha/2022-October/058542.html> It seems to have to do with a constraint on a column, to be removed before the update can be applied, and then to be enforced again. But I wouldn't dare adapting that solution to this specific case without further guidance by someone more expert than me ... Could anyone help, please? Regards, Giuseppe (CC: Sami Rasheed) _______________________________________________ Koha mailing list http://koha-community.org <http://koha-community.org> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>
participants (3)
-
DHIM IT -
Giuseppe Angilella -
Katrin Fischer