CakePHP Permissions, works fine on local server, but fails after upload.

Question

I created a website with CakePHP, set up all of the permissions so guests could view certain parts, and members only in certain areas, all with an administration panel.

Whenever I test this on my local testing server, it works perfectly, if I login I can view the content, if I logout, I can't. However, when I upload exactly the same files and upload and import the database, it fails to work, it just disallows all member access regardless of if you're logged in or not, this even applies to administrators.

I'm not sure what's going on here, any help would be appreciated. If you need any more information, just ask.

Regards, Alz454.

Answer 1

Okay, I've figured out what was wrong with it with a little help. Thank you.

Answer 2

Enable debugging in the config.php file, setting it to '2' instead of '0', this then allowed me to see what exactly was going wrong with the database, I found out that MYSQL_BIG_SELECTS was not set to 1 by default, so I had to add into the db_acl.php "$db->query('SET SQL_BIG_SELECTS=1');".

Can't believe I missed something that simple.