CakePHP ACL Issue: Max_Join_Size
- by Mayank
Hi,
The build_acl action works on localhost but on the shared sever it gives the following error:
Warning (512): SQL Error: 1104: 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 [CORE/cake/libs/model/datasources/dbo_source.php, line 549]
I cannot change the MAX_JOIN_SIZE value because of the lack of admin privileges.
I read in some forum that deleting cache solves the problem, but even that's not working for me.
Thanks,
Mayank