Re: POS Screen - Errors when posting an invoice

[..hidden..]

..hidden.. wrote on 05/29/2008 
06:26:21 PM:

> "Chris Travers" <..hidden..> 
> 
> defaults should be dumped.  If it is not being dumped, I wonder why.
> 
> Any errors in the PostgreSQL error log?
> 
> Best Wishes,
> Chris Travers
> >


Yes.  Here are the errors I received.  I cut out some misc. items from the 
log that were not relevant.

..hidden..:~/data> pg_dump -a tatylee > tatyleebackup.sql
..hidden..:~/data> psql -d ledgersmbtest -f tatyleebackup.sql
SET
SET
SET
SET
psql:tatyleebackup.sql:15: ERROR:  relation "acctrans_entry_id_seq" does 
not exist  setval
--------
 

psql:tatyleebackup.sql:92: ERROR:  relation "session_session_id_seq" does 
not exist  setval


psql:tatyleebackup.sql:120: ERROR:  insert or update on table "acc_trans" 
violates foreign key constraint "acc_trans_chart_id_fkey"
DETAIL:  Key (chart_id)=(10014) is not present in table "chart".
psql:tatyleebackup.sql:14190: ERROR:  duplicate key violates unique 
constraint "chart_pkey"
CONTEXT:  COPY chart, line 1: "10001    1000    CURRENT ASSETS  H       A  
   f
"
psql:tatyleebackup.sql:15151: ERROR:  duplicate key violates unique 
constraint "defaults_pkey"
CONTEXT:  COPY defaults, line 2: "audittrail    1"
psql:tatyleebackup.sql:15194: ERROR:  duplicate key violates unique 
constraint "dpt_trans_pkey"
CONTEXT:  COPY dpt_trans, line 58: "10148       10081"
psql:tatyleebackup.sql:24676: ERROR:  relation "session" does not exist
psql:tatyleebackup.sql:24677: invalid command \.
psql:tatyleebackup.sql:25122: ERROR:  duplicate key violates unique 
constraint "taxmodule_pkey"
CONTEXT:  COPY taxmodule, line 1: "1    Simple"
psql:tatyleebackup.sql:25131: ERROR:  duplicate key violates unique 
constraint "transactions_pkey"
CONTEXT:  COPY transactions, line 1: "10148     ap"