1 Reply Latest reply on Jun 9, 2013 7:38 AM by cherdt

    Query Of Queries runtime error.


      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#">

      SELECT    *

      FROM      users




      Any ideas?