Re: [SL] Timeout on AR::Reports::Outstanding

[Armaghan S. <sa...@le...>]

Martin Boese wrote:
> On Monday 04 February 2008 17:16:21 Armaghan Saqib wrote:
> (...)
>   
>> Seems really strange error. Is this happening with all reports or just
>> with these two?
>>
>> Sometimes the left joins can take the database down for simple queries
>> if there is no department/warehouse defined. But your testing does not
>> point to database.
>>
>> Which version of postgres? Try doing vacuumdb to the database
>>     
>
> I am using 8.2.5 . I actually upgraded from 8.1 just to see if this problem 
> will disappear.
> I suspect more a DBD/DBI problem... Is there any way to test SL cgi script 
> from the command line?
>
>   
Put the following in a shell script and run in the sql-ledger folder. 
Make sure that line starting with ./ar.pl till end is one line.

#!/usr/local/bin/bash

./ar.pl 
"path=bin/mozilla&login=armaghan&password=armaghan&action=continue&nextsub=transactions&summarY=1&open=Y&l_amount=Y&l
_description=Y&l_invnumber=Y&l_name=Y&l_paid=Y&l_transdate=Y&vc=customer&ARAP=AR&outstanding=1"

-- 
Purpose-built SQL-Ledger Hosting
http://www.ledger123.com/

Free trial available.
--