[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: DBD::Pg::st execute failed: ERROR: column "customer_id" does not exist



The updated Form.pm can also be downloaded from svn branches/1.2

Best Wishes,
Chris Travers

On 6/13/07, Joshua D. Drake <..hidden..> wrote:
Donna Robinson wrote:
> Hi,
>
> LedgerSMB version 1.2.5

Known problem. It is fixed in 1.2.6, ask Chris Travers for an updated file.

>
> Clicking on any of the foll (+) results in an error message:
>
> Purchases
>   + Add Transaction
>   + Creditor Invoice
>     Reports
>     + Transactions
>     + Outstanding
>
>
> Error message has the form:
> -------------------------------------------------------------
> DBD::Pg::st execute failed: ERROR: column "customer_id" does not exist
> Error!
>
> SELECT ct.name AS vendor, ct.curr AS currency, ct.id AS vendor_id,
> current_date + ct.terms AS duedate, ct.notes, ct.curr AS currency
> FROM vendor ct
> WHERE ct.id = (select customer_id from ap where 1 = 1 AND vendor_id IS NOT
> NULL order by id DESC limit 1)
> ERROR: column "customer_id" does not exist
> -------------------------------------------------------------
>
>
> Output from postgres:
> -------------------------------------------------------------
> ef-2005-6=> \d ap
>                                 Table "public.ap"
>     Column     |         Type          |                Modifiers
> ---------------+-----------------------+------------------------------------------
>  id            | integer               | not null default
> nextval('id'::regclass)
>  invnumber     | text                  |
>  transdate     | date                  | default ('now'::text)::date
>  vendor_id     | integer               |
>  taxincluded   | boolean               | default false
>  amount        | numeric               |
>  netamount     | numeric               |
>  paid          | numeric               |
>  datepaid      | date                  |
>  duedate       | date                  |
>  invoice       | boolean               | default false
>  ordnumber     | text                  |
>  curr          | character(3)          |
>  notes         | text                  |
>  employee_id   | integer               |
>  till          | character varying(20) |
>  quonumber     | text                  |
>  intnotes      | text                  |
>  department_id | integer               | default 0
>  shipvia       | text                  |
>  language_code | character varying(6)  |
>  ponumber      | text                  |
>  shippingpoint | text                  |
>  terms         | smallint              | default 0
> Indexes:
>     "ap_pkey" PRIMARY KEY, btree (id)
>     "ap_employee_id_key" btree (employee_id)
>     "ap_id_key" btree (id)
>     "ap_invnumber_key" btree (invnumber)
>     "ap_ordnumber_key" btree (ordnumber)
>     "ap_quonumber_key" btree (quonumber)
>     "ap_transdate_key" btree (transdate)
>     "ap_vendor_id_key" btree (vendor_id)
> Rules:
>     ap_id_track_i AS
>     ON INSERT TO ap DO  INSERT INTO transactions (id, table_name)
>   VALUES (new.id, 'ap'::text)
>     ap_id_track_u AS
>     ON UPDATE TO ap DO  UPDATE transactions SET id = new.id
>   WHERE transactions.id = old.id
> Triggers:
>     check_department AFTER INSERT OR UPDATE ON ap FOR EACH ROW EXECUTE
> PROCEDURE check_department()
>     del_department AFTER DELETE ON ap FOR EACH ROW EXECUTE PROCEDURE
> del_department()
>     del_exchangerate BEFORE DELETE ON ap FOR EACH ROW EXECUTE PROCEDURE
> del_exchangerate()
>     del_recurring AFTER DELETE ON ap FOR EACH ROW EXECUTE PROCEDURE
> del_recurring()
> -------------------------------------------------------------
>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel