[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Added item to the FAQ

Hi all;

I have added a section to the FAQ about the NULL values in chart_id error
on upgrade:

SQL-Ledger does not enforce a NOT NULL constraint on the chart_id field in
acc_trans table. Consequently, it is possible in cirtain circumstances to
insert transactions into the database with invalid information including
chart_id's. When this occurs, normally the Chart of Accounts and Trial
will fail to balance. So this is a serious problem with data integrity.
LedgerSMB prevents this by adding the NOT NULL constraing but this can cause
prevent people from migrating when they have invalid data in their

If you get an error like this the first thing to do is seek technical
whether or not you wish to continue the migration. In general the providers
support for LedgerSMB and SQL-Ledger will all be able to help. Unfortunately
because this problem involves information loss, no solution can be automated
without invalidating your accounting information. 

Best Wishes,
Chris Travers

mail2web - Check your email from the web at
http://mail2web.com/ .