I think that you have to reindex after the corrections (at least thas's what I did) Am 13.03.2023 um 16:52 schrieb Paul:

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.

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.