I've seen this error appear when you have a malformed xml meta structure in the 
biblio meta data. If you are adept, or someone in your department is adept with 
sql, find the offending biblionumber and extract the xml, paste it into any 
online free xml validator.  You'll find out real quick if it's the xml or not.

Rudy Hinojosa
________________________________
From: Koha <koha-boun...@lists.katipo.co.nz> on behalf of 
koha-requ...@lists.katipo.co.nz <koha-requ...@lists.katipo.co.nz>
Sent: Thursday, June 13, 2024 5:00 PM
To: koha@lists.katipo.co.nz <koha@lists.katipo.co.nz>
Subject: Koha Digest, Vol 224, Issue 8

Send Koha mailing list submissions to
        koha@lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
        koha-requ...@lists.katipo.co.nz

You can reach the person managing the list at
        koha-ow...@lists.katipo.co.nz

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."


Today's Topics:

   1. Re: 500 internal server error - only in one category
      (Caroline Cyr La Rose)
   2. Foundation vote closing soon (Auld, Andrew)


----------------------------------------------------------------------

Message: 1
Date: Thu, 13 Jun 2024 10:14:41 -0400
From: Caroline Cyr La Rose <caroline.cyr-la-r...@inlibro.com>
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] 500 internal server error - only in one category
Message-ID: <4301ea59-09c6-4816-a9cf-e97377d09...@inlibro.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

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-r...@inlibro.com
https://www.inLibro.com



------------------------------

Message: 2
Date: Thu, 13 Jun 2024 22:06:24 +0100
From: "Auld, Andrew" <andrew.a...@ptfs-europe.com>
To: koha@lists.katipo.co.nz
Subject: [Koha] Foundation vote closing soon
Message-ID:
        <CAFAdoMWyhmubRP8D11zibeSZOiBirknJ-_=fdddgrmerhck...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

Less than 24 hours for you to cast your vote on whether the Koha project
should join an open source foundation and specifically the Open Library
Foundation. Read the proposal and have your say here:
https://chat.koha-community.org/koha-community/pl/d3161rfwe7goxc6xmhyrmoi93c

Voting closes at 17:00 UTC on Friday 14 June.

Andrew Auld
PTFS Europe


------------------------------

Subject: Digest Footer

_______________________________________________
Koha mailing list
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


------------------------------

End of Koha Digest, Vol 224, Issue 8
************************************
_______________________________________________

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to