SQL Ledger can’t view Open POS Invoice

On Line 2333 of SL/Form.pm add single quotes to $expires variable

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

Error:
**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.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

You May Also Like…

Docker on Fedora 32

Docker on Fedora 32

Commands to run to get moby-engine running on Fedora 32 # as root or sudo'd dnf install grubby grubby...

PDF Poster

PDF Poster

Start with a wide long image. This is just a screen shot of my desktop. widescreen.png Convert it to postscript using...