summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-10 20:55:09 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-10 20:55:09 +0000
commit9c9af181405ff3ff7bec34c9c807fd2f0ba4ba3c (patch)
tree5d1d3d936ea79940abc5064ec11eaa46b2ae780c /doc
parent987a1477f532e40f07bee7ac01d06bfb99403424 (diff)
Added documentation about the NULL values in chart_id error.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@60 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'doc')
-rwxr-xr-xdoc/faq.html16
1 files changed, 16 insertions, 0 deletions
diff --git a/doc/faq.html b/doc/faq.html
index e8fc9436..deb1fae9 100755
--- a/doc/faq.html
+++ b/doc/faq.html
@@ -1,4 +1,20 @@
<ul>
+<p><li><h4>Error on converting from SQL-Ledger:
+ERROR: column "chart_id" contains null values</h4>
+SQL-Ledger does not enforce a NOT NULL constraint on the chart_id field in the
+acc_trans table. Consequently, it is possible in cirtain circumstances to
+insert transactions into the database with invalid information including NULL
+chart_id's. When this occurs, normally the Chart of Accounts and Trial Balance
+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 databases.
+<br/><br/>
+If you get an error like this the first thing to do is seek technical support
+whether or not you wish to continue the migration. In general the providers of
+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.
+</li></p>
<p><li><h4>PostgreSQL 8.x</h4>
PostgreSQL added a restriction in v8.x that a sequence cannot be dropped
after if it is referenced by a table. However backups created with