SQLSTATE[42883]:Undefined function: 7 ERROR operator does not exist: character varying ->> unknown LINE 1: .unt(*) as aggregate from "food_types" w

Omar ghazy 0
Viewed 30

I built a laravel project, and i made it to work with multible language Ar, En so i make column in my table on database take array {ar, en} by using spatie package, it works on my local server xampp , but when i upload my project on heroku my project works in regist and login, but when i add something in database this error occures , so what it is the solution of this problem,,

enter image description here

enter image description here SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying ->> unknown LINE 1: ...unt() as aggregate from "food_types" where "type"->>'ar' = ... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. (SQL: select count() as aggregate from "food_types" where "type"->>'ar' = fdsf and "id" <> )

mysql php laravel
1 Answers

I think there is something wrong in your query, I noticed that you appended this arrow > to your query in the where condition could you print out the queries?

Judge Jules0
Related