Enable db cache and i get a blank screen

[eluser]johnwbaxter[/eluser]
I'm trying out the DB cache, and when i enable it and then run my home page, i get a blank screen, no errors in my log and a cache file in the cache directory.

Could anyone shed some light as to why this might be happening?

p.s They are all select queries, no writes, no updates

[eluser]Michael Wales[/eluser]
Make sure you didn't cause a syntax error when you enabled the cache - that is the most likely cause.

Also, is compress_output turned on? Try turning it off, setting error_reporting to E_ALL, and refreshing the page to see if any errors come up.

[eluser]johnwbaxter[/eluser]
How would i cause this syntax error? In the config file?

I have turned compress_output off and reporting is set to E_ALL too.

Still getting the white page of death!

[eluser]johnwbaxter[/eluser]
Sorry to bump this, but i would really do with a bit of help!

I really don't know why i'm getting a blank page when i turn on db caching!

[eluser]Pascal Kriete[/eluser]
Turn debugging on and add ini_set('display_errors', 1) to your index.php file.

If that still doesn't work, put die('got here') in line by line until it doesn't print anymore - then show us the code on that line.

[eluser]johnwbaxter[/eluser]
When you say turn on debugging, do you mean the CI logs?

[eluser]Pascal Kriete[/eluser]
Yeah, that's what I was going for. Should've said error logging.

[eluser]Seppo[/eluser]
I think it could die if the cache directory is not writeable... Soem bugs were reported when CI attempts to write a folder with not enough permissions... have you set the folder and chmod it?

[eluser]johnwbaxter[/eluser]
I am testing it locally now on my mac, i have set permissions to be all writeable. I'm still having the same problem.

I get no errors in the logs or printed to the screen. Do you mean i should put die() in the model?

[eluser]johnwbaxter[/eluser]
Well it seems to be dying on this seriously complicated query i've got (which is the first query in the model)

Code:

$query = $this->db->query('SELECT page_info.page_title FROM page_info');

Further testing reveals it simply fails on any query.