Update Talk 8.0.6 to 8.0.7 in Nextcloud 18.03 failed

ℹ️ Support
,
6

Thanks for your help @dec0de,
I just found a solution, too and it worked out quite perfectly for my case, using mysql, Ubuntu 18 and Nextcloud 18.04.

Just follow those instructions:

  1. Go to mysql and enrol as nextcloud
    sudo mysql -u root -p
    use nextcloud
  2. type in following lines
    CREATE TABLE oc_talk_participants_temp LIKE oc_talk_participants;
    CREATE UNIQUE INDEX tp_ident ON oc_talk_participants_temp (room_id, user_id, session_id);
    INSERT IGNORE INTO oc_talk_participants_temp SELECT * FROM oc_talk_participants;
    DROP TABLE oc_talk_participants;
    ALTER TABLE oc_talk_participants_temp RENAME TO oc_talk_participants;
  3. exit mysql
2 Likes