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

["Chris Travers" <..hidden..>]

On 6/15/07, Robert Fraser <..hidden..> wrote:
> 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"
Try running the Pg-upgrade scripts manually and see where they fail.
This can be done in psql or Pgadmin III.

> 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users