Postges: 'invalid input syntax for type json' - keep getting this, even when I've validated the JSON is valid

Wappler General Need Help
1

Hi Wappler team.

I am getting the above error. I have validated that the JSON i’m trying to insert into a JSONB column is indeed valid, and without error.

Any advice what I can look into?

UPDATE:

Looks like a known knex/node/postgres issue: https://github.com/brianc/node-postgres/issues/442

2

The reference you link to started on 16 Sep 2013

A person in the forum you referenced with a link 7 years later replied on 25 Aug 2020--

Another option is to make your column have a type of jsonb[] rather than jsonb .

Is your error returned in node-pg:?
Since you've only reported the concluding error return without including the actual Query you used --
Is this following page relevant to how you are writing your queries?

March 30, 2021
https://azatb.com/2021/03/30/postgresql-jsonb-datatype-and-functions-linux-hint/