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

Re: "Cannot prepare error statement" error



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
-- 
Focus on the dream, not the competition.
 - Nemesis Air Racing Team motto