SQL Error when using revisions on module

šŸ’» Core Engineering
#1

Hi there,

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!

#2

Tracked in Github