Most common reason Query Editor fails to recognize tables?
What trouble shooting should happen to find out why the query editor works in some instances (sites) and not others (new site based on old).
I have a new site that I am recreating as a derivative of a currently working site. I've created a new MySQLi connection so as to better isolate the site from others sharing the same DB.
But the new site works in the Bindings Panel but fails to load tables into the Query Editor (see screens)
I've compared the Database files and saw the older one set the Charset. Adding this did not solve the problem.
Any ideas on how to solve this?