I cannot use Talk anymore with NC 21 and Talk 11
Everything seems fine in NC 20 and Talk 10.6
Creating a conversation ends up in “Error creating the conversation” and Internal Server Error, and the search form always gives Error in searching messages and conversations.
The NC log says
“Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘xxxxx.oc_talk_sessions’ doesn’t exist”
“Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘r.description’ in ‘field list’”
the nextcloud thinks that everything is alright with the database. db:add-missing-columns doesn’t change anything either.
www-data@600f62e4a6a5:~/html$ ./occ db:add-missing-indice
Check indices of the share table.
Check indices of the filecache table.
Check indices of the twofactor_providers table.
Check indices of the login_flow_v2 table.
Check indices of the whats_new table.
Check indices of the cards table.
Check indices of the cards_properties table.
Check indices of the calendarobjects_props table.
Check indices of the schedulingobjects table.
Check indices of the oc_properties table.
Okay, I found a solution. I’ve taken a look in the source code of the spreed app in Github and found the function which should create the assigned_hpb column.
I don’t know how to execute the migration manually, because I don’t know very much about PHP, so I’ve manually added the column to my database with the following query:
ALTER TABLE oc_talk_rooms ADD assigned_hpb int NULL DEFAULT(NULL);
Now it is working - hope it will help you guys too. Take care, your database prefix might differ from mine. If you need help with this, feel free to ask.
I’d be happy, if someone could tell me how to execute the migration script of the addon manually or how the process of the migration is happening with the installation of the addon, because I really want to understand why the database change didn’t happen. Other people in this thread are missing whole tables - so it’d help alot.
Thanks for the try! In my case the column IS there, what seems to be missing is the oc_talk_sessions table
I cannot find where the table is created, maybe you could point me in the right directon!