I am facing an issue after updating Nextcloud AIO containers.
When I try to create a Nextcloud Talks meeting room, I get the message “Error while creating the conversation”.
When I hit the /ocs/v2.php/apps/spreed/api/v4/room endpoint, I get this error response:
<?xml version="1.0"?>
<ocs>
<meta>
<status>failure</status>
<statuscode>996</statuscode>
<message>Internal Server Error
</message>
</meta>
<data/>
</ocs>
I was able to track the error to this log message:
[no app in context] Error: An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist
LINE 1: ...s", "a"."last_attendee_activity", "a"."archived", "a"."impor...
^
GET /ocs/v2.php/apps/spreed/api/v4/room?modifiedSince=0&includeStatus=1&includeLastMessage=1
from 191.205.55.36 by admin at Jun 11, 2025, 10:08:00 AM
{"reqId":"eo4gDKleKaZCf6vdy5z6","level":3,"time":"2025-06-11T12:56:00+00:00","remoteAddr":"191.205.55.36","user":"admin","app":"no app in context","method":"GET","url":"/ocs/v2.php/apps/spreed/api/v4/room?modifiedSince=0&includeStatus=1&includeLastMessage=1","message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36","version":"31.0.4.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^","Code":7,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":53,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException"},"","SELECT `r`.`type`, `r`.`read_only`, `r`.`lobby_state`, `r`.`sip_enabled`, `r`.`assigned_hpb`, `r`.`token`, `r`.`name`, `r`.`description`, `r`.`password`, `r`.`avatar`, `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`.`message_expiration`, `r`.`remote_server`, `r`.`remote_token`, `r`.`breakout_room_mode`, `r`.`breakout_room_status`, `r`.`call_recording`, `r`.`recording_consent`, `r`.`has_federation`, `r`.`mention_permissions`, `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`.`invited_cloud_id`, `a`.`phone_number`, `a`.`call_id`, `a`.`state`, `a`.`unread_messages`, `a`.`last_attendee_activity`, `a`.`archived`, `a`.`important`, `a`.`sensitive`, `a`.`id` AS `a_id`, `c`.`id` AS `comment_id`, `c`.`parent_id` AS `comment_parent_id`, `c`.`topmost_parent_id` AS `comment_topmost_parent_id`, `c`.`children_count` AS `comment_children_count`, `c`.`message` AS `comment_message`, `c`.`verb` AS `comment_verb`, `c`.`actor_type` AS `comment_actor_type`, `c`.`actor_id` AS `comment_actor_id`, `c`.`object_type` AS `comment_object_type`, `c`.`object_id` AS `comment_object_id`, `c`.`creation_timestamp` AS `comment_creation_timestamp`, `c`.`latest_child_timestamp` AS `comment_latest_child_timestamp`, `c`.`reactions` AS `comment_reactions`, `c`.`expire_date` AS `comment_expire_date`, `c`.`meta_data` AS `comment_meta_data` FROM `*PREFIX*talk_rooms` `r` LEFT JOIN `*PREFIX*talk_attendees` `a` ON (`a`.`actor_id` = :dcValue1) AND (`a`.`actor_type` = :dcValue2) AND (`a`.`room_id` = `r`.`id`) LEFT JOIN `*PREFIX*comments` `c` ON (`r`.`last_message` = `c`.`id`) AND (`r`.`remote_server` IS NULL) WHERE `a`.`id` IS NOT NULL"]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `r`.`type`, `r`.`read_only`, `r`.`lobby_state`, `r`.`sip_enabled`, `r`.`assigned_hpb`, `r`.`token`, `r`.`name`, `r`.`description`, `r`.`password`, `r`.`avatar`, `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`.`message_expiration`, `r`.`remote_server`, `r`.`remote_token`, `r`.`breakout_room_mode`, `r`.`breakout_room_status`, `r`.`call_recording`, `r`.`recording_consent`, `r`.`has_federation`, `r`.`mention_permissions`, `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`.`invited_cloud_id`, `a`.`phone_number`, `a`.`call_id`, `a`.`state`, `a`.`unread_messages`, `a`.`last_attendee_activity`, `a`.`archived`, `a`.`important`, `a`.`sensitive`, `a`.`id` AS `a_id`, `c`.`id` AS `comment_id`, `c`.`parent_id` AS `comment_parent_id`, `c`.`topmost_parent_id` AS `comment_topmost_parent_id`, `c`.`children_count` AS `comment_children_count`, `c`.`message` AS `comment_message`, `c`.`verb` AS `comment_verb`, `c`.`actor_type` AS `comment_actor_type`, `c`.`actor_id` AS `comment_actor_id`, `c`.`object_type` AS `comment_object_type`, `c`.`object_id` AS `comment_object_id`, `c`.`creation_timestamp` AS `comment_creation_timestamp`, `c`.`latest_child_timestamp` AS `comment_latest_child_timestamp`, `c`.`reactions` AS `comment_reactions`, `c`.`expire_date` AS `comment_expire_date`, `c`.`meta_data` AS `comment_meta_data` FROM `*PREFIX*talk_rooms` `r` LEFT JOIN `*PREFIX*talk_attendees` `a` ON (`a`.`actor_id` = :dcValue1) AND (`a`.`actor_type` = :dcValue2) AND (`a`.`room_id` = `r`.`id`) LEFT JOIN `*PREFIX*comments` `c` ON (`r`.`last_message` = `c`.`id`) AND (`r`.`remote_server` IS NULL) WHERE `a`.`id` IS NOT NULL",{"dcValue1":"admin","dcValue2":"users"},{"dcValue1":2,"dcValue2":2}]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":391,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":352,"function":"getRoomsForActor","class":"OCA\\Talk\\Manager","type":"->","args":["users","admin",[],true]},{"file":"/var/www/html/custom_apps/spreed/lib/Controller/RoomController.php","line":244,"function":"getRoomsForUser","class":"OCA\\Talk\\Manager","type":"->","args":["admin",[],true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"getRooms","class":"OCA\\Talk\\Controller\\RoomController","type":"->","args":[0,true,0,true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Talk\\Controller\\RoomController","getRooms",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"apiVersion":"v4","_route":"ocs.spreed.room.getrooms"}]},{"file":"/var/www/html/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/spreed/api/v4/room"]},{"file":"/var/www/html/ocs/v2.php","line":7,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":56,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\InvalidFieldNameException","Message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},{"__class__":"Doctrine\\DBAL\\Query"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1111,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"SELECT \"r\".\"type\", \"r\".\"read_only\", \"r\".\"lobby_state\", \"r\".\"sip_enabled\", \"r\".\"assigned_hpb\", \"r\".\"token\", \"r\".\"name\", \"r\".\"description\", \"r\".\"password\", \"r\".\"avatar\", \"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\".\"message_expiration\", \"r\".\"remote_server\", \"r\".\"remote_token\", \"r\".\"breakout_room_mode\", \"r\".\"breakout_room_status\", \"r\".\"call_recording\", \"r\".\"recording_consent\", \"r\".\"has_federation\", \"r\".\"mention_permissions\", \"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\".\"invited_cloud_id\", \"a\".\"phone_number\", \"a\".\"call_id\", \"a\".\"state\", \"a\".\"unread_messages\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"important\", \"a\".\"sensitive\", \"a\".\"id\" AS \"a_id\", \"c\".\"id\" AS \"comment_id\", \"c\".\"parent_id\" AS \"comment_parent_id\", \"c\".\"topmost_parent_id\" AS \"comment_topmost_parent_id\", \"c\".\"children_count\" AS \"comment_children_count\", \"c\".\"message\" AS \"comment_message\", \"c\".\"verb\" AS \"comment_verb\", \"c\".\"actor_type\" AS \"comment_actor_type\", \"c\".\"actor_id\" AS \"comment_actor_id\", \"c\".\"object_type\" AS \"comment_object_type\", \"c\".\"object_id\" AS \"comment_object_id\", \"c\".\"creation_timestamp\" AS \"comment_creation_timestamp\", \"c\".\"latest_child_timestamp\" AS \"comment_latest_child_timestamp\", \"c\".\"reactions\" AS \"comment_reactions\", \"c\".\"expire_date\" AS \"comment_expire_date\", \"c\".\"meta_data\" AS \"comment_meta_data\" 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\") LEFT JOIN \"oc_comments\" \"c\" ON (\"r\".\"last_message\" = \"c\".\"id\") AND (\"r\".\"remote_server\" IS NULL) WHERE \"a\".\"id\" IS NOT NULL",["admin","users"],[2,2]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"r\".\"type\", \"r\".\"read_only\", \"r\".\"lobby_state\", \"r\".\"sip_enabled\", \"r\".\"assigned_hpb\", \"r\".\"token\", \"r\".\"name\", \"r\".\"description\", \"r\".\"password\", \"r\".\"avatar\", \"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\".\"message_expiration\", \"r\".\"remote_server\", \"r\".\"remote_token\", \"r\".\"breakout_room_mode\", \"r\".\"breakout_room_status\", \"r\".\"call_recording\", \"r\".\"recording_consent\", \"r\".\"has_federation\", \"r\".\"mention_permissions\", \"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\".\"invited_cloud_id\", \"a\".\"phone_number\", \"a\".\"call_id\", \"a\".\"state\", \"a\".\"unread_messages\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"important\", \"a\".\"sensitive\", \"a\".\"id\" AS \"a_id\", \"c\".\"id\" AS \"comment_id\", \"c\".\"parent_id\" AS \"comment_parent_id\", \"c\".\"topmost_parent_id\" AS \"comment_topmost_parent_id\", \"c\".\"children_count\" AS \"comment_children_count\", \"c\".\"message\" AS \"comment_message\", \"c\".\"verb\" AS \"comment_verb\", \"c\".\"actor_type\" AS \"comment_actor_type\", \"c\".\"actor_id\" AS \"comment_actor_id\", \"c\".\"object_type\" AS \"comment_object_type\", \"c\".\"object_id\" AS \"comment_object_id\", \"c\".\"creation_timestamp\" AS \"comment_creation_timestamp\", \"c\".\"latest_child_timestamp\" AS \"comment_latest_child_timestamp\", \"c\".\"reactions\" AS \"comment_reactions\", \"c\".\"expire_date\" AS \"comment_expire_date\", \"c\".\"meta_data\" AS \"comment_meta_data\" 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\") LEFT JOIN \"oc_comments\" \"c\" ON (\"r\".\"last_message\" = \"c\".\"id\") AND (\"r\".\"remote_server\" IS NULL) WHERE \"a\".\"id\" IS NOT NULL",["admin","users"],[2,2],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"r\".\"type\", \"r\".\"read_only\", \"r\".\"lobby_state\", \"r\".\"sip_enabled\", \"r\".\"assigned_hpb\", \"r\".\"token\", \"r\".\"name\", \"r\".\"description\", \"r\".\"password\", \"r\".\"avatar\", \"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\".\"message_expiration\", \"r\".\"remote_server\", \"r\".\"remote_token\", \"r\".\"breakout_room_mode\", \"r\".\"breakout_room_status\", \"r\".\"call_recording\", \"r\".\"recording_consent\", \"r\".\"has_federation\", \"r\".\"mention_permissions\", \"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\".\"invited_cloud_id\", \"a\".\"phone_number\", \"a\".\"call_id\", \"a\".\"state\", \"a\".\"unread_messages\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"important\", \"a\".\"sensitive\", \"a\".\"id\" AS \"a_id\", \"c\".\"id\" AS \"comment_id\", \"c\".\"parent_id\" AS \"comment_parent_id\", \"c\".\"topmost_parent_id\" AS \"comment_topmost_parent_id\", \"c\".\"children_count\" AS \"comment_children_count\", \"c\".\"message\" AS \"comment_message\", \"c\".\"verb\" AS \"comment_verb\", \"c\".\"actor_type\" AS \"comment_actor_type\", \"c\".\"actor_id\" AS \"comment_actor_id\", \"c\".\"object_type\" AS \"comment_object_type\", \"c\".\"object_id\" AS \"comment_object_id\", \"c\".\"creation_timestamp\" AS \"comment_creation_timestamp\", \"c\".\"latest_child_timestamp\" AS \"comment_latest_child_timestamp\", \"c\".\"reactions\" AS \"comment_reactions\", \"c\".\"expire_date\" AS \"comment_expire_date\", \"c\".\"meta_data\" AS \"comment_meta_data\" FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_attendees\" \"a\" ON (\"a\".\"actor_id\" = :dcValue1) AND (\"a\".\"actor_type\" = :dcValue2) AND (\"a\".\"room_id\" = \"r\".\"id\") LEFT JOIN \"oc_comments\" \"c\" ON (\"r\".\"last_message\" = \"c\".\"id\") AND (\"r\".\"remote_server\" IS NULL) WHERE \"a\".\"id\" IS NOT NULL",{"dcValue1":"admin","dcValue2":"users"},{"dcValue1":2,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `r`.`type`, `r`.`read_only`, `r`.`lobby_state`, `r`.`sip_enabled`, `r`.`assigned_hpb`, `r`.`token`, `r`.`name`, `r`.`description`, `r`.`password`, `r`.`avatar`, `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`.`message_expiration`, `r`.`remote_server`, `r`.`remote_token`, `r`.`breakout_room_mode`, `r`.`breakout_room_status`, `r`.`call_recording`, `r`.`recording_consent`, `r`.`has_federation`, `r`.`mention_permissions`, `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`.`invited_cloud_id`, `a`.`phone_number`, `a`.`call_id`, `a`.`state`, `a`.`unread_messages`, `a`.`last_attendee_activity`, `a`.`archived`, `a`.`important`, `a`.`sensitive`, `a`.`id` AS `a_id`, `c`.`id` AS `comment_id`, `c`.`parent_id` AS `comment_parent_id`, `c`.`topmost_parent_id` AS `comment_topmost_parent_id`, `c`.`children_count` AS `comment_children_count`, `c`.`message` AS `comment_message`, `c`.`verb` AS `comment_verb`, `c`.`actor_type` AS `comment_actor_type`, `c`.`actor_id` AS `comment_actor_id`, `c`.`object_type` AS `comment_object_type`, `c`.`object_id` AS `comment_object_id`, `c`.`creation_timestamp` AS `comment_creation_timestamp`, `c`.`latest_child_timestamp` AS `comment_latest_child_timestamp`, `c`.`reactions` AS `comment_reactions`, `c`.`expire_date` AS `comment_expire_date`, `c`.`meta_data` AS `comment_meta_data` FROM `*PREFIX*talk_rooms` `r` LEFT JOIN `*PREFIX*talk_attendees` `a` ON (`a`.`actor_id` = :dcValue1) AND (`a`.`actor_type` = :dcValue2) AND (`a`.`room_id` = `r`.`id`) LEFT JOIN `*PREFIX*comments` `c` ON (`r`.`last_message` = `c`.`id`) AND (`r`.`remote_server` IS NULL) WHERE `a`.`id` IS NOT NULL",{"dcValue1":"admin","dcValue2":"users"},{"dcValue1":2,"dcValue2":2}]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":391,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":352,"function":"getRoomsForActor","class":"OCA\\Talk\\Manager","type":"->","args":["users","admin",[],true]},{"file":"/var/www/html/custom_apps/spreed/lib/Controller/RoomController.php","line":244,"function":"getRoomsForUser","class":"OCA\\Talk\\Manager","type":"->","args":["admin",[],true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"getRooms","class":"OCA\\Talk\\Controller\\RoomController","type":"->","args":[0,true,0,true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Talk\\Controller\\RoomController","getRooms",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"apiVersion":"v4","_route":"ocs.spreed.room.getrooms"}]},{"file":"/var/www/html/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/spreed/api/v4/room"]},{"file":"/var/www/html/ocs/v2.php","line":7,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":68,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"__class__":"PDOException","errorInfo":["42703",7,"ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^"]}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"r\".\"type\", \"r\".\"read_only\", \"r\".\"lobby_state\", \"r\".\"sip_enabled\", \"r\".\"assigned_hpb\", \"r\".\"token\", \"r\".\"name\", \"r\".\"description\", \"r\".\"password\", \"r\".\"avatar\", \"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\".\"message_expiration\", \"r\".\"remote_server\", \"r\".\"remote_token\", \"r\".\"breakout_room_mode\", \"r\".\"breakout_room_status\", \"r\".\"call_recording\", \"r\".\"recording_consent\", \"r\".\"has_federation\", \"r\".\"mention_permissions\", \"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\".\"invited_cloud_id\", \"a\".\"phone_number\", \"a\".\"call_id\", \"a\".\"state\", \"a\".\"unread_messages\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"important\", \"a\".\"sensitive\", \"a\".\"id\" AS \"a_id\", \"c\".\"id\" AS \"comment_id\", \"c\".\"parent_id\" AS \"comment_parent_id\", \"c\".\"topmost_parent_id\" AS \"comment_topmost_parent_id\", \"c\".\"children_count\" AS \"comment_children_count\", \"c\".\"message\" AS \"comment_message\", \"c\".\"verb\" AS \"comment_verb\", \"c\".\"actor_type\" AS \"comment_actor_type\", \"c\".\"actor_id\" AS \"comment_actor_id\", \"c\".\"object_type\" AS \"comment_object_type\", \"c\".\"object_id\" AS \"comment_object_id\", \"c\".\"creation_timestamp\" AS \"comment_creation_timestamp\", \"c\".\"latest_child_timestamp\" AS \"comment_latest_child_timestamp\", \"c\".\"reactions\" AS \"comment_reactions\", \"c\".\"expire_date\" AS \"comment_expire_date\", \"c\".\"meta_data\" AS \"comment_meta_data\" 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\") LEFT JOIN \"oc_comments\" \"c\" ON (\"r\".\"last_message\" = \"c\".\"id\") AND (\"r\".\"remote_server\" IS NULL) WHERE \"a\".\"id\" IS NOT NULL",["admin","users"],[2,2],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"r\".\"type\", \"r\".\"read_only\", \"r\".\"lobby_state\", \"r\".\"sip_enabled\", \"r\".\"assigned_hpb\", \"r\".\"token\", \"r\".\"name\", \"r\".\"description\", \"r\".\"password\", \"r\".\"avatar\", \"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\".\"message_expiration\", \"r\".\"remote_server\", \"r\".\"remote_token\", \"r\".\"breakout_room_mode\", \"r\".\"breakout_room_status\", \"r\".\"call_recording\", \"r\".\"recording_consent\", \"r\".\"has_federation\", \"r\".\"mention_permissions\", \"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\".\"invited_cloud_id\", \"a\".\"phone_number\", \"a\".\"call_id\", \"a\".\"state\", \"a\".\"unread_messages\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"important\", \"a\".\"sensitive\", \"a\".\"id\" AS \"a_id\", \"c\".\"id\" AS \"comment_id\", \"c\".\"parent_id\" AS \"comment_parent_id\", \"c\".\"topmost_parent_id\" AS \"comment_topmost_parent_id\", \"c\".\"children_count\" AS \"comment_children_count\", \"c\".\"message\" AS \"comment_message\", \"c\".\"verb\" AS \"comment_verb\", \"c\".\"actor_type\" AS \"comment_actor_type\", \"c\".\"actor_id\" AS \"comment_actor_id\", \"c\".\"object_type\" AS \"comment_object_type\", \"c\".\"object_id\" AS \"comment_object_id\", \"c\".\"creation_timestamp\" AS \"comment_creation_timestamp\", \"c\".\"latest_child_timestamp\" AS \"comment_latest_child_timestamp\", \"c\".\"reactions\" AS \"comment_reactions\", \"c\".\"expire_date\" AS \"comment_expire_date\", \"c\".\"meta_data\" AS \"comment_meta_data\" FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_attendees\" \"a\" ON (\"a\".\"actor_id\" = :dcValue1) AND (\"a\".\"actor_type\" = :dcValue2) AND (\"a\".\"room_id\" = \"r\".\"id\") LEFT JOIN \"oc_comments\" \"c\" ON (\"r\".\"last_message\" = \"c\".\"id\") AND (\"r\".\"remote_server\" IS NULL) WHERE \"a\".\"id\" IS NOT NULL",{"dcValue1":"admin","dcValue2":"users"},{"dcValue1":2,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `r`.`type`, `r`.`read_only`, `r`.`lobby_state`, `r`.`sip_enabled`, `r`.`assigned_hpb`, `r`.`token`, `r`.`name`, `r`.`description`, `r`.`password`, `r`.`avatar`, `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`.`message_expiration`, `r`.`remote_server`, `r`.`remote_token`, `r`.`breakout_room_mode`, `r`.`breakout_room_status`, `r`.`call_recording`, `r`.`recording_consent`, `r`.`has_federation`, `r`.`mention_permissions`, `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`.`invited_cloud_id`, `a`.`phone_number`, `a`.`call_id`, `a`.`state`, `a`.`unread_messages`, `a`.`last_attendee_activity`, `a`.`archived`, `a`.`important`, `a`.`sensitive`, `a`.`id` AS `a_id`, `c`.`id` AS `comment_id`, `c`.`parent_id` AS `comment_parent_id`, `c`.`topmost_parent_id` AS `comment_topmost_parent_id`, `c`.`children_count` AS `comment_children_count`, `c`.`message` AS `comment_message`, `c`.`verb` AS `comment_verb`, `c`.`actor_type` AS `comment_actor_type`, `c`.`actor_id` AS `comment_actor_id`, `c`.`object_type` AS `comment_object_type`, `c`.`object_id` AS `comment_object_id`, `c`.`creation_timestamp` AS `comment_creation_timestamp`, `c`.`latest_child_timestamp` AS `comment_latest_child_timestamp`, `c`.`reactions` AS `comment_reactions`, `c`.`expire_date` AS `comment_expire_date`, `c`.`meta_data` AS `comment_meta_data` FROM `*PREFIX*talk_rooms` `r` LEFT JOIN `*PREFIX*talk_attendees` `a` ON (`a`.`actor_id` = :dcValue1) AND (`a`.`actor_type` = :dcValue2) AND (`a`.`room_id` = `r`.`id`) LEFT JOIN `*PREFIX*comments` `c` ON (`r`.`last_message` = `c`.`id`) AND (`r`.`remote_server` IS NULL) WHERE `a`.`id` IS NOT NULL",{"dcValue1":"admin","dcValue2":"users"},{"dcValue1":2,"dcValue2":2}]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":391,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":352,"function":"getRoomsForActor","class":"OCA\\Talk\\Manager","type":"->","args":["users","admin",[],true]},{"file":"/var/www/html/custom_apps/spreed/lib/Controller/RoomController.php","line":244,"function":"getRoomsForUser","class":"OCA\\Talk\\Manager","type":"->","args":["admin",[],true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"getRooms","class":"OCA\\Talk\\Controller\\RoomController","type":"->","args":[0,true,0,true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Talk\\Controller\\RoomController","getRooms",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"apiVersion":"v4","_route":"ocs.spreed.room.getrooms"}]},{"file":"/var/www/html/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/spreed/api/v4/room"]},{"file":"/var/www/html/ocs/v2.php","line":7,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^","Code":"42703","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT \"r\".\"type\", \"r\".\"read_only\", \"r\".\"lobby_state\", \"r\".\"sip_enabled\", \"r\".\"assigned_hpb\", \"r\".\"token\", \"r\".\"name\", \"r\".\"description\", \"r\".\"password\", \"r\".\"avatar\", \"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\".\"message_expiration\", \"r\".\"remote_server\", \"r\".\"remote_token\", \"r\".\"breakout_room_mode\", \"r\".\"breakout_room_status\", \"r\".\"call_recording\", \"r\".\"recording_consent\", \"r\".\"has_federation\", \"r\".\"mention_permissions\", \"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\".\"invited_cloud_id\", \"a\".\"phone_number\", \"a\".\"call_id\", \"a\".\"state\", \"a\".\"unread_messages\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"important\", \"a\".\"sensitive\", \"a\".\"id\" AS \"a_id\", \"c\".\"id\" AS \"comment_id\", \"c\".\"parent_id\" AS \"comment_parent_id\", \"c\".\"topmost_parent_id\" AS \"comment_topmost_parent_id\", \"c\".\"children_count\" AS \"comment_children_count\", \"c\".\"message\" AS \"comment_message\", \"c\".\"verb\" AS \"comment_verb\", \"c\".\"actor_type\" AS \"comment_actor_type\", \"c\".\"actor_id\" AS \"comment_actor_id\", \"c\".\"object_type\" AS \"comment_object_type\", \"c\".\"object_id\" AS \"comment_object_id\", \"c\".\"creation_timestamp\" AS \"comment_creation_timestamp\", \"c\".\"latest_child_timestamp\" AS \"comment_latest_child_timestamp\", \"c\".\"reactions\" AS \"comment_reactions\", \"c\".\"expire_date\" AS \"comment_expire_date\", \"c\".\"meta_data\" AS \"comment_meta_data\" 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\") LEFT JOIN \"oc_comments\" \"c\" ON (\"r\".\"last_message\" = \"c\".\"id\") AND (\"r\".\"remote_server\" IS NULL) WHERE \"a\".\"id\" IS NOT NULL",["admin","users"],[2,2],null]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT \"r\".\"type\", \"r\".\"read_only\", \"r\".\"lobby_state\", \"r\".\"sip_enabled\", \"r\".\"assigned_hpb\", \"r\".\"token\", \"r\".\"name\", \"r\".\"description\", \"r\".\"password\", \"r\".\"avatar\", \"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\".\"message_expiration\", \"r\".\"remote_server\", \"r\".\"remote_token\", \"r\".\"breakout_room_mode\", \"r\".\"breakout_room_status\", \"r\".\"call_recording\", \"r\".\"recording_consent\", \"r\".\"has_federation\", \"r\".\"mention_permissions\", \"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\".\"invited_cloud_id\", \"a\".\"phone_number\", \"a\".\"call_id\", \"a\".\"state\", \"a\".\"unread_messages\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"important\", \"a\".\"sensitive\", \"a\".\"id\" AS \"a_id\", \"c\".\"id\" AS \"comment_id\", \"c\".\"parent_id\" AS \"comment_parent_id\", \"c\".\"topmost_parent_id\" AS \"comment_topmost_parent_id\", \"c\".\"children_count\" AS \"comment_children_count\", \"c\".\"message\" AS \"comment_message\", \"c\".\"verb\" AS \"comment_verb\", \"c\".\"actor_type\" AS \"comment_actor_type\", \"c\".\"actor_id\" AS \"comment_actor_id\", \"c\".\"object_type\" AS \"comment_object_type\", \"c\".\"object_id\" AS \"comment_object_id\", \"c\".\"creation_timestamp\" AS \"comment_creation_timestamp\", \"c\".\"latest_child_timestamp\" AS \"comment_latest_child_timestamp\", \"c\".\"reactions\" AS \"comment_reactions\", \"c\".\"expire_date\" AS \"comment_expire_date\", \"c\".\"meta_data\" AS \"comment_meta_data\" FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_attendees\" \"a\" ON (\"a\".\"actor_id\" = :dcValue1) AND (\"a\".\"actor_type\" = :dcValue2) AND (\"a\".\"room_id\" = \"r\".\"id\") LEFT JOIN \"oc_comments\" \"c\" ON (\"r\".\"last_message\" = \"c\".\"id\") AND (\"r\".\"remote_server\" IS NULL) WHERE \"a\".\"id\" IS NOT NULL",{"dcValue1":"admin","dcValue2":"users"},{"dcValue1":2,"dcValue2":2}]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT `r`.`type`, `r`.`read_only`, `r`.`lobby_state`, `r`.`sip_enabled`, `r`.`assigned_hpb`, `r`.`token`, `r`.`name`, `r`.`description`, `r`.`password`, `r`.`avatar`, `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`.`message_expiration`, `r`.`remote_server`, `r`.`remote_token`, `r`.`breakout_room_mode`, `r`.`breakout_room_status`, `r`.`call_recording`, `r`.`recording_consent`, `r`.`has_federation`, `r`.`mention_permissions`, `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`.`invited_cloud_id`, `a`.`phone_number`, `a`.`call_id`, `a`.`state`, `a`.`unread_messages`, `a`.`last_attendee_activity`, `a`.`archived`, `a`.`important`, `a`.`sensitive`, `a`.`id` AS `a_id`, `c`.`id` AS `comment_id`, `c`.`parent_id` AS `comment_parent_id`, `c`.`topmost_parent_id` AS `comment_topmost_parent_id`, `c`.`children_count` AS `comment_children_count`, `c`.`message` AS `comment_message`, `c`.`verb` AS `comment_verb`, `c`.`actor_type` AS `comment_actor_type`, `c`.`actor_id` AS `comment_actor_id`, `c`.`object_type` AS `comment_object_type`, `c`.`object_id` AS `comment_object_id`, `c`.`creation_timestamp` AS `comment_creation_timestamp`, `c`.`latest_child_timestamp` AS `comment_latest_child_timestamp`, `c`.`reactions` AS `comment_reactions`, `c`.`expire_date` AS `comment_expire_date`, `c`.`meta_data` AS `comment_meta_data` FROM `*PREFIX*talk_rooms` `r` LEFT JOIN `*PREFIX*talk_attendees` `a` ON (`a`.`actor_id` = :dcValue1) AND (`a`.`actor_type` = :dcValue2) AND (`a`.`room_id` = `r`.`id`) LEFT JOIN `*PREFIX*comments` `c` ON (`r`.`last_message` = `c`.`id`) AND (`r`.`remote_server` IS NULL) WHERE `a`.`id` IS NOT NULL",{"dcValue1":"admin","dcValue2":"users"},{"dcValue1":2,"dcValue2":2}]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":391,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/spreed/lib/Manager.php","line":352,"function":"getRoomsForActor","class":"OCA\\Talk\\Manager","type":"->","args":["users","admin",[],true]},{"file":"/var/www/html/custom_apps/spreed/lib/Controller/RoomController.php","line":244,"function":"getRoomsForUser","class":"OCA\\Talk\\Manager","type":"->","args":["admin",[],true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"getRooms","class":"OCA\\Talk\\Controller\\RoomController","type":"->","args":[0,true,0,true]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Talk\\Controller\\RoomController"},"getRooms"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Talk\\Controller\\RoomController","getRooms",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"apiVersion":"v4","_route":"ocs.spreed.room.getrooms"}]},{"file":"/var/www/html/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/spreed/api/v4/room"]},{"file":"/var/www/html/ocs/v2.php","line":7,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^","exception":{"query":"SELECT `r`.`type`, `r`.`read_only`, `r`.`lobby_state`, `r`.`sip_enabled`, `r`.`assigned_hpb`, `r`.`token`, `r`.`name`, `r`.`description`, `r`.`password`, `r`.`avatar`, `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`.`message_expiration`, `r`.`remote_server`, `r`.`remote_token`, `r`.`breakout_room_mode`, `r`.`breakout_room_status`, `r`.`call_recording`, `r`.`recording_consent`, `r`.`has_federation`, `r`.`mention_permissions`, `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`.`invited_cloud_id`, `a`.`phone_number`, `a`.`call_id`, `a`.`state`, `a`.`unread_messages`, `a`.`last_attendee_activity`, `a`.`archived`, `a`.`important`, `a`.`sensitive`, `a`.`id` AS `a_id`, `c`.`id` AS `comment_id`, `c`.`parent_id` AS `comment_parent_id`, `c`.`topmost_parent_id` AS `comment_topmost_parent_id`, `c`.`children_count` AS `comment_children_count`, `c`.`message` AS `comment_message`, `c`.`verb` AS `comment_verb`, `c`.`actor_type` AS `comment_actor_type`, `c`.`actor_id` AS `comment_actor_id`, `c`.`object_type` AS `comment_object_type`, `c`.`object_id` AS `comment_object_id`, `c`.`creation_timestamp` AS `comment_creation_timestamp`, `c`.`latest_child_timestamp` AS `comment_latest_child_timestamp`, `c`.`reactions` AS `comment_reactions`, `c`.`expire_date` AS `comment_expire_date`, `c`.`meta_data` AS `comment_meta_data` FROM `*PREFIX*talk_rooms` `r` LEFT JOIN `*PREFIX*talk_attendees` `a` ON (`a`.`actor_id` = :dcValue1) AND (`a`.`actor_type` = :dcValue2) AND (`a`.`room_id` = `r`.`id`) LEFT JOIN `*PREFIX*comments` `c` ON (`r`.`last_message` = `c`.`id`) AND (`r`.`remote_server` IS NULL) WHERE `a`.`id` IS NOT NULL"},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.important does not exist\nLINE 1: ...s\", \"a\".\"last_attendee_activity\", \"a\".\"archived\", \"a\".\"impor...\n ^"},"id":"68497d01a7014"}
Other information
Host OS
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 24.04.2 LTS
Release: 24.04
Codename: noble
Output of sudo docker info
docker info
Client: Docker Engine - Community
Version: 28.1.1
Context: default
Debug Mode: false
Plugins:
buildx: Docker Buildx (Docker Inc.)
Version: v0.22.0
Path: /usr/libexec/docker/cli-plugins/docker-buildx
compose: Docker Compose (Docker Inc.)
Version: v2.34.0
Path: /usr/libexec/docker/cli-plugins/docker-compose
Server:
Containers: 14
Running: 12
Paused: 0
Stopped: 2
Images: 26
Server Version: 28.1.1
Storage Driver: overlay2
Backing Filesystem: extfs
Supports d_type: true
Using metacopy: false
Native Overlay Diff: true
userxattr: false
Logging Driver: json-file
Cgroup Driver: systemd
Cgroup Version: 2
Plugins:
Volume: local
Network: bridge host ipvlan macvlan null overlay
Log: awslogs fluentd gcplogs gelf journald json-file local splunk syslog
Swarm: inactive
Runtimes: io.containerd.runc.v2 runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 05044ec0a9a75232cad458027ca83437aae3f4da
runc version: v1.2.5-0-g59923ef
init version: de40ad0
Security Options:
apparmor
seccomp
Profile: builtin
cgroupns
Kernel Version: 6.8.0-60-generic
Operating System: Ubuntu 24.04.2 LTS
OSType: linux
Architecture: x86_64
CPUs: 4
Total Memory: 7.57GiB
Name: onlyoffice
ID: 289363f4-f0f1-4b6a-a982-33314124a89f
Docker Root Dir: /var/lib/docker
Debug Mode: false
Experimental: false
Insecure Registries:
::1/128
127.0.0.0/8
Live Restore Enabled: false
Docker run command or docker-compose file that you used
Other valuable info
It seems to me that after updating the containers from the master AIO interface, the database went out of sync. It seems to be missing the important column in the talk_attendees table, but I can’t figure out much more beyond that.
On top of that, Unread mentions seem to be loading forever:
Not sure if that is the default behavior when there are no mentions.
.