Re: Error when upgrading 1.2 db to 1.3 db

[Nigel Titley <..hidden..>]

On 03/01/12 18:27, Michael Richardson wrote:
>>>>>> "Nigel" == Nigel Titley <..hidden..> writes:
>     >> 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> Has anyone had any thoughts on this? I'm still stuck.
>
> This is what I did.
> I started my psql against my database.
>
> The code at that line is: 
>
> SELECT account_save(id, accno, description, category, gifi_accno, NULL, contra, 
>                     CASE WHEN link like '%tax%' THEN true ELSE false END, 
>                     string_to_array(link,':'))
>   FROM lsmb12.chart 
>  WHERE charttype = 'A';
>
> so, I ran it like:
>
> SELECT account_save(id, accno, description, category, gifi_accno, NULL, contra, 
>                     CASE WHEN link like '%tax%' THEN true ELSE false END, 
>                     string_to_array(link,':'))
>   FROM lsmb12.chart 
>  WHERE charttype = 'A' ORDER BY accno OFFSET 0 LIMIT 1;
>
> then incrementing the "OFFSET" value until I found the problem.
>
> You may have to "delete from account;" if you have to retry things.
>
Many thanks... I'll work through and find out which account is causing
the problem.

Best regards

Nigel