We have Omeka-S installed on a reclaim hosting server - I found now that there is this error which disables access to the items/item sets in our collections.
The omeka-s version is 4.0.1 , php 8.0.28
Don’t know exactly when it happened.
Would appreciate any help!

An exception occurred while executing ‘SELECT AS id_1, t0.type AS type_2, t0.lang AS lang_3, t0.value AS value_4, t0.uri AS uri_5, t0.is_public AS is_public_6, t0.resource_id AS resource_id_7, t0.property_id AS property_id_8, t0.value_resource_id AS value_resource_id_9, t0.value_annotation_id AS value_annotation_id_10 FROM value t0 WHERE t0.resource_id = ? ORDER BY ASC’ with params [14218]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.value_annotation_id’ in ‘field list’

This error indicates that your database doesn’t match the version of Omeka S that’s installed.

The “value_annotation_id” column it’s complaining about was added in Omeka S 3.2, so the structure of the table you’ve got in the database here is older than that at least. If you were successfully using 3.2 or 4.0 at all, then probably someone made some sort of change to your database directly. Perhaps loading or restoring an older version of all or part of the database?