[Koha] Internal Server Errors

[Katrin Fischer]

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.
>
>
>
>
>
>
>
>
>
>