Re: [Ledger-smb-users] upgrading from sql-ledger

On Friday 11 July 2008 11:56:06 Bob Miller wrote: > I don't have ROSE installed, no, I was in the process of reading about What linux distribution are you using? On Gentoo I use the g-cpan http://www.gentoo.org/proj/en/perl/g-cpan.xml http://www.perlfoundation.org/perl5/index.cgi?rose_db_object -

Re: [Ledger-smb-users] Error when entering a sales order [SOLVED]

Thanks Jeff, Armed with a backup of the database, I re-ran transactions_foreign_key_fix.sql. However, I needed to fix the fix first (this might be why I have the problem - I must have missed these errors when I ran it the first time). In the fix, there are a lot of DDL commands of the form

Re: [Ledger-smb-users] Error when entering a sales order

richard wrote: > DBD::Pg::st execute failed: ERROR: duplicate key violates unique > constraint "transactions_pkey" > Error! > INSERT INTO oe > (id, ordnumber, quonumber, transdate, vendor_id, > customer_id, reqdate, shippingpoint, shipvia, > notes, intnotes, curr, closed, department_id, > employe

[Ledger-smb-users] Error when entering a sales order

Hi List, I haven't used LedgerSMB for entering sales orders before now, but I'm wanting to make a start. However, when entering the first one, I get this error: DBD::Pg::st execute failed: ERROR: duplicate key violates unique constraint "transactions_pkey" Error! INSERT INTO oe (id, ordnum