#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 11/15/24, 16:59 -
Martin Pribyl commented 12/04/24, 12:41
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 01/22/25, 22:13thanks 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