On 6/15/07, Robert Fraser <[EMAIL PROTECTED]> 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 > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------- 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
