2. PHPRunner General questions
  3. SQL Error
This topic is locked

SQL Error

 		10/8/2008 8:02:17 PM
PHPRunner General questions
J
 jalongi author

Whenever I have 3 or more tables in a join, I get the 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"
Any help would be appreciated.
Thanks,
Joe
T
 		thesofa 10/8/2008

please be so kind as to say what database you use and be sure you use PHPRunner, not ASPRunner!!!
J
 		jalongi author 10/9/2008

please be so kind as to say what database you use and be sure you use PHPRunner, not ASPRunner!!!


The database is MySQL hosted on IPOWER. I'm using PHPRUNNER 4.2. The results tab within the query definition/design also comes up with an error. If I remove one of the tables, all is ok. It doesn't matter the size since the table I am adding only has two fields in it and the other tables are also small.
Thank you.
T
 		thesofa 10/9/2008

I have had a loook here and I cannot understand what it is on about, but I expect you can pick the bones out of it.

First hit in Google.!

Just a thought, if you have set up the joins between tables as ordinary joins, you will get the number of records in each table times the number of records in the other table, adding a third table willl take it up to guite a big number, perhaps if you can use Inner joins, this will keep the number of rows in a query down.

Dunno, it might help!