#105608Reaction "create-record": Could not convert database value to "json" as an error was triggered by the unserialization: Syntax error
Description
Hello,
I want to create a new Reaction, but when I choose in the first selector (Reaction Type) “create-record”, the page reloadd, but then appears error Could not convert database value to “json” as an error was triggered by the unserialization: Syntax error.
After that I’m not able to do anything with Reactions until I remove the DB entry, becuase it always shows that error
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
Files 1
History 3
-
Benjamin Franzke commented and changed status
NewNeeds Feedback <span data-processor="relativetime" data-value="2024-11-15T16:59:18+00:00" > 11/15/24, 16:59 </span> -
Martin Pribyl commented <span data-processor="relativetime" data-value="2024-12-04T12:41:02+00:00" > 12/04/24, 12:41 </span>
Benjamin Franzke wrote in #note-1:
> I can not reproduce, but this issue is likely to happen if JSON field-type is not properly defined in the database schema.
>
> Please provide more context:
>
> What database are you using? MySQL, MariaDB, Postgres or SQLite?
>
> What version of the database engine? (check InstallTool > Show System Information…)
>
> Are there any (maybe reoccuring) open changes in Database Analyzer?
>
> If using MySQL/MariaDB, output of
> […]Hello,
I have still this issue. But I probably found the issue. The field is in database JSON, but I have MariaDB 10.3, but that field type is available from 10.4.3So Thanks for your time, this issue came to me and sorry for all.
Martin
As a note, I found it over database, that in the field “fields” was saved “Array” instead of “{}”.
-
Georg Ringer commented and changed status
Needs FeedbackClosed <span data-processor="relativetime" data-value="2025-01-22T22:13:04+00:00" > 01/22/25, 22:13 </span>thanks for your feedback, I close this issue. if you still think it is valid, feel free to contact me e.g. via slack
I can not reproduce, but this issue is likely to happen if JSON field-type is not properly defined in the database schema.
Please provide more context:
What database are you using? MySQL, MariaDB, Postgres or SQLite?
What version of the database engine? (check InstallTool > Show System Information…)
Are there any (maybe reoccuring) open changes in Database Analyzer?
If using MySQL/MariaDB, output of