QueryTree
QueryTree copied to clipboard
d4software
"No tables found" in PostgreSQL connection
Hi
I have installed QueryTree using Docker and connected it to a database.
I saw two already existing issues but did not find the solution.
The database I have connected to has multiple schemas, each schema has multiple tables. There are also views and procedures in the database.
Hello,
I also have the same problem with PostgreSQL, and it started happening to me about 5 days ago without having changed anything in the configurations. Anyone having the same problem?
I haven't found a solution yet. Google search told me it is because of the table structure or something. I do not know what kind of structure it wants.
Ok the problem with mysql 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, but thought it might be useful to someone as a reference.
Following the recent update to .net 6, I've been testing with MySQL and Postgres, in both cases it can find the tables ok. Not seeing any tables is probably an indicate that there is something wrong with the connection settings. Remember to use the "Test Connection" button. We've also added some extra logging now which may help if you encounter this issue.
