2. PHPRunner General questions
  3. SQL BIG SELECT
This topic is locked

SQL BIG SELECT

 		9/22/2009 6:19:08 PM
PHPRunner General questions
N
 nickrix author

Hi there,
I need to add SET SQL_BIG_SELECTS=1; before my SELECT ......... statement in the search as i am currently getting the below error.
Error type 256

Error description 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

URL www.upickdata.co.uk/COSEARCH_list.php?

Error file /home/sites/upickdata.co.uk/public_html/include/dbconnection.php

Error line 34

SQL query select count(*) FROM COSEARCH INNER JOIN COINFO ON COSEARCH.RID = COINFO.RID where 1=1 and upper(COSEARCH.CONAME) like upper('%tesco plc%')
can anyone help?
what file do i need to edit and where too?
Im very new to all this.
Any help would be appreciated
Regards

Nick
N
 		nickrix author 9/23/2009



Hi there,
I need to add SET SQL_BIG_SELECTS=1; before my SELECT ......... statement in the search as i am currently getting the below error.
Error type 256

Error description 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

URL www.upickdata.co.uk/COSEARCH_list.php?

Error file /home/sites/upickdata.co.uk/public_html/include/dbconnection.php

Error line 34

SQL query select count(*) FROM COSEARCH INNER JOIN COINFO ON COSEARCH.RID = COINFO.RID where 1=1 and upper(COSEARCH.CONAME) like upper('%tesco plc%')
can anyone help?
what file do i need to edit and where too?
Im very new to all this.
Any help would be appreciated
Regards

Nick


I have stopped the error showing by adding the below code to the variables.php file. - is this OK to do? it seems to work.
mysql_query("set sql_big_selects=1");
Nick
J
 		Jane 9/23/2009

answered in your personal email.