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

    Query Of Queries runtime error.

    Jancouver

      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

      </cfquery>

       

       

      Any ideas?