PHP Fatal error: Uncaught Exception: DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay Query:

[ctgraham]

See a similar thread here:

DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECT=1 or SET MAX_JOIN_SIZE=#if the SELECT is okay

Any idea to solve problem with DR Error: MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay?

If you are able to access your database directly, the link describes a query you can run to find out what you MAX_JOIN_SIZE setting is for the database.

I would be curious to know how many users you have in your database, what your MAX_JOIN_SIZE is, and what the full SQL query is which failed.