sql-ledger-users

[SL] upgrade from 2.6.18 to 2.8.17

[Cliff B. <cli...@gm...>]

Hello, I'm trying to upgrade from sql-ledger 2.6.18 to 2.8.17, and
from postgresql version 8.0.8 -> 8.3.3

When I try try to upgrade through admin.pl, I get:Internal Server Error

In the apache logs, I see: Compilation failed in require at
/usr/local/sql-ledger-new/admin.pl line 85. [Sat Aug 16 17:32:45 2008]
[error] [client 192.168.1.109] Premature end of script headers:
admin.pl, referer: http://happy/sql-ledger-new/admin.pl

If I try to upgrade through log-in, I see the following:
∘ Upgrading to Version 2.8.17 ...
∘ Error!
∘ drop trigger del_vendor on vendor
∘ ERROR: trigger "del_vendor" for table "vendor" does not exist

Any suggestions as to how I can pull this off?  Do I need to take a
few intermediate steps?

Thanks,
Cliff

-- 
=======================
Cliff Brake
http://bec-systems.com

Re: [SL] upgrade from 2.6.18 to 2.8.17

[Cliff B. <cli...@gm...>]

I tried 2.6.27 and that worked fine.

I then tried 2.8.1, and still get the following when I try to log in.

Upgrading to Version 2.8.1 ...
Error!

drop trigger del_vendor on vendor
ERROR: trigger "del_vendor" for table "vendor" does not exist

Cliff

On Sat, Aug 16, 2008 at 5:42 PM, Cliff Brake <cli...@gm...> wrote:
> Hello, I'm trying to upgrade from sql-ledger 2.6.18 to 2.8.17, and
> from postgresql version 8.0.8 -> 8.3.3
>
> When I try try to upgrade through admin.pl, I get:Internal Server Error
>
> In the apache logs, I see: Compilation failed in require at
> /usr/local/sql-ledger-new/admin.pl line 85. [Sat Aug 16 17:32:45 2008]
> [error] [client 192.168.1.109] Premature end of script headers:
> admin.pl, referer: http://happy/sql-ledger-new/admin.pl
>
> If I try to upgrade through log-in, I see the following:
> ∘ Upgrading to Version 2.8.17 ...
> ∘ Error!
> ∘ drop trigger del_vendor on vendor
> ∘ ERROR: trigger "del_vendor" for table "vendor" does not exist
>
> Any suggestions as to how I can pull this off?  Do I need to take a
> few intermediate steps?
>
> Thanks,
> Cliff
>
> --
> =======================
> Cliff Brake
> http://bec-systems.com
>



-- 
=======================
Cliff Brake
http://bec-systems.com

[SL] putting a recurring transaction in the future

[Kevin B. <kb...@fr...>]

Hi,

Just a quick question.

Say I need to set up a recurring transaction - and the first invoice is 
due to go out in the future.

I.e. I want to create an invoice for the 1st September 2008 - and then I 
want to send out the same invoice every year with the next one being on 
the 1st September 2009.

Do I build up an invoice for 01/09/2008 - click on 'Schedule' - and then 
set the schedule 'startdate' to 01/09/2009 - click 'save' - then post 
the invoice.  Obviously, I'd have to remember to 'manually' email out 
the invoice on the 01/09/2008.

Or do I:

Build up an invoice for 01/09/2008 - click on 'Schedule' - and then set 
the schedule 'startdate' to 01/09/2008 (note the 2008 - same as the 
invoice date) - click 'save' - then post the invoice.

I take it  that the system will automatically send out an invoice on 
01/09/2008 - but I'm worried that the schedule will create a new invoice 
which will be a duplicate of the first for that date.

Any help gratefully appreciated.

-- 
*Kevin Bailey*