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.

You May Also Like…

Adding BCC to Divi Contact Form

The Divi contact form allows you to send to multiple email addresses by opening the properties of the form and...