Error after switching to pgsql
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1: ...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
https://flareapp.io/share/LPlp21DP
I never had this issue with mariadb, but as soon as I switched to pgsql and migrating, I get this error.
Summerizing:
1) Im on production with ubuntu and postgres
2) Im running octane
3) Issue appeared after switching to pgsql. It was fine with mariadb
4 Replies
Bump
Im guessing
that is a json column?
the ""data" field in your DB
what type of field is that?
If it was a text field in mariadb it should now be a JSONB field if I'm correct
Yeah indeed. That's what I did yesterday and it worked. I altered the column to json and the error disappeared.
I did find it weird that postgres didn't do it automatically
glad you fixed it