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. 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
