Skip to main content
Jancouver
Participant
June 7, 2013
Question

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

</cfquery>

Any ideas?

    This topic is closed to new replies. Start a new post to keep the conversation going.

    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.

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