Hi Paul, do you have anything in OpacHiddenItems by chance?
Try deleting it and see if that fixes your issue. It looks like a wrong SQL query is constructed from the error. OpacHiddenItems listing LOST instead of the database table column name itemlost could be a possible explanation. Hope this helps, Katrin On 13.03.23 16:52, Paul wrote:
I recently reported that we'd started to get internal server errors when looking at ISBD detail and making a hold when in the OPAC. Jonathan Druart asked if I'd run misc/maintenance/ search_for_data_inconsistencies.pl to catch potential problems with our data. There were numerous errors with respect to home branch and/or holding branch which I corrected. We've run search_for_data_inconsistencies.pl again and no problems are reported. We're still getting internal servers errors when looking at ISBD detail and making a hold when in the OPAC. Is there anything else I can check? We've also seen that the plack-error.log has a continuously generated error: DBD::mysql::db selectrow_array failed: Unknown column 'LOST' in 'field list' [for Statement "SELECT LOST from items where itemnumber = ?"] at /usr/share/koha/lib/C4/Items.pm line 1229.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
