SQL Issues with Talk/Spreed App

j-ed · December 11, 2020, 8:55am

The problems has already been discussed several times in the past. Hopefully you find a solution for the problem here:

github.com/nextcloud/spreed

Can not re-enable Talk on Postgres after installing Spreed on Nextcloud 12

opened 02:49PM - 11 Jan 18 UTC

closed 02:57PM - 09 Mar 18 UTC

enoch85

bug needs info

### Steps to reproduce 1. Try to install Talk ### Expected behaviour No err…or ### Actual behaviour ``` An exception occurred while executing 'INSERT INTO "oc_talk_participants" ("userId", "roomId", "lastPing", "sessionId", "participantType") VALUES(?, ?, ?, ?, ?)' with params ["daniel@en0ch.se", 9, 1494860929, "0", 0]: SQLSTATE[42703]: Undefined column: 7 ERROR: column "userId" of relation "oc_talk_participants" does not exist LINE 1: INSERT INTO "oc_talk_participants" ("userId", "roomId", "las... ^ ``` ![skarmbild fran 2018-01-11 15 04 38](https://user-images.githubusercontent.com/4511254/34829435-f8e68548-f6e0-11e7-8119-70a631873c29.png) ## Server configuration detail **Operating system:** Linux 4.4.0-109-generic #132-Ubuntu SMP Tue Jan 9 19:52:39 UTC 2018 x86_64 **Webserver:** Apache/2.4.18 (Ubuntu) (apache2handler) **Database:** pgsql PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit **PHP version:** 7.0.22-0ubuntu0.16.04.1 Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, apache2handler, PDO, xml, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, imagick, imap, intl, json, ldap, exif, mcrypt, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, readline, redis, shmop, SimpleXML, smbclient, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, libsmbclient, Zend OPcache **Nextcloud version:** 13.0.0 Beta 4 - 13.0.0.9 **Updated from an older Nextcloud/ownCloud or fresh install:** **Where did you install Nextcloud from:** unknown <details><summary>Signing status</summary> Array </details> <details><summary>List of activated apps</summary> ``` Enabled: - activity: 2.6.1 - admin_notifications: 1.0.1 - bruteforcesettings: 1.0.3 - calendar: 1.5.7 - comments: 1.3.0 - contacts: 2.0.1 - dav: 1.4.6 - federatedfilesharing: 1.3.1 - federation: 1.3.0 - files: 1.8.0 - files_downloadactivity: 1.2.0 - files_pdfviewer: 1.2.0 - files_sharing: 1.5.0 - files_texteditor: 2.5.1 - files_trashbin: 1.3.0 - files_versions: 1.6.0 - files_videoplayer: 1.2.0 - firstrunwizard: 2.2.1 - gallery: 18.0.0 - impersonate: 1.0.2 - issuetemplate: 0.3.0 - logreader: 2.0.0 - lookup_server_connector: 1.1.0 - mail: 0.7.7 - nextcloud_announcements: 1.2.0 - notes: 2.3.2 - notifications: 2.1.2 - oauth2: 1.1.0 - ocsms: 1.12.2 - password_policy: 1.3.0 - previewgenerator: 1.0.9 - provisioning_api: 1.3.0 - qownnotesapi: 17.5.0 - richdocuments: 1.12.39 - serverinfo: 1.3.0 - sharebymail: 1.3.0 - socialsharing_diaspora: 1.0.2 - socialsharing_email: 1.0.3 - socialsharing_facebook: 1.0.2 - socialsharing_googleplus: 1.0.2 - socialsharing_twitter: 1.0.2 - survey_client: 1.1.0 - systemtags: 1.3.0 - theming: 1.4.1 - twofactor_backupcodes: 1.2.3 - twofactor_totp: 1.4.1 - updatenotification: 1.3.0 - workflowengine: 1.3.0 Disabled: - admin_audit - encryption - files_external - spreed - user_external - user_ldap ``` </details> <details><summary>Configuration (config/config.php)</summary> ``` { "updatechecker": false, "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "localhost", "192.168.4.111", "cloud.techandme.se", "office.techandme.se" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "https:\/\/cloud.techandme.se\/", "dbtype": "pgsql", "version": "13.0.0.9", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "logtimezone": "Europe\/Stockholm", "installed": true, "instanceid": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "mail_smtpauth": 1, "mail_smtpport": "587", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "LOGIN", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "allowZipDownload": true, "session_lifetime": 1800, "forcessl": true, "logfile": "\/var\/log\/nfs-share\/nextcloud.log", "loglevel": 2, "memcache.local": "\\OC\\Memcache\\Redis", "filelocking.enabled": true, "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0, "timeout": 0, "dbindex": 0 }, "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "forwarded_for_headers": [ "HTTP_X_FORWARDED", "HTTP_FORWARDED_FOR" ], "maintenance": false, "mail_smtpsecure": "tls", "htaccess.RewriteBase": "\/", "theme": "", "updater.release.channel": "stable", "trashbin_retention_obligation": "auto, 30", "activity_expire_days": 60 } ``` </details> **Are you using external storage, if yes which one:** local/smb/sftp/... **Are you using encryption:** no **Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/... <details><summary>LDAP configuration (delete this part if not used)</summary> ``` With access to your command line run e.g.: sudo -u www-data php occ ldap:show-config from within your Nextcloud installation folder Without access to your command line download the data/owncloud.db to your local computer or access your SQL server remotely and run the select query: SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap'; Eventually replace sensitive data as the name/IP-address of your LDAP server or groups. ``` </details> ## Client configuration **Browser:** Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.111 Safari/537.36 **Operating system:** ## Logs <details><summary>Browser log</summary> ``` Insert your webserver log here ``` </details> <details><summary>Nextcloud log</summary> ``` Insert your Nextcloud log here Error | core | An exception occurred while executing 'INSERT INTO "oc_talk_participants" ("userId", "roomId", "lastPing", "sessionId", "participantType") VALUES(?, ?, ?, ?, ?)' with params ["daniel@en0ch.se", 9, 1494860929, "0", 0]: SQLSTATE[42703]: Undefined column: 7 ERROR: column "userId" of relation "oc_talk_participants" does not exist LINE 1: INSERT INTO "oc_talk_participants" ("userId", "roomId", "las... ^ | 2018-01-11T15:03:58+0100 -- | -- | -- | -- Error | PHP | Undefined index: participantType at /var/www/nextcloud/apps/spreed/lib/Migration/Version2001Date20171026134605.php#227 | 2018-01-11T15:03:58+0100 Error | core | An exception occurred while executing 'INSERT INTO "oc_talk_participants" ("userId", "roomId", "lastPing", "sessionId", "participantType") VALUES(?, ?, ?, ?, ?)' with params ["daniel@en0ch.se", 6, 1494860929, "0", 0]: SQLSTATE[42703]: Undefined column: 7 ERROR: column "userId" of relation "oc_talk_participants" does not exist LINE 1: INSERT INTO "oc_talk_participants" ("userId", "roomId", "las... ^ | 2018-01-11T15:03:29+0100 Error | PHP | Undefined index: participantType at /var/www/nextcloud/apps/spreed/lib/Migration/Version2001Date20171026134605.php#227 | 2018-01-11T15:03:29+0100 ``` </details> <details><summary>Browser log</summary> Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... </details>

github.com/nextcloud/spreed

Installation error: "oc_talk_participants"

opened 10:08AM - 25 Sep 20 UTC

closed 08:02PM - 25 Sep 20 UTC

Valdnet

0. Needs triage bug needs info

When installing Talk v10.0.0-rc.2 and v9.0.4 versions in Nextcloud 20.0.0 beta4 …there is an error: `There is no table with name 'xxx.oc_talk_participants' in the schema.` There are no tables for Talk in the phpMyAdmin database. **Database:** phpMyAdmin libmysql - mysqlnd 5.0.12-dev - 20150407 **PHP version:** 7.3.16 **Nextcloud Version:** (see admin page) 20.0.0 beta4