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.