Bug #105608
open
Reaction "create-record": Could not convert database value to "json" as an error was triggered by the unserialization: Syntax error
0%
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
Files
Updated by Benjamin Franzke 24 days ago
· Edited
- Status changed from New to Needs Feedback
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
show create table sys_reaction;
Updated by Martin Pribyl 5 days ago
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.3
So 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 "{}".