Skip to main content
J
Jancouver
Participant
June 7, 2013
Question

Query Of Queries runtime error.

  • June 7, 2013
  • 1 reply
  • 695 views

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?

    This topic has been closed for replies.

    1 reply

    cherdt
    cherdt
    Inspiring
    June 9, 2013

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices