Talk app db table not created

[tkunz]

I just installed nextcloud 21.0.0.18 and when I installed the Talk app, the following error shows up in the log and indicates that oc_talk_sessions table is not there. I checked the db and sure enough, it’s not there. Can I manually create this table, or is there something else I should be doing?

{“reqId”:“YFIW1BdP8u7Wqs7I4SgVKgAAAAY”,“level”:3,“time”:“2021-03-17T14:48:53+00:00”,“remoteAddr”:“184.21.44.174”,“user”:“nxtadmin378”,“app”:“no app in context”,“method”:“GET”,“url”:"/nextcloud/ocs/v2.php/apps/spreed/api/v2/room",“message”:{“Exception”:“Doctrine\DBAL\Exception\TableNotFoundException”,“Message”:“An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nextcloud.oc_talk_sessions’ doesn’t exist”,“Code”:1146,“Trace”:[{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1728,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter”,“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1667,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1040,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/Connection.php",“line”:226,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:210,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:286,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->"},{“file”:"/var/www/nextcloud/apps/spreed/lib/Manager.php",“line”:326,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/var/www/nextcloud/apps/spreed/lib/Controller/RoomController.php",“line”:201,“function”:“getRoomsForUser”,“class”:“OCA\Talk\Manager”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“getRooms”,“class”:“OCA\Talk\Controller\RoomController”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/var/www/nextcloud/ocs/v1.php",“line”:63,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/var/www/nextcloud/ocs/v2.php",“line”:24,“args”:["/var/www/nextcloud/ocs/v1.php"],“function”:“require_once”}],“File”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",“Line”:47,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDO\Exception”,“Message”:“SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nextcloud.oc_talk_sessions’ doesn’t exist”,“Code”:1146,“Trace”:[{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“line”:84,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\Exception”,“type”:"::"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1030,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/Connection.php",“line”:226,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:210,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:286,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->"},{“file”:"/var/www/nextcloud/apps/spreed/lib/Manager.php",“line”:326,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/var/www/nextcloud/apps/spreed/lib/Controller/RoomController.php",“line”:201,“function”:“getRoomsForUser”,“class”:“OCA\Talk\Manager”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“getRooms”,“class”:“OCA\Talk\Controller\RoomController”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/var/www/nextcloud/ocs/v1.php",“line”:63,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/var/www/nextcloud/ocs/v2.php",“line”:24,“args”:["/var/www/nextcloud/ocs/v1.php"],“function”:“require_once”}],“File”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",“Line”:26,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘nextcloud.oc_talk_sessions’ doesn’t exist”,“Code”:“42S02”,“Trace”:[{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“line”:82,“function”:“execute”,“class”:“PDOStatement”,“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",“line”:1030,“function”:“execute”,“class”:“Doctrine\DBAL\Driver\PDO\Statement”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/Connection.php",“line”:226,“function”:“executeQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",“line”:210,“function”:“executeQuery”,“class”:“OC\DB\Connection”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",“line”:286,“function”:“execute”,“class”:“Doctrine\DBAL\Query\QueryBuilder”,“type”:"->"},{“file”:"/var/www/nextcloud/apps/spreed/lib/Manager.php",“line”:326,“function”:“execute”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:"->"},{“file”:"/var/www/nextcloud/apps/spreed/lib/Controller/RoomController.php",“line”:201,“function”:“getRoomsForUser”,“class”:“OCA\Talk\Manager”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:218,“function”:“getRooms”,“class”:“OCA\Talk\Controller\RoomController”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",“line”:127,“function”:“executeController”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/AppFramework/App.php",“line”:157,“function”:“dispatch”,“class”:“OC\AppFramework\Http\Dispatcher”,“type”:"->"},{“file”:"/var/www/nextcloud/lib/private/Route/Router.php",“line”:302,“function”:“main”,“class”:“OC\AppFramework\App”,“type”:"::"},{“file”:"/var/www/nextcloud/ocs/v1.php",“line”:63,“function”:“match”,“class”:“OC\Route\Router”,“type”:"->"},{“file”:"/var/www/nextcloud/ocs/v2.php",“line”:24,“args”:["/var/www/nextcloud/ocs/v1.php"],“function”:“require_once”}],“File”:"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",“Line”:82}},“CustomMessage”:"–"},“userAgent”:“Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0”,“version”:“21.0.0.18”}

[j-ed]

@tkunz

Can I manually create this table, or is there something else I should be doing?

Using the search function of the forum to find an answer is always a good idea
See e.g.

NC 21 and Talk 11

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” “Do…

[davide]

See here for a workaround: NC 21 and Talk 11 not wroking after migration to nc21 [solved]
Worked for me!

[nickvergessen]

If you stiull have this, please post your full log file or at least the lines before this one. This is only the consequence and we are still lacking details for the root cause.