Re: [SL] Re-generating Year End For Prior Years

[Armaghan S. <sa...@le...>]

On 2/12/09, Rich Shepard <rsh...@ap...> wrote:
>    I thought so. They're duplicated, too, so the entire system is a mess and
> I have to quickly straighten it all out.

Look into the database tables directly and let us know if these
transactions are duplicated in the database too.

I think there is a duplicate id in chart (or somewhere else). This
will be confirmed if the transaction is not duplicated in table
(acc_trans) and only appears so in sql-ledger.

Duplication in chart can be confirmed using the following query.

                SELECT id, 'chart' AS table, COUNT(*) AS count
                FROM chart
                GROUP BY 1,2
                HAVING COUNT(*) > 1

I have a small script (LedgerDoctor) which does a number of health
checks (actually sql queries) on your database. It does not correct
any issue but you can do that yourself once you know where the problem
is. (All queries in the source are documented so you can run these one
by one yourself if you like)

I am sending you this script off-list. (Anyone else interested, let me
know. It is free for the list.)

Regards

-- 
http://www.ledger123.com/

- Free SQL-Ledger Hosting
- Documentation wiki
- Virtual appliances
--