Re: PGError: ERROR: missing FROM-clause entry for table

On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne <byrnejb(at)harte-lyne(dot)ca>wrote:

> I am getting this error:
>
> PGError: ERROR: missing FROM-clause entry for table "ca_customs_entry"
> LINE 1: ..._entries"."is_cadex_transmitted" = 'f') ORDER BY
> ca_customs...
>
> The code is generated by a Ruby-on-Rails-3.0.1 ActiveRecord model:
>
> SELECT "ca_customs_shipments".* FROM "ca_customs_shipments" INNER
> JOIN "ca_customs_entries" ON
> "ca_customs_entries"."ca_customs_shipment_id" =
> "ca_customs_shipments"."id" WHERE
> ("ca_customs_entries"."is_cadex_transmitted" = 'f') ORDER BY
> ca_customs_entry.is_across_transmitted,
> ca_customs_entry.is_across_rejected,
> ca_customs_entry.is_across_accepted,
> ca_customs_entry.is_cadex_released LIMIT 5 OFFSET 0
>

Looks to me like the problem is you are trying to ORDER BY columns in
"ca_customs_entry", but there is no such table for that (don't confuse it
with "ca_customs_entries"). You need to either set a matching alias, or fix
the table name qualifier in those order by columns.

Robert Treat
play: xzilla.net
work: l42.org/lg