Could Not Insert Record Into Database. Error

[wmilham]

When I try to access my database (through a php script) I'm receiving the following error:

Could Not Insert Record Into Database. Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Does anyone know what this is and how to fix it?

Thanks!

[BerksWebGuy]

Looks like you should check your select statement. Post it here if you want to.

[wmilham]

That was my first thought too. But I've got the same exact database (with less information on it though) running on another site (with the same php) and that one is working.

Is it possible that there's a size limit to the database that's been exceeded, which is causing the error?

[entrecon]

I did a google search and it looks like a configuration issue. Take a look at this discussion: http://community.mybboard.net/archive/index.php/thread-13023.html

appears you need to add SET SQL_BIG_SELECTS=1