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

[anupent]

Hi @msanting,
One of the cause may be a restriction in the “MySQL row-size limit” of your server.

Can you look into this post and the discussions there for the same problem I faced last year?

Database Error (DB Error)

We have a problem under editors role as we click the archives, we get the following message 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 The hosting service says, “the reason you see this error is because your query is (apparently) too big. Unfortunately, we cannot change this setting because it helps to protect our servers against queries which will take too much server power.” …

Regards,
@anupent