Is Not Null doesn't work on timestamp field

======== TEMPLATE BUG FORM ========

Wappler Version : 2.3.1
Operating System : PHP 7.2 / mySql 10.3

Expected behavior

What do you think should happen?

Should be able to use the Is Not Null condition on a timestamp field and return results

Actual behavior

What actually happens?

{"code":"42000","file":"\/public_html\/dmxConnectLib\/lib\/db\/Connection.php","line":80,"message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?)' at line 1","trace":"#0 \/public_html\/dmxConnectLib\/lib\/db\/Connection.php(80): PDO->prepare('SELECT * FROM `...')\n#1 \/public_html\/dmxConnectLib\/modules\/dbconnector.php(90): lib\\db\\Connection->execute('SELECT * FROM `...', Array)\n#2 \/public_html\/dmxConnectLib\/lib\/App.php(163): modules\\dbconnector->single(Object(stdClass), 'query1')\n#3 \/public_html\/dmxConnectLib\/lib\/App.php(128): lib\\App->execSteps(Object(stdClass))\n#4 \/public_html\/dmxConnectLib\/lib\/App.php(98): lib\\App->execSteps(Array)\n#5 \/public_html\/dmxConnectLib\/lib\/App.php(71): lib\\App->exec(Object(stdClass))\n#6 \/public_html\/dmxConnect\/api\/scratch\/null.php(8): lib\\App->define(Object(stdClass))\n#7 {main}"}

How to reproduce

  • Detail a step by step guide to reproduce the issue
  • A screenshot or short video indicating the problem
  • A copy of your code would help. Include: JS, HTML.
  • Test your steps on a clean page to see if you still have an issue

Create a query action in server connect and use the Is Not Null condition on a timestamp data type field, then execute.

Perhaps this is related to my other bug report:

Community Page
Last updated: