Skip to content

Instantly share code, notes, and snippets.

@nhooyr

nhooyr/gist:b5b0afb31171c06ad341

Created December 24, 2015 02:44
Show Gist options
  • Save nhooyr/b5b0afb31171c06ad341 to your computer and use it in GitHub Desktop.
Save nhooyr/b5b0afb31171c06ad341 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
opendmarc-reports: failed to collect domain names: ERROR: syntax error at or near "$2"
LINE 1: ...lastsent <= DATE_SUB(FROM_UNIXTIME($1), INTERVAL ($2) SECOND...
Thats the error
SELECT domains.name FROM requests JOIN domains ON requests.domain = domains.id WHERE lastsent <= DATE_SUB(FROM_UNIXTIME(?), INTERVAL ? SECOND)
Thats the query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment