data tables missing / Relation »oc_talk_participants« existiert nicht

kiilo commented 3 years ago

Steps to reproduce

upgraded univention nextcloud from 20.0.2 to 20.0.8 spreed app was activated

Expected behaviour

spreed app works - user list and shares are working

Actual behaviour

spreed app doesn't work - empty conversions and user list also shares doesn't work also userlist for admin doesn't load

Talk app

Talk app version: spreed 10.0.6 installed

Custom Signaling server configured: no Custom TURN server configured: yes Custom STUN server configured: yes

Browser

downs't matter her firefox/chrome/vivaldi Operating system: Ubuntu 20 LTS recent

Browser log


**Web server:** Apache/Nginx

**Database:** PostgreSQL

**PHP version:** 7.2/7.3/7.4

**Nextcloud Version:** (see admin page)

<details>

If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your server installation folder

</details>

**Nextcloud configuration:**

<details>

{ "system": { "passwordsalt": "REMOVED SENSITIVE VALUE", "secret": "REMOVED SENSITIVE VALUE", "datadirectory": "REMOVED SENSITIVE VALUE", "overwrite.cli.url": "https:\/\/EDITED\/nextcloud", "dbtype": "pgsql", "version": "20.0.8.1", "dbname": "REMOVED SENSITIVE VALUE", "dbhost": "REMOVED SENSITIVE VALUE", "dbport": "5432", "dbtableprefix": "oc_", "dbuser": "REMOVED SENSITIVE VALUE", "dbpassword": "REMOVED SENSITIVE VALUE", "logtimezone": "UTC", "installed": true, "instanceid": "REMOVED SENSITIVE VALUE", "updatechecker": "false", "overwriteprotocol": "https", "overwritewbroot": "\/nextcloud", "htaccess.RewriteBase": "\/nextcloud", "memcache.local": "\OC\Memcache\APCu", "ldapIgnoreNamingRules": false, "ldapProviderFactory": "\OCA\User_LDAP\LDAPProviderFactory", "loglevel": 2, "maintenance": false, "trusted_proxies": "REMOVED SENSITIVE VALUE", "trusted_domains": [ "EDITED", "EDITED", "EDITED", "EDITED" ], "mail_smtpmode": "smtp", "mail_from_address": "REMOVED SENSITIVE VALUE", "mail_domain": "REMOVED SENSITIVE VALUE", "mail_smtpauthtype": "LOGIN", "mail_smtpauth": 1, "mail_smtphost": "REMOVED SENSITIVE VALUE", "mail_smtpport": "465", "mail_smtpsecure": "ssl", "mail_smtpname": "REMOVED SENSITIVE VALUE", "mail_smtppassword": "REMOVED SENSITIVE VALUE", "app_install_overwrite": [ "sharerenamer" ], "encryption.legacy_format_support": false, "encryption.key_storage_migrated": false, "memcache.distributed": "\OC\Memcache\APCu" } }

</details>

### Server log (data/nextcloud.log)
<details>
{"reqId":"vGeeTNTjl0F7E0vE1UIL","level":3,"time":"2021-03-25T19:27:24+00:00","remoteAddr":"89.206.112.11","user":"tohoff","app":"no app in context","method":"POST","url":"/nextcloud/apps/text/session/sync","message":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"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 [\"tohoff\"]:\n\nSQLSTATE[42P01]: Undefined table: 7 FEHLER:  Relation »oc_talk_participants« existiert nicht\nLINE 1: ...T \"r\".*, \"p\".* FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_p...\n                                                             ^","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":149,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":914,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Manager.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Share/RoomShareProvider.php","line":779,"function":"getRoomsForParticipant","class":"OCA\\Talk\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->"},{"file":"/var/www/html/apps/files_sharing/lib/MountProvider.php","line":80,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Files/Config/MountProviderCollection.php","line":119,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":452,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":377,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/legacy/OC_Util.php","line":322,"function":"init","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":355,"function":"setupFS","class":"OC_Util","type":"::"},{"file":"/var/www/html/lib/private/Files/View.php","line":1152,"function":"resolvePath","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/Files/View.php","line":543,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":270,"function":"file_exists","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":230,"function":"getKey","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":122,"function":"getKeyWithUid","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/apps/encryption/lib/KeyManager.php","line":615,"function":"getSystemUserKey","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/apps/encryption/lib/KeyManager.php","line":171,"function":"getPublicShareKey","class":"OCA\\Encryption\\KeyManager","type":"->"},{"file":"/var/www/html/apps/encryption/lib/Users/Setup.php","line":87,"function":"validateShareKey","class":"OCA\\Encryption\\KeyManager","type":"->"},{"file":"/var/www/html/apps/encryption/lib/AppInfo/Application.php","line":73,"function":"setupSystem","class":"OCA\\Encryption\\Users\\Setup","type":"->"},{"file":"/var/www/html/apps/encryption/appinfo/app.php","line":37,"function":"setUp","class":"OCA\\Encryption\\AppInfo\\Application","type":"->"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":289,"args":["/var/www/html/apps/encryption/appinfo/app.php"],"function":"require_once"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":171,"function":"requireAppFile","class":"OC_App","type":"::"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":131,"function":"loadApp","class":"OC_App","type":"::"},{"file":"/var/www/html/lib/base.php","line":993,"function":"loadApps","class":"OC_App","type":"::"},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php","Line":63,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 FEHLER:  Relation »oc_talk_participants« existiert nicht\nLINE 1: ...T \"r\".*, \"p\".* FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_p...\n                                                             ^","Code":"42P01","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":906,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Manager.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Share/RoomShareProvider.php","line":779,"function":"getRoomsForParticipant","class":"OCA\\Talk\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->"},{"file":"/var/www/html/apps/files_sharing/lib/MountProvider.php","line":80,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Files/Config/MountProviderCollection.php","line":119,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":452,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":377,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/legacy/OC_Util.php","line":322,"function":"init","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":355,"function":"setupFS","class":"OC_Util","type":"::"},{"file":"/var/www/html/lib/private/Files/View.php","line":1152,"function":"resolvePath","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/Files/View.php","line":543,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":270,"function":"file_exists","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":230,"function":"getKey","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":122,"function":"getKeyWithUid","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/apps/encryption/lib/KeyManager.php","line":615,"function":"getSystemUserKey","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/apps/encryption/lib/KeyManager.php","line":171,"function":"getPublicShareKey","class":"OCA\\Encryption\\KeyManager","type":"->"},{"file":"/var/www/html/apps/encryption/lib/Users/Setup.php","line":87,"function":"validateShareKey","class":"OCA\\Encryption\\KeyManager","type":"->"},{"file":"/var/www/html/apps/encryption/lib/AppInfo/Application.php","line":73,"function":"setupSystem","class":"OCA\\Encryption\\Users\\Setup","type":"->"},{"file":"/var/www/html/apps/encryption/appinfo/app.php","line":37,"function":"setUp","class":"OCA\\Encryption\\AppInfo\\Application","type":"->"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":289,"args":["/var/www/html/apps/encryption/appinfo/app.php"],"function":"require_once"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":171,"function":"requireAppFile","class":"OC_App","type":"::"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":131,"function":"loadApp","class":"OC_App","type":"::"},{"file":"/var/www/html/lib/base.php","line":993,"function":"loadApps","class":"OC_App","type":"::"},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":129,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 FEHLER:  Relation »oc_talk_participants« existiert nicht\nLINE 1: ...T \"r\".*, \"p\".* FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_p...\n                                                             ^","Code":"42P01","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":127,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":906,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Manager.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Share/RoomShareProvider.php","line":779,"function":"getRoomsForParticipant","class":"OCA\\Talk\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->"},{"file":"/var/www/html/apps/files_sharing/lib/MountProvider.php","line":80,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Files/Config/MountProviderCollection.php","line":119,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":452,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":377,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/legacy/OC_Util.php","line":322,"function":"init","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":355,"function":"setupFS","class":"OC_Util","type":"::"},{"file":"/var/www/html/lib/private/Files/View.php","line":1152,"function":"resolvePath","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/Files/View.php","line":543,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":270,"function":"file_exists","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":230,"function":"getKey","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/lib/private/Encryption/Keys/Storage.php","line":122,"function":"getKeyWithUid","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/apps/encryption/lib/KeyManager.php","line":615,"function":"getSystemUserKey","class":"OC\\Encryption\\Keys\\Storage","type":"->"},{"file":"/var/www/html/apps/encryption/lib/KeyManager.php","line":171,"function":"getPublicShareKey","class":"OCA\\Encryption\\KeyManager","type":"->"},{"file":"/var/www/html/apps/encryption/lib/Users/Setup.php","line":87,"function":"validateShareKey","class":"OCA\\Encryption\\KeyManager","type":"->"},{"file":"/var/www/html/apps/encryption/lib/AppInfo/Application.php","line":73,"function":"setupSystem","class":"OCA\\Encryption\\Users\\Setup","type":"->"},{"file":"/var/www/html/apps/encryption/appinfo/app.php","line":37,"function":"setUp","class":"OCA\\Encryption\\AppInfo\\Application","type":"->"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":289,"args":["/var/www/html/apps/encryption/appinfo/app.php"],"function":"require_once"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":171,"function":"requireAppFile","class":"OC_App","type":"::"},{"file":"/var/www/html/lib/private/legacy/OC_App.php","line":131,"function":"loadApp","class":"OC_App","type":"::"},{"file":"/var/www/html/lib/base.php","line":993,"function":"loadApps","class":"OC_App","type":"::"},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":127}},"CustomMessage":"App encryption threw an error during app.php load: 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 [\"tohoff\"]:\n\nSQLSTATE[42P01]: Undefined table: 7 FEHLER:  Relation »oc_talk_participants« existiert nicht\nLINE 1: ...T \"r\".*, \"p\".* FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_p...\n                                                             ^"},"userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0","version":"20.0.8.1","id":"605ce45631b2a"}```

nickvergessen commented 3 years ago

Did you update to 10.1.3 and now back to 10.0.6?

kiilo commented 3 years ago

ok i followed suggestions in #4230 and got this migrations in the log: installed via cli sudo -u www-data occ app:install spreed

{"reqId":"3DdA7PWuDQaJiru8Vvgf","level":3,"time":"2021-03-25T19:52:42+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"{\"5\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2000Date20170707093535.php\",\"0\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2000Date20171026140256.php\",\"7\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2000Date20171026140257.php\",\"9\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20170707115443.php\",\"16\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20170913104501.php\",\"13\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20170921145301.php\",\"29\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20170929092606.php\",\"20\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20171009132424.php\",\"31\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20171026134605.php\",\"2\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20171026141336.php\",\"21\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20171031102049.php\",\"1\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20180103144447.php\",\"11\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version2001Date20180103150836.php\",\"18\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3002Date20180319104030.php\",\"6\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3003Date20180707222130.php\",\"32\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3003Date20180718112436.php\",\"15\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3003Date20180718133519.php\",\"30\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3003Date20180720162342.php\",\"10\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3003Date20180722152733.php\",\"19\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3003Date20180722152849.php\",\"17\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version3003Date20180730080327.php\",\"3\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version4099Date20181001123058.php\",\"23\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version5099Date20190121102337.php\",\"22\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version5099Date20190319134820.php\",\"28\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version6099Date20190627172429.php\",\"26\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version7000Date20190717141457.php\",\"4\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version7000Date20190724121136.php\",\"12\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version7000Date20190724121137.php\",\"14\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version8000Date20200331144101.php\",\"24\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version8000Date20200402124456.php\",\"25\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version8000Date20200407073807.php\",\"27\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version8000Date20200407115318.php\",\"8\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version10000Date20200819121721.php\",\"33\":\"\\/var\\/www\\/html\\/apps\\/spreed\\/lib\\/Migration\\/Version11000Date20200922161218.php\"}","userAgent":"--","version":"20.0.8.1"}

below


{"reqId":"a4Z1tsTsF2N62YU08wY2","level":3,"time":"2021-03-25T19:52:48+00:00","remoteAddr":"89.206.112.10","user":"crashtest","app":"no app in context","method":"PROPPATCH","url":"/nextcloud/remote.php/caldav/calendars/nlange/zilla-huber-zh-nc_shared_by_zhuber/","message":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"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 [\"nlange\"]:\n\nSQLSTATE[42P01]: Undefined table: 7 FEHLER:  Relation \u00bboc_talk_participants\u00ab existiert nicht\nLINE 1: ...T \"r\".*, \"p\".* FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_p...\n                                                             ^","Code":0,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":149,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":914,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::"},{"file":"/var/www/html/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Manager.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/apps/spreed/lib/Share/RoomShareProvider.php","line":779,"function":"getRoomsForParticipant","class":"OCA\\Talk\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->"},{"file":"/var/www/html/apps/files_sharing/lib/MountProvider.php","line":80,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/html/lib/private/Files/Config/MountProviderCollection.php","line":119,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":452,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->"},{"file":"/var/www/html/lib/private/Files/Filesystem.php","line":377,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/lib/private/legacy/OC_Util.php","line":322,"function":"init","class":"OC\\Files\\Filesystem","type":"::"},{"file":"/var/www/html/apps/encryption/lib/Hooks/UserHooks.php","line":345,"function":"setupFS","class":"OC_Util","type":"::"},{"file":"/var/www/html/apps/encryption/lib/Hooks/UserHooks.php","line":177,"function":"setupFS","class":"OCA\\Encryption\\Hooks\\UserHooks","type":"->"},{"file":"/var/www/html/lib/private/legacy/OC_Hook.php","line":110,"function":"login","class":"OCA\\Encryption\\Hooks\\UserHooks","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Server.php","line":568,"function":"emit","class":"OC_Hook","type":"::"},{"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/Hooks/EmitterTrait.php","line":101,"function":"call_user_func_array"},{"file":"/var/www/html/lib/private/Hooks/PublicEmitter.php","line":40,"function":"emit","class":"OC\\Hooks\\BasicEmitter","type":"->"},{"file":"/var/www/html/lib/private/User/Session.php","line":412,"function":"emit","class":"OC\\Hooks\\PublicEmitter","type":"->"},{"file":"/var/www/html/lib/private/User/Session.php","line":624,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":367,"function":"loginWithPassword","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/lib/private/User/Session.php","line":462,"function":"login","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Auth.php","line":131,"function":"logClientIn","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Backend/AbstractBasic.php","line":106,"function":"validateUserPass","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Auth.php","line":254,"function":"check","class":"Sabre\\DAV\\Auth\\Backend\\AbstractBasic","type":"->"},{"file":"/var/www/html/apps/dav/lib/Connector/Sabre/Auth.php","line":156,"function":"auth","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->"},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":192,"function":"check","class":"OCA\\DAV\\Connector\\Sabre\\Auth","type":"->"},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Auth/Plugin.php","line":144,"function":"check","class":"Sabre\\DAV\\Auth\\Plugin","type":"->"},{"file":"/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"beforeMethod","class":"Sabre\\DAV\\Auth\\Plugin","type":"->"},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php","line":458,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php","line":251,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php","line":319,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/apps/dav/appinfo/v1/caldav.php","line":106,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/remote.php","line":167,"args":["/var/www/html/apps/dav/appinfo/v1/caldav.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php","Line":63,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42P01]: Undefined table: 7 FEHLER:  Relation \u00bboc_talk_participants\u00ab existiert nicht\nLINE 1: ...T \"r\".*, \"p\".* FROM \"oc_talk_rooms\" \"r\" LEFT JOIN \"oc_talk_p...\n   ```

