Successful upgrade; now I have a few questions.

[Peter McKenna <..hidden..>]

After a bit of mucking around (and manually deleting over 2500 invoices,
see below) I managed to successfully upgrade from LSMB 1.1.0 to LSMB
1.2.7 and it looks good, but now I have some questions.

1. Backup to file seem to work, at least it seems to produce a file that
looks to be in a compressed format, but how do you restore them? All my
efforts with pg_restore just get a "[archiver] out of memory" error. I
can find nothing in the manual about backups and restoration, which
seems to be a rather important administration task. Googling produced no
relevant leads and I can't find anything on the wiki about
backups/restore.
For now I sticking with my tried and tested method of doing backups
using
..hidden..:/home/user$ pg_dump -C -f dbname-1.2.0-12082007.sql
bittltd
..hidden..:/home/user$ pg_dump -C -f ledgersmb-1.2.0-12082007.sql
ledgersmb
I'm comfortable with restoring from these.

2. I take it the system is not too tolerant to changing date or number
formats. When I tried this I got errors about the datefield being out of
range and a hint to change the 'datestyle'. Nothing fixed the problem
which progressively affected more screens and I had to recreate the DB
from a backup (plaintext backup not the compressed 1.2.7 version).

3. I have one AP transaction (paid) where I posted my payment from the
wrong account. Every attempt to try and delete this transaction or
change the account from which the payment is made results in the
following error.
================================================================
DBD::Pg::db do failed: ERROR: syntax error at or near ","
LINE 6: VALUES (?, ?, ?, ?, ?)
^
Error!
menu.pl:88: Can't call method "execute" on an undefined value at
LedgerSMB/IR.pm line 855.
================================================================
The problem is I don't know which value it refers to. I think it's
complaining about this piece of code from IR.pm
================================================================
INSERT INTO acc_trans 
(trans_id, chart_id,
amount, transdate, 
project_id)
VALUES (?, ?, ?, ?, ?)|;
================================================================
but I don't understand the system well enough to know whether this is a
problem or not. 
Can anyone shed any light on this?

4. One thing that might be worth adding to the INSTALL instructions is a
little reminder about things not working with the apache2-mpm-worker
package. Ubuntu Feisty seems to install this by default (I don't know if
Debian does as well), but I can only get things going with
apache2-mpm-prefork. I actually built a testbed machine to test this
upgrade and was reminded of this problem. There is something about this
in another email from some months ago, but it can be a bit of a show
stopped and there is no obvious cause or warnings about it.

5. Are there plans to have a restore option in the menu?

6. Where has the lock system button gone in admin? Is this not needed
any more?

7. One more minor question. Why do the backup file get a *.sqlc
extension? pgAdmin understands restoring from files of type .backup. Any
reason to use .sqlc?

Other than a few minor points I'm glade I made the upgrade and really
appreciate all the work the developers have put into this. Thanks in
advance for your advice.
Best Regards,
Peter

Message: 2
> Date: Thu, 26 Jul 2007 21:14:40 -0700
> From: "Chris Travers" <..hidden..>
> Subject: Re: [Ledger-smb-users] Multiple Invoice entries after Print
> 	and Post
> To: ..hidden..
> Message-ID:
> 	<..hidden..>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> On 7/26/07, Peter McKenna <..hidden..> wrote:
> >
> >  Hi,
> > I'm currently using version 1.10. I normally don't print and post vendor
> > transactions, just post, but when entering one today I accidently hit 'print
> > and post'. Nothing happened for some time and I eventually had to close
> > Ledger SMB and log in again.
> > To my absolute horror I found that multiple clones of the invoice had been
> > posted! I had to reboot to stop it creating more clones. Over a 1000 of
> > these clone invoices were created and are screwing up my books. I am now
> > having to manually delete them one at a time. Does anyone know a quicker way
> > to do this than via the AP reports list?
> >
> 
> This problem has been corrected in the latest version.  Please upgrade :-)
> 
> As for correcting your books, this is likely to be a little bit of a
> problem.  Fortunately, I don;t expect there to be much of an issue here, and
> I would be happy to help you (or anyone else bitten by this problem) on
> IRC.  I will be there starting on Sunday afternoon my time.  I expect I am
> there often enough that people in any time zone will find me eventually :-)
> 
> I don't want to release a fixme script because there are some corner COGS
> issues I am worried about.
> 
> That is the #ledgersmb channel on Freenode.net.
> 
> Best Wishes
> 
> Cheers,
> > Peter
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >>  http://get.splunk.com/
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >