[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: "Cannot prepare error statement" error



I saw symptoms like this when chasing the unreferenced scalar issue.  Since I migrated to a box with perl5.8, this has not happened...

-----Original Message-----
From: David A. Bandel <..hidden..>
Reply-To: ..hidden..
To: ..hidden..
Subject: Re: [Ledger-smb-users] "Cannot prepare error statement" error
Date: Mon, 11 Aug 2008 09:14:40 -0500

On Mon, Aug 11, 2008 at 8:33 AM, TD <..hidden..> wrote:
> I'm not sure how much this is a ledgersmb issue and how much it's a psql /
> Perl issue.
>
> After working successfully for an hour or two, anything I click on in ledger
> smb says:
>
> Error!
>
> menu.pl:88: Cannot prepare empty statement at /usr/lib/perl5/DBD/Pg.pm line
> 247.
>
> Postgresql 8.3 log reports:
> 2008-08-11 14:16:31 BST LOG:  could not receive data from client: Connection
> reset by peer
> 2008-08-11 14:16:31 BST LOG:  could not receive data from client: Connection
> reset by peer
> 2008-08-11 14:16:31 BST LOG:  unexpected EOF on client connection
> 2008-08-11 14:16:31 BST LOG:  unexpected EOF on client connection
>
> I log out and in, and it works.  Any ideas?
>

Check how long you are logged in for in your preferences.  Perhaps the
software logged you out.  I believe the default is 3600 (which in
seconds is 1 hour).  I always change mine to 43200 (which is 12 hours,
86400 being 24 hours).

Ciao,

David A. Bandel
Bob Miller
334-7117/633-3760
http://computerisms.ca
..hidden..
Network, Internet, Server,
and Open Source Solutions