kiilo commented 3 years ago

Did you update to 10.1.3 and now back to 10.0.6?

no i don't think so ... just updated when suggested by nextcloud (have zabbix monitoring on this)

kiilo commented 3 years ago

mmmh - as suggested here #5324 maybe Im one of the 50 too ;-) ... upgrade to 10.1.3??

nickvergessen commented 3 years ago

Well since you wont get a downgrade from the appstore, so you would need to manually delete it and download 10.0.6 again.

nickvergessen commented 3 years ago

But other than that updating from 20.0.2 to 20.0.8 doesn't do anything with the Talk version. So either you restored an old backup or something else broke. Do you have an oc_talk_attendees table maybe?

kiilo commented 3 years ago

Well since you wont get a downgrade from the appstore, so you would need to manually delete it and download 10.0.6 again.

did a manual install on cli of 10.0.6

cd ../apps
wget https://github.com/nextcloud/spreed/archive/refs/tags/v10.0.6.zip
unzip v10.0.6.zip
mv spreed-10.0.6/ spreed
find ./spreed -type f -exec chmod 0640 {} \;
find ./spreed -type d -exec chmod 0750 {} \;
chown -R www-data:www-data spreed
cd ..
sudo -u www-data php occ app:enable spreed

same errors again - downgrade? upgrade? or drop talk?

kiilo commented 3 years ago

i have

public | oc_talk_attendees           | Tabelle | nextcloud
 public | oc_talk_bridges             | Tabelle | nextcloud
 public | oc_talk_commands            | Tabelle | nextcloud
 public | oc_talk_guests              | Tabelle | nextcloud
 public | oc_talk_rooms               | Tabelle | nextcloud
 public | oc_talk_sessions            | Tabelle | nextcloud
 public | oc_talk_signaling           | Tabelle | nextcloud
 public | oc_text_documents           | Tabelle | nextcloud
 public | oc_text_sessions            | Tabelle | nextcloud

nickvergessen commented 3 years ago

Then please use 10.1.3 as your database is already updated to that. If you deploy the 10.1.3 files everything should be good again.

kiilo commented 3 years ago

Then please use 10.1.3 as your database is already updated to that. If you deploy the 10.1.3 files everything should be good again.

Did just that and get the icon bar + a white screen below.

App settings talk has no forms just the text

could i drop the oc_talk tables and they are rebuild on reinstall?

nickvergessen commented 3 years ago

Did you download https://github.com/nextcloud/spreed/releases/download/v10.1.3/spreed-10.1.3.tar.gz Above you posted another kind of link which makes me assume you deployed the non compiled JS

kiilo commented 3 years ago

just did the radical move - since this app wasn't used so much: im on postgres:

removed app via sudo -u www-data php occ app:remove spreed:

then purged the whole DB entries:

delete from oc_migrations where app='spreed';
delete from oc_preferences where appid='spreed';
drop table oc_talk_attendees;
drop table oc_talk_<XY>;

and reinstalled 10.0.6 by webinterface ...

back to zero for this.

Your help was highly appreciated Thanks

nextcloud / spreed