I have deployed Metabase on an Bitnami Ubuntu instance connect to MySql.
I use the Reference panel on the right side and can see all my tables.
However, whatever questions I am trying to build, I always get the same answer of “We couldn’t understand your question.”
It even happen when I am clicking on the Reference Panel “SHow all x rows in y”.
It seems that there is a basic issue of returning data, yet the schema was returned without any problems.
As it is a test server, the mysql connection user is root, so no permission issue should be in the way.
I have performed further test and did try to identify if there was some problem by sniffing the ajax calls between the client and the server.
If did noticed the following.
In url api/dataset, the json return always an error regardless of the timezone set in the admin panel
{“raw_query”:"",“result_rows”:0,“finished_at”:“2015-10-22T12:13:41.168Z”,“started_at”:“2015-10-22T12:13:40.779Z”,“json_query”:{“database”:2,“type”:“query”,“query”:{“source_table”:13,“aggregation”:[“rows”],“breakout”:[],“filter”:[]}},“status”:“failed”,“id”:12,“error”:“Unknown or incorrect time zone: ‘US/Central’”,“uuid”:“8416d07f-e164-42e6-8292-ce018121d265”,“row_count”:0,“running_time”:389,“version”:0,“data”:{“rows”:[],“cols”:[],“columns”:[]}}
The same error has been returned when using TimeZone setting of ‘GMT’, ‘UTC’ and ‘US/Central’ .