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 [EMAIL PROTECTED]:/home/user$ pg_dump -C -f dbname-1.2.0-12082007.sql bittltd [EMAIL PROTECTED]:/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" <[EMAIL PROTECTED]> > Subject: Re: [Ledger-smb-users] Multiple Invoice entries after Print > and Post > To: [email protected] > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="iso-8859-1" > > On 7/26/07, Peter McKenna <[EMAIL PROTECTED]> 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 > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
