Sorry for the delay. I have been on vacation. On Sat, Dec 31, 2011 at 9:31 AM, Nigel Titley <[email protected]> wrote: > 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
Create a heading with an accno that comes before any of your others in alphanumeric collation order, and then try again. Best Wishes, Chris Travers > > 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 ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
