500 internal server error - only in one category
Hi All, I just upgraded to Koha Koha version: 22.05.21.000 and imported sql data from a older system ( 20.05.15.001 ) The catalog looks fine, as well as my "Board" "Staff" and "Teacher" categories. However, whenever I select my "Student" category, and try a search in the left leaving the "search" blank and just searching for the Student Category , I get a "Something went wrong loading the table 500 internal Server error" Trying to browse by last names gives the same "500 internal Server error" error. If I try typing in a last name, it seems to work, and will bring up a list of names. I already tried exporting a 2nd DB dump and importing it clean...same issue. Any idea where to start ?? It seems like the data is good, it seems like it's all there. but it's not being sorted / indexed correctly ? I tried looking in log files, but I really didn't see much . -S
Something I've seen recently is accidentally using a category name in sql where it should be a code, for instance setting a user's category code to Adult instead of AD (or whatever is appropriate in your db). If you run this sql in your database and one category code stands out that may help you track it down: select count(borrowernumber), categorycode from borrowers group by 2; Jason -- Jason Boyer Senior System Administrator Equinox Open Library Initiative JBoyer@equinoxOLI.org +1 (877) Open-ILS (673-6457) https://equinoxOLI.org/
On Jun 11, 2024, at 1:40 PM, Scott Owen <sowen@almaschools.net> wrote:
Hi All,
I just upgraded to Koha Koha version: 22.05.21.000 and imported sql data from a older system ( 20.05.15.001 )
The catalog looks fine, as well as my "Board" "Staff" and "Teacher" categories.
However, whenever I select my "Student" category, and try a search in the left leaving the "search" blank and just searching for the Student Category , I get a "Something went wrong loading the table 500 internal Server error"
Trying to browse by last names gives the same "500 internal Server error" error.
If I try typing in a last name, it seems to work, and will bring up a list of names.
I already tried exporting a 2nd DB dump and importing it clean...same issue.
Any idea where to start ?? It seems like the data is good, it seems like it's all there. but it's not being sorted / indexed correctly ? I tried looking in log files, but I really didn't see much .
-S _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Scott, When I've seen this, it's usually a problem with one or more patron files in the category, and not with the category itself. Our upgrades to 22.05 are a bit far in my memory, but I remember at one point there was a problem with dates in the patron file being 0000-00-00. This resulted in error 500 during a patron search. You can try select date_renewed,dateofbirth,dateenrolled,dateexpiry,lastseen,updated_on,debarred from borrowers where date_renewed = '0000-00-00' or dateexpiry = '0000-00-00' or dateenrolled = '0000-00-00' or dateofbirth = '0000-00-00' or lastseen = '0000-00-00' or updated_on = '0000-00-00' or debarred = '0000-00-00'; Regards, Caroline On 2024-06-11 13:40, Scott Owen wrote:
Hi All,
I just upgraded to Koha Koha version: 22.05.21.000 and imported sql data from a older system ( 20.05.15.001 )
The catalog looks fine, as well as my "Board" "Staff" and "Teacher" categories.
However, whenever I select my "Student" category, and try a search in the left leaving the "search" blank and just searching for the Student Category , I get a "Something went wrong loading the table 500 internal Server error"
Trying to browse by last names gives the same "500 internal Server error" error.
If I try typing in a last name, it seems to work, and will bring up a list of names.
I already tried exporting a 2nd DB dump and importing it clean...same issue.
Any idea where to start ?? It seems like the data is good, it seems like it's all there. but it's not being sorted / indexed correctly ? I tried looking in log files, but I really didn't see much .
-S _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Caroline Cyr-La-Rose, M.L.I.S. (she/her) Librarian | Product Manager 1-833-INLIBRO (465-4276), ext. 221 caroline.cyr-la-rose@inlibro.com https://www.inLibro.com
participants (3)
-
Caroline Cyr La Rose -
Jason Boyer -
Scott Owen