Skip to content


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.

Bookmark and Share

Posted in GNU/Linux, Open Source Apps, Small Business Accounting.


0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.