Hey there
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ââ
Tried to create a room with occ and got the same error:
"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r.assigned_hpb' in 'field list'"
Is somebody with a working instance willing to show the columns of the table? So Iâd be able to create them manually and then check the code why this is happening. Thank you
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.
Done.
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!
Thanks again!
You could try something with the occ migration command, something like
./occ migrations:migrate spreed
There are also different migration commands - try it.
This is the migration file you are missing:
First Iâd try the migration command, if that doesnât help Iâd build a SQL Statement to create the table by myself. It could be that you are missing more tables than only the session table.