[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: 1.0.0 -> 1.1.1d upgrade issues
- Subject: Re: 1.0.0 -> 1.1.1d upgrade issues
- From: Michael Schultheiss <..hidden..>
- Date: Mon, 23 Oct 2006 13:52:05 -0400
Chris Travers wrote:
> Ok. Let me explain this error and what it means. It means that a
> financial transaction is posted against an account that currently does
> not exist. Most likely, this was created againt an account that was
> deleted, or a bug in the software has caused it to post against a
> non-existant account.
> So the first question is:
> 1) What is the transaction? What account should it have been posted under?
> To determine this, in psql, pgadmin, or the like, run the following query:
> select * from acc_trans where chart_id = 10030;
This brings up 87 results.
> Then run:
> select * from transactions where id IN (select trans_id from acc_trans
> where chart_id = 10030);
id | table_name
10104 | chart
10128 | chart
10136 | chart
> Then you can run similar queries against the statements here.
> Note that you can get 1.0.0p1 releases from Sourceforge if you need to
> go back. I think you have to expand the tree or click older releases.
I tried accessing them this weekend. The University of Kent mirror was
the only one that had the files but I was unable to access them this
weekend. I'll try again.