I have problems with my installation of the Collabora Online - Built-in CODE Server and related apps.
I guess from older installation there are old configurations and database entries.
How can I delete these stuff completely, so I can install a clean Collabora Online - Built-in CODE Server and Nextcloud Office?
Has noone an idea?
Prosuming you are using MariaDB and you know how to work with the commandline client:
Look first, what values are stored:
SELECT * FROM oc_appconfig WHERE appid LIKE '%richdocuments%' OR configkey LIKE '%richdocuments%';
If you want to delete these entries:
DELETE FROM oc_appconfig WHERE appid LIKE '%richdocuments%' OR configkey LIKE '%richdocuments%';
same for your preferences. Look first:
SELECT * FROM oc_preferences WHERE appid = 'richdocuments';
delete:
DELETE FROM oc_preferences WHERE appid = 'richdocuments';
Then you can remove the old migrations:
look:
SELECT * FROM oc_migrations WHERE app = 'richdocuments';
delete:
DELETE * FROM oc_migrations WHERE app = 'richdocuments';
You mentioned ONLYOFFICE in the title but ONLYOFFICE is not related to CODE and/or Nextcloud Office.
But because you mentioned it, its almost the same.
look:
SELECT * FROM oc_appconfig WHERE appid = 'onlyoffice';
delete:
DELETE FROM oc_appconfig WHERE appid = 'onlyoffice';
etc.
(onlyoffice has some migrations too but not more.)
Just be careful. Be sure to always create a backup (dump) of the database before you do any magic with it.
Much luck,
ernolf
Many thanks for your help. It woks fine but didn’t solve my problem 
After new installation of Collabora Online - Built-in CODE Server 23.5.503 and Nextcloud Office 8.2.2 I get always loading circle while attemp to open any documents. So I give up to use Nextcloud Office.
I could have told you that right away, but you didn’t ask 
How did you configure it inside of the Nextcloud Office admin settings page?
It really belong to those apps that should work almost out of the box, so I’m wondering how your problems arise. Are the server resources sufficient?
Much luck,
ernolf
That is the problem. How to ask what you need if not clear.
I made no special configurations yet.
I use built-in CODE - Server and it is reachable.
My NC ist hostet by my Provider and has enough resources. Maybe I failed by one or other config at all.
But NC is running perfectly since years now, but the Office part.
Try it once more with Allow list for WOPI requests set to 0.0.0.0/0:
Worth to give it a try
Much luck,
ernolf
It is not working either.
There must be a, maybe config failure from the past attempts to use any kind of collaboration Office, which is deeper than in DB entries.
