Hi, when I do a dynamic element on my page that is based on a SQL query (for example, a Bootstrap table generator or a dynamic dropdown), no data is populated either in Wappler or in the browser. However, the column names can be retrieved, just not the values.
Chrome shows me the following error - I am using a MySQL database. Is it a permissions/access problem? “Test connection” in Wappler shows no issues.
I followed the instructions to troubleshoot from this link (https://docs.wappler.io/t/debugging-server-connect-errors/2857) and found the additional error details as follows:
Edit to add more background if useful:
My SQL database is hosted locally - see connection parameters:
I’ve matched this in the Wappler setup (tried both “localhost” and “127.0.0.1” as host name and both have the same result):
Last updated: