Bug #13064
Updated by Dominic Cleal over 8 years ago
hammer role filters throws below error <pre> # hammer role filters PGError: ERROR: invalid input syntax for integer: "" LINE 1: ..."id" = "filters"."role_id" WHERE (("roles"."id" = '')) ORDER... ^ : SELECT "filters"."id" AS t0_r0, "filters"."search" AS t0_r1, "filters"."role_id" AS t0_r2, "filters"."created_at" AS t0_r3, "filters"."updated_at" AS t0_r4, "filters"."taxonomy_search" AS t0_r5, "roles"."id" AS t1_r0, "roles"."name" AS t1_r1, "roles"."builtin" AS t1_r2, "roles"."permissions" AS t1_r3 FROM "filters" LEFT OUTER JOIN "roles" ON "roles"."id" = "filters"."role_id" WHERE (("roles"."id" = '')) ORDER BY role_id, filters.id LIMIT 20 OFFSET 0 </pre>