[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: System->taxes Database error
- Subject: Re: System->taxes Database error
- From: "Nick Prater" <..hidden..>
- Date: Tue, 17 Jul 2012 10:07:45 +0100 (BST)
Thank you for the pointers which have allowed me to resolve the problem.
> Hmm... I wonder if sql/modules/Fixes.sql had an error in this section.
It isn't an error with Fixes.sql, which works fine.
Ultimately it was user error on my part. The problem occurred because I
had been entering the wrong postgres superuser password.
However, this password error is not trapped by setup.pl. I believe it
If you enter the wrong postgres superuser password into the initial
setup.pl, a browser box pops up asking for a user name and password. For
months now, I have been seeing this and assumed I should enter my usual
ledgersmb user name and password, which is accepted without complaint.
Having entered a valid ledgersmb username and password at the browser
prompt, you can click 'rebuild/upgrade' and will receive the 'This
database operation has completed successfully" message, even though it is
actually unsuccessful (lack of permissions).
Also in this situation, if you click 'Backup DB' a backup file will be
generated with no data in it. There is no warning that the backup file is
empty and from a user-perspective it seems as though a valid backup has
been generated. This is a nasty trap for those that don't test their
Thank you for your help with this issue. I appreciate the quick response.