Migration/upgrade did not change version to varchar from int(11)

[jandr]

In Nextcloud 32.0.6, and richdocuments 9.0.5, the version column on oc_richdocuments_wopi is an int(11). However, latest collabora reports the version as "25.04.9.4", leading to errors abour an unauthorized WOPI host (but the issue is the database insert)

It can be fixed with the command below:

ALTER TABLE oc_richdocuments_wopi
MODIFY COLUMN version VARCHAR(50) DEFAULT '0';

[joshtrichards]

That column stores file versions not the Collabora version AFAIK.

It also, as it happens, was already switched to a string type in #5237.

Are you certain that was really the culprit and not just a coincidence?

[jandr]

I am not 100% sure the Collabora version was the culprit, although the logs seemed to point to this: I enabled MariaDB/MySQL general log and tried editing a rich text document via Collabora. It failed, and this was the error in the logs (some fields redacted):

# grep -i "richdocuments_wopi" /tmp/mysql_general.log | grep -i "insert" 

...

6046 Query    INSERT INTO oc_richdocuments_wopi (fileid, owner_uid, editor_uid, version, canwrite, server_host, token, expiry, template_id, token_type) VALUES(-1, 'jonas', 'jonas', '25.04.9.4', 1, 'https://nextcloud.example.com/', 'Zex...U', 1774522444, 0, 5)

But now that you mentioned it, this might have been just a coincidence, as I have reviewed my notes (unfortunately I don't have the original log anymore) and have seen other inserts in which the version was simply 0 . What I know is that the change fixed the problem (so if the column should have been a varchar as you indicated but wasn't, the changed obviously solved it, although maybe not because this was needed for the Collabora server version to be stored in version ).

[koanya]

I had the same problem. The Collabora/Nextcloud combination was working fine with Richdocument. One day (probably after an update), I started getting the error " Unauthorised WOPI host" every time I opened a document with Richdocument, along with the error "richdocuments DbalException An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'version' at row 1" in Nextcloud logs.
The value inserted in version column was also 25.04.9.4 :
282 Query INSERT INTO oc_richdocuments_wopi (fileid, owner_uid, editor_uid, version, canwrite, server_host, token, expiry, template_id, token_type) VALUES(-1, 'admin', 'admin', '25.04.9.4', 1, 'https://nextcloud.....fr/', '2FS....Tk', 1776484155, 0, 5).
I changed the type of the version column from bigint(20) to varchar(50) and that solved the problem. If I switch back to bigint(20), the problem reappears.