Free Android CakePHP GMaps Articles by Bali Web Design

August 28, 2013

Problem with MAX_JOIN_SIZE using Cakephp

Filed under: cakephp,php — admin @ 8:07 am

I got strange error message when trying to upload to remote server. My client buy hosting and probably a shared hosting. The error message is this

Error: SQLSTATE[42000]: Syntax error or access violation: 1104 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

So i start to figure out, i believe this is related with server setting because the application run correctly locally without any error. So after google, i found fast solution to fix this problem

Edit /lib/Cake/Model/AclNode.php and add this line text after line 112. I am using cakephp 2.1.3

$db->query(‘SET SQL_BIG_SELECTS=1’); //Add this line
$result = $db->read($this, $queryData, -1);
$path = array_values($path);

It seem problem only on shared hosting. I hope this articles help you