Issue Bug Closed

#105608Reaction "create-record": Could not convert database value to "json" as an error was triggered by the unserialization: Syntax error

Martin Pribyl 11/15/24, 15:43 updated 01/22/25, 22:13

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

  1. Benjamin Franzke commented and changed status New Needs Feedback 11/15/24, 16:59

    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;
  2. 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.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 “{}”.

  3. Georg Ringer commented and changed status Needs Feedback Closed 01/22/25, 22:13

    thanks for your feedback, I close this issue. if you still think it is valid, feel free to contact me e.g. via slack