Upgrade duplicate key "transactions_pkey" problem SL 2.6.5 -> Ledgersmb 1.1.12

["Robert Fraser" <..hidden..>]

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