A Database Error Occurred

Error Number:

ERROR: operator does not exist: bigint = text LINE 3: LEFT JOIN "res_store" "store" ON "store"."id"="coupon"."stor... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

SELECT "coupon".*, "store"."name" as "store_name", "category"."name" as "category_name", "services"."service_name" FROM "coupon_code" "coupon" LEFT JOIN "res_store" "store" ON "store"."id"="coupon"."store_id" LEFT JOIN "services" "services" ON "services"."service_id"="coupon"."service_id" LEFT JOIN "res_category" "category" ON "category"."id"="coupon"."category_id" WHERE "coupon"."active" = 1 AND "coupon"."coupon_type" = 3 AND "coupon"."deleted" = 0 ORDER BY "coupon"."name" ASC

Filename: models/Coupon_model.php

Line Number: 56