https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37531 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |major Summary|Cannot access Circulation |Cannot access circulation |Rules page after update to |rules page |24.05.02 | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37531 Harsha <hbala@ou.ac.lk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |hbala@ou.ac.lk --- Comment #3 from Harsha <hbala@ou.ac.lk> --- I also experiencing the same issue after upgrading version to 24.05.02; Error 500 when click the "Circulation and fine rules" in Administration Panel. Same Log error -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37531 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=37255, | |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=37263 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37531 --- Comment #5 from Isabel Pineda <isabel.pineda@ds.edu.sv> --- I`m sorry, I didn't answer, I was on vacation. (In reply to Katrin Fischer from comment #1)

Hi Isabel, I think maybe you have a circulation rule set for an itemtype code that was deleted. Are you able to verify that with SQL maybe?

No, I haven't deleted any item types ultimately. (In reply to Emily Lamancusa from comment #2)

This sounds like bug 37255 or bug 37263. Do you have a Default waiting hold cancellation policy for All patron categories and All item types? Or, if your system allows article requests, do you have a Default article request fee rule defined for All patron categories?

I know that I have some rules for All patron caterories and some rules for All item types, but I don't think that I have any rule for All Patron categories and All item types at the same time. When I look at the data of the table 'circulation_rules', I find 773 rows of data. I am sure that I don't haven't set up that many rules, and I am not sure what I have to look for. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37531 --- Comment #7 from Isabel Pineda <isabel.pineda@ds.edu.sv> --- (In reply to Emily Lamancusa from comment #6)

Each individual cell in the circulation rules table is its own row in the database, so that's why it seems like such an excessive number of rows!

In this case, you would be looking for a row with the following values: branchcode: null (will be blank in the report) categorycode: null itemtype: null rule_name: waiting_hold_cancellation or article_request_fee

Yes, I have one row with branchcode: null categorycode: null itemtype: null rule_name: waiting_hold_cancellation rule_value: 0 What do I have to do with it? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37531 --- Comment #9 from Isabel Pineda <isabel.pineda@ds.edu.sv> --- (In reply to Emily Lamancusa from comment #8)

Okay, that confirms that bug 37255 is indeed the cause of the 500 error. The fix hasn't been backported to 24.05 yet, but in the meantime, if you're confident in deleting just that one row without affecting any others, that should fix the 500 error. "No" is the default behavior, so you won't need to do anything else.

*** This bug has been marked as a duplicate of bug 37255 ***

Thank you, deleting the row fixed the problem. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.