Custom Query Builder Returning Error MySQL/PHP

Wappler Version : 3.6.1
Operating System : W10
Server Model: PHP
Database Type: MySQL
Hosting Type: Linux/shared

Expected behavior

select ifnull(max(updated_at), '1970-01-01T00:00:00') 'last_updated', ifnull(max(created_at), '1970-01-01T00:00:00') 'last_created' from shop_products;

The table in above query is blank. It has 0 rows. Running it returns:
image

Actual behavior

When running the same in Wappler’s custom query builder:

image
image717×447 17.6 KB

How to reproduce

Have no idea how you will reproduce this on your end.
There are 2 tables which have these two columns - created_at & updated_at.
Both columns are of type varchar(30) and store a date time value with time zone like 2020-12-29T10:51:21+01:00.
I get the same output as above for both tables.
Can give remote to check the issue if you guys are unable to reproduce this at your end.

Community Page
Last updated: