After an update, I was unable to connect to my nextcloud. After investigating for 2 days I found out that this is the Talk app which is broken. When I desactivate it, I can connect again.
Nextcloud version : 20.0.8.1
Talk version : 10.0.6
Distribution : nextcloudpi
SQL database server : mariadb
Hereās the logs (from nextcloud>settings>admin>logging ) :
[index] Error: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL' with params ["ncp"]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_talk_participants' doesn't exist at <<closure>>
0. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... t", Doctrine\DBAL\Dr ... ]})
1. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 149
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... t")
2. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 914
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "SELECT `r`.*, ` ... L", {1: "ncp"})
3. /var/www/nextcloud/lib/private/DB/Connection.php line 202
Doctrine\DBAL\Connection->executeQuery("SELECT `r`.*, ` ... L", ["ncp"], [2], null)
4. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 206
OC\DB\Connection->executeQuery("SELECT `r`.*, ` ... L", {dcValue1: "ncp"}, {dcValue1: 2})
5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 217
Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/nextcloud/apps/spreed/lib/Manager.php line 294
OC\DB\QueryBuilder\QueryBuilder->execute()
7. /var/www/nextcloud/apps/spreed/lib/Share/RoomShareProvider.php line 779
OCA\Talk\Manager->getRoomsForParticipant("ncp")
8. /var/www/nextcloud/lib/private/Share20/Manager.php line 1332
OCA\Talk\Share\RoomShareProvider->getSharedWith("ncp", 10, null, -1, 0)
9. /var/www/nextcloud/apps/files_sharing/lib/MountProvider.php line 80
OC\Share20\Manager->getSharedWith("ncp", 10, null, -1)
10. /var/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php line 119
OCA\Files_Sharing\MountProvider->getMountsForUser(OC\User\User {}, OC\Files\Storage\StorageFactory {})
11. /var/www/nextcloud/lib/private/Files/Filesystem.php line 452
OC\Files\Config\MountProviderCollection->addMountForUser(OC\User\User {}, OC\Files\Mount\Manager {})
12. /var/www/nextcloud/lib/private/Files/Filesystem.php line 377
OC\Files\Filesystem::initMountPoints("ncp")
13. /var/www/nextcloud/lib/private/legacy/OC_Util.php line 322
OC\Files\Filesystem::init("ncp", "/ncp/files")
14. /var/www/nextcloud/lib/base.php line 1007
OC_Util::setupFS()
15. /var/www/nextcloud/index.php line 37
OC::handleRequest()
GET /apps/theming/image/logo?useSvg=1&v=2
from 139.28.219.84 by ncp at 2021-03-02T16:00:46+00:00
I have no such oc_talk_participants
table. I have (almost) no knowledge of mysql/mariadb.
So far I tried to uninstall/reinstall Talk but I got the same error.
I also tried to manually delete every entry of occ config:app:delete spreed ENTRY
before reinstalling without success.
Of course I checked this and all the github issues linked in this post. But I didnāt find the solution there (I canāt install a new nexctloud instance).
I tried to know how to completely remove the talk app to proceed to a clean install but I dināt find the information.
I hope somebody can help
note : I created a new post about the same issue I was facing because I first went to a bad direction (thinking it was a php-redis issue). Sorry about this but it will be more clear like this.