d4software / QueryTree

Data reporting and visualization for your app
http://querytreeapp.com
GNU Lesser General Public License v3.0
335 stars 121 forks source link

MySql - "No Tables Found" fix - utf8mb3 support #139

Closed Recodify closed 1 year ago

Recodify commented 1 year ago

This fixes one instance of the "No Tables Found" issue for mysql.

The problem is that the current version of the mysql package does not support utf8mb3. This issue is then made less obvious by a lack of logging. This draft PR is addresses both of these issues by adding logging and bumping the version of MySql.Data

This is not a production ready PR, it's missing tests for a start, but thought it might be useful to someone as a reference.

https://github.com/d4software/QueryTree/issues/137

d4nt commented 1 year ago

@Recodify thanks for this, I'm in the process of updating the MySQL lib on develop, but I've taken your code for query exception logging and added it.