SQLSTATE[42703]: Undefined column: 7 ERROR: column " || " does not exist LINE 1: ..." = "users"."id") as "user", (select last_name || " || " || ... ^ (SQL: select "fireunion_blogfront_authors".*, (select surname::VARCHAR || ' || ' || name from "users" where "fireunion_blogfront_authors"."user_id" = "users"."id") as "user", (select last_name || " || " || first_name from "backend_users" where "fireunion_blogfront_authors"."admin_id" = "backend_users"."id") as "admin" from "fireunion_blogfront_authors" order by "user" desc limit 20 offset 0)

Getting this error with PostgreSQL 9.6.5 and Blog Front 1.1.3 on OctoberCMS 422 when I try to access the delegated authors page. The following changes to fields.yaml and coloumns.yaml of the Author controller fixed that.

fields.yaml

14: select: concat( surname, ', ', name)
20: select: concat( last_name, ', ', first_name)

columns.yaml

17: select: concat( last_name, ', ', first_name)

Thank you silverxanga for the fix. I will push out update today.

Last updated 6 years ago