"[server] ERROR 1104: The SELECT would examine too many
records and probably take a very long time. Check your
WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT
is ok"
I am having this same problem but not sure about where to start with the fix
you stated;
"b) Edit your server and in the "MySQL Options" tab, set a reasonable value
for "Automatically limit SELECT queries to" and set the value for "Maximum
Join Size" to 1000000. That should fix these problems."
Can you be more specific about what this is referring to?
Also I notice that on the Query Menu button Query Type is disabled. Is this
supposed to be this way?
D. Vaughn Jr.
Webmaster:
The Order of Former Freemasons
"Who among us on earth is such an authority,
That when they speak, we should listen?"
