On 31/12/11 15:40, Nigel Titley wrote: > On 31/12/11 11:26, Nigel Titley wrote: >> On 31/12/11 10:23, Nigel Titley wrote: >>> On 31/12/11 09:50, Chris Travers wrote: >>> >>>> Ok now we are getting somewhere. >>>> >>>> What username are you using to set up the database? It must be a >>>> database superuser. >>> >>> I was using postgres. However, I've now added "create database" >>> privilege to the ledgersmb user and the process has largely gone through >>> with the exception of the creation (or in my case the importation) of >>> the first user. I now seem to have a database but without any valid users. >>> >>> I'm going to roll back and start the process again as I'm not sure what >>> state the database is in. >> >> OK, this is much better (sort of). >> >> Some background: this is a new machine, postgres 8.4, Ubuntu maverick. >> I've set up a new database "testinc" using setup.pl and this largely >> works OK (with the exception of the (possible) bugs I've reported so far). >> >> I now decided to try and import the production database from our >> business, which runs on a different machine, same version of postgres >> and Ubuntu. I took the following steps: >> >> 1. Dumped a copy of the production database >> 2. Copied it across to the new machine and copied it into a new database >> "test", owned by ledgersmb. >> 3. Ran up setup.pl, logged in as ledgersmb with database "test", >> corrected some duplicate company numbers and some duplicate invoice >> numbers, imported an existing user from the "testinc" database. >> 4. Setup completed without errors. >> 5. Logged into new database successfully. >> >> All fine so far. However the "test" database is empty, no customers, no >> vendors, no transactions, no COA. >> >> A clue may be the following in the dblog_stderr file >> >> psql:/tmp/ledgersmb/1.2-1.3-upgrade.sql:30: ERROR: null value in column >> "heading" violates not-null constraint >> CONTEXT: SQL statement "INSERT INTO account (accno, description, >> category, gifi >> _accno, heading, contra, tax) VALUES ( $1 , $2 , $3 , $4 , $5 , $6 >> , $7 )" >> PL/pgSQL function "account_save" line 47 at SQL statement > > OK, I've done a bit more digging and I think the error is a result of my > having no heading accounts. I'm going to try creating one and seeing if > this fixes the problem.
No doesn't seem to have made any difference. Still the same error psql:/tmp/ledgersmb/1.2-1.3-upgrade.sql:30: ERROR: null value in column "heading" violates not-null constraint CONTEXT: SQL statement "INSERT INTO account (accno, description, category, gifi_accno, heading, contra, tax) VALUES ( $1 , $2 , $3 , $4 , $5 , $6 , $7 )" PL/pgSQL function "account_save" line 47 at SQL statement Nigel ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
