nickvergessen
commented
3 years ago Hmm, it seems to be an issue with your activity app not being up to date. Can you post the table structure of oc_activities
Closed netzgestaltung closed 3 years ago
nickvergessen
commented
3 years ago Hmm, it seems to be an issue with your activity app not being up to date. Can you post the table structure of oc_activities
netzgestaltung
commented
3 years ago Hi,
i assume you got a typo here, i only have the tables oc_activity and oc_activity_mq
The app page says that i have Activity version 2.12.1
How would this affect spreed app installation?
This is the structure of oc_activity:
MariaDB [mydb]> DESCRIBE oc_activity;
+---------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------+----------------+
| activity_id | bigint(20) | NO | PRI | NULL | auto_increment |
| timestamp | int(11) | NO | | 0 | |
| priority | int(11) | NO | | 0 | |
| type | varchar(255) | YES | | NULL | |
| user | varchar(64) | YES | | NULL | |
| affecteduser | varchar(64) | NO | MUL | NULL | |
| app | varchar(32) | NO | | NULL | |
| subject | varchar(255) | NO | | NULL | |
| subjectparams | longtext | NO | | NULL | |
| message | varchar(255) | YES | | NULL | |
| messageparams | longtext | YES | | NULL | |
| file | varchar(4000) | YES | | NULL | |
| link | varchar(4000) | YES | | NULL | |
| object_type | varchar(255) | YES | MUL | NULL | |
| object_id | bigint(20) | NO | | 0 | |
+---------------+---------------+------+-----+---------+----------------+
15 rows in set (0.001 sec)
But here the column subjectparams exists, so why would it fail to get that :thinking:
netzgestaltung
commented
3 years ago i don't know, maybe its missing in another table?
do you think its related to the problem or another thing?
netzgestaltung
commented
3 years ago Hi,
to get a solution i thought about that:
oc_spreedme_room_participants, oc_spreedme_rooms, oc_talk_participants, oc_talk_rooms, oc_talk_signalingis this possible without breaking NC entirely? Should i instead only remove the contents of that tables?
nickvergessen
commented
3 years ago netzgestaltung
commented
3 years ago After a backup was made, deleting all related data and tables worked, now i was able to install talk:
warning Use at own risk, this really whips all data, rooms, chats, activities, notifications, ... warning warning This was written for SpreedMe and Talk up to version 3.1 warning
Clean tables of server and apps:
DELETE FROM `oc_activity` WHERE `app` = 'spreed'; DELETE FROM `oc_activity_mq` WHERE `amq_appid` = 'spreed'; DELETE FROM `oc_appconfig` WHERE `appid` = 'spreed'; DELETE FROM `oc_comments` WHERE `object_type` = 'chat'; DELETE FROM `oc_comments_read_markers` WHERE `object_type` = 'chat'; DELETE FROM `oc_filecache` WHERE `path` LIKE '%spreed%'; DELETE FROM `oc_jobs` WHERE `class` LIKE '%Spreed%'; DELETE FROM `oc_migrations` WHERE `app` = 'spreed'; DELETE FROM `oc_notifications` WHERE `app` = 'spreed'; DELETE FROM `oc_preferences` WHERE `appid` = 'spreed';Delete former tables
DROP TABLE `oc_spreedme_messages`; DROP TABLE `oc_spreedme_rooms`; DROP TABLE `oc_spreedme_room_participants`; DROP TABLE `oc_videocalls_signaling`;Delete current tables
DROP TABLE `oc_talk_guests`; DROP TABLE `oc_talk_participants`; DROP TABLE `oc_talk_rooms`; DROP TABLE `oc_talk_signaling`;Delete cached css files
Inside your data directory there is a
appdata_oc*random string*directory. Navigate into that and run the following command:rm -rf css/spreed/Delete the app files
In your Nextcloud root (not data directory root, in case you use a non default app-dir adjust the path):
rm -rf apps/spreed/
some steps produced errors when the data was not there, but then that was the proove.
Steps to reproduce in Webinterface (All text translated from german, i don't know the english interface)
Steps to reproduce on CLI
An unhandled exception has been thrown: json_decode() expects parameter 1 to be string(more see below)Expected behaviour
Talk is enabled and useable
Actual behaviour
Talk is not enabled.
Talk app
Talk app version: 9.0.4
Custom Signaling server configured: no
Custom TURN server configured: no
Custom STUN server configured: no
Browser
Microphone available: yes
Camera available: no
Operating system: Fedora 32
Browser name: Firefox
Browser version: 81.0.1
Browser log
a) The javascript console log
b) The network log -> no idea how to get
c) CLI Log
Server configuration
Operating system: Debian 10
Web server: Apache
Database: MySQL
PHP version: 7.4
Nextcloud Version: 19.0.4
List of activated apps:
Nextcloud configuration:
Server log (data/nextcloud.log)
Hi, since version 17 of nextcloud at one of my instances i cant reenable talk, no matter what version i had since then. I have no idea whats wrong with it.
Please help.
Thank you for your effort.
Br, tom