Hi
I am getting 2 of these (vendor and customer) when I try to manually upgrade
from Sql-ledger 2.6.5 to Ledgersmb 1.1.12 :
psql:/usr/local/lib/egsql-ledger/sql/Pg-upgrade-2.6.17-2.6.18.sql:211:
ERROR: duplicate key violates unique constraint "transactions_pkey"
If I try to log on anyway, I get
Internal Server Error
The server encountered an internal error or misconfiguration and was unable
to complete your request.
And the apache error log gives:
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "char
t_pkey" for table "chart", referer: http://10.10.1.2/egsql-ledger/login.pl
[Fri Jun 15 23:30:58 2007] [error] [client 10.10.1.3] NOTICE: ALTER TABLE /
ADD PRIMARY KEY will create implicit index "acc_
trans_pkey" for table "acc_trans", referer:
http://10.10.1.2/egsql-ledger/login.pl
[Fri Jun 15 23:31:05 2007] [error] [client 10.10.1.3] NOTICE: CREATE TABLE
/ PRIMARY KEY will create implicit index "transac
tions_pkey" for table "transactions", referer:
http://10.10.1.2/egsql-ledger/login.pl
[Fri Jun 15 23:31:06 2007] [error] [client 10.10.1.3] DBD::Pg::st execute
failed: ERROR: duplicate key violates unique const
raint "transactions_pkey", referer: http://10.10.1.2/egsql-ledger/login.pl
[Fri Jun 15 23:31:06 2007] [error] [client 10.10.1.3] Issuing rollback() for
database handle being DESTROY'd without explicit
disconnect(), <FH> line 267., referer:
http://10.10.1.2/egsql-ledger/login.pl
[Fri Jun 15 23:34:53 2007] [error] [client 10.10.1.3] Premature end of
script headers: login.pl, referer: http://10.10.1.2/eg
sql-ledger/login.pl
[Fri Jun 15 23:35:08 2007] [error] [client 10.10.1.3] Premature end of
script headers: login.pl, referer: http://10.10.1.2/eg
sql-ledger/login.pl
[Fri Jun 15 23:55:24 2007] [error] [client 10.10.1.3] Premature end of
script headers: login.pl, referer: http://10.10.1.2/eg
sql-ledger/login.pl
Can anyone point me in the right direction to fix this?
Thanks
Rob
-------------------------------------------------------------------------
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-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
