search

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

"No tables found" in PostgreSQL connection #137

Closed Jagrutiti closed 1 year ago

Jagrutiti commented 2 years ago

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.

image

mdduarte1970 commented 1 year ago

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?

mdduarte1970 commented 1 year ago

help wanted

Jagrutiti commented 1 year ago

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.

Recodify commented 1 year ago

Having the same problem with mysql

Recodify commented 1 year ago

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.

d4nt commented 1 year ago

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.