Query Of Queries runtime error.
Table named users was not found in memory. The name is misspelled or the table is not defined.
Just got the error above after I connected the website to a new MySQL server. The connection is verified in Admin but I'm unable to get the database connection working. The query is working just fine with a connection to our old SQL server and it works in MySQL WorkBench.
even simple query like this
<cfquery name="GetUser" datasource="#datasource#" dbtype="#dbtype#" username="#username#" password="#password#">
You specified both a datasource and a dbtype. In this case, since you are querying a database (and not running a query-of-queries), you should leave out the dbtype attribute. See the cfquery documentation for details.