i just updated to 2022.9.6 and im running on mariadb docker container.
first thing i did was enabling the new record revision but got following error when updateing a record:
“Could not update record: failed to complete transaction: Error 1366: Incorrect decimal value: ‘updated’ for column ‘operation’ at row 1”
The table got created without problems from what i can see, show create table record_revisions_begleiter:
CREATE TABLE `record_revisions_begleiter` ( `id` bigint unsigned NOT NULL, `ts` datetime NOT NULL, `revision` decimal(10,0) NOT NULL, `operation` decimal(10,0) NOT NULL, `rel_resource` bigint unsigned NOT NULL, `rel_user` bigint unsigned NOT NULL, `delta` json NOT NULL, `comment` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
from what the error says it tries to insert the string “updated” into the decimal field “operation”, maybe the order in the insert statement is flawed?
Thanks in advance, im looking very forward to this feature!