Re: [SL] Open POS Invoice throws error

[James M. <ja...@ja...>]

James McDonald wrote:
> *I keep getting this error when I try re-open an open POS Invoice. I 
> don't know if it's a problem with my setup or if there are some issues 
> with my environment.
>
>
> **DBD::Pg::db do failed: ERROR: operator does not exist: character 
> varying < integer
> LINE 2: WHERE expires < 1204510587
> ^
> HINT: No operator matches the given name and argument type(s). You 
> might need to add explicit type casts.
> *
>
>
>    Error!
>
> *DELETE FROM semaphore
> WHERE expires < 1204510587
> ERROR: operator does not exist: character varying < integer
> LINE 2: WHERE expires < 1204510587
> ^
> HINT: No operator matches the given name and argument type(s). You 
> might need to add explicit type casts.
>
> **My environment
> Ubuntu 8.04
> SQL-Ledger *Version 2.8.13
> Postgres 8.3.0-1
>
The fix was

on line 2333 of SL/Form.pm

Single quote the $expires as shown.


 # remove expired locks
  $query = qq|DELETE FROM semaphore
              WHERE expires < '$expires'|;
  $dbh->do($query) || $self->dberror($query);