Error: column is of type json but expression is of type character varying


Error response when processing an SQL query to the database, the error suggests the input for the “tracks” column only accepts json as valid input and current input is of type character varying, however in corresponding params “$17” you can see that the input params for "tracks"column is of type JSON_OBJECT.

@henryhan117 Could you share a screenshot of the insert query as well? Also try running the query once with Prepared Statements turned off.