An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.access_token' in 'field list'"

ℹ️ Support
1

Nextcloud Version: 24.0.5
Running in container
Hardware: Raspi 4, 8GB RAM

When I try to set a share for a user and type something in the corresponding username search field, I get the following error message in the Nextcloud log:

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘a.access_token’ in ‘field list’"

The executed query is:

SELECT r.type, r.read_only, r.lobby_state, r.sip_enabled, r.assigned_hpb, r.token, r.name, r.description, r.password, r.active_guests, r.active_since, r.default_permissions, r.call_permissions, r.call_flag, r.last_activity, r.last_message, r.lobby_timer, r.object_type, r.object_id, r.listable, r.remote_server, r.remote_token, r.id AS r_id, a.room_id, a.actor_type, a.actor_id, a.display_name, a.pin, a.participant_type, a.favorite, a.notification_level, a.notification_calls, a.last_joined_call, a.last_read_message, a.last_mention_message, a.last_mention_direct, a.read_privacy, a.permissions, a.access_token, a.remote_id, a.id AS a_id FROM oc_talk_rooms r LEFT JOIN oc_talk_attendees a ON (a.actor_id = ?) AND (a.actor_type = ?) AND (a.room_id = r.id) WHERE a.id IS NOT NULL

occ db:add-missing-columns and occ maintenance:repair did not help :frowning:

Is it somehow possible to fix the database structure?

2

I managed to solve the issue by deleting the talk app.

However, I do not like this solution. I would have preferred to find a way to repair the database. :frowning:

3

you may try occ db:add-missing-indices