CodeIgniter Database Query Caching Issue

Question

I enabled query caching in CodeIgniter via the application/config/database.php file and it worked. I then disabled it, and commented out the folder path. When I then re-enabled caching and un-commented the folder path, caching would not work.

I have tried other directories. This is an issue on both local, and web servers.

$db['default']['cache_on'] = TRUE;
$db['default']['cachedir'] = './application/cache/';

These is my database.php settings. I have tried removing the '.' from the beginning of the string. I have also tried removing the trailing and preceding slashes.

Any help would be much appreciated. Thank you.

Edit: I know the folder is writable as storing a full page cache works.

what exactly do you mean it does not work? any errors? have you tried to use an absolute path instead? clearing up the cache dir and trying again? perhaps enabling CI's logging could help here, too - just make sure the logs folder is writable — Zathrus Writer
– Zathrus Writer, Commented Nov 28, 2012 at 12:53
No errors whatsoever. I have tried an absolute path and still no dice. It's incredibly infuriating. I know the folder is writable as if I use $this->output->cache(100);, it writes to the folder. I emptied the cache directory too, and still nothing. Enabling logging produces no errors. — Alex McCabe
– Alex McCabe, Commented Nov 28, 2012 at 13:03
any chance you're using multiple database configurations - Environments or different DB groups (other than default) and one of them has the old setting? — Zathrus Writer
– Zathrus Writer, Commented Nov 28, 2012 at 13:06
I did, but I removed the second database configuration and it still doesn't work. I even replaced database.php just in case, and nothing. — Alex McCabe
– Alex McCabe, Commented Nov 28, 2012 at 13:11
well, then the only thing that comes to my mind it to simply try and create an empty CodeIgniter installation and use a sample DB code in the Welcome controller to see if that works at all. From that point, you should be able to tell the difference between your app and the default (for example by using comparison tool in Eclipse). — Zathrus Writer
– Zathrus Writer, Commented Nov 28, 2012 at 13:14

Marko Aleksić · Accepted Answer · 2013-12-24 11:54:44Z

10

Define the caching directory in config/database.php as follows:

$db['default']['cachedir'] = APPPATH . 'cache';

Also, make sure you directory is writable (if you are on Mac or Linux)

sudo chmod 777 -R application/cache

If still doesn't work, try explicitly turning cache on before running db queries.

$this->db->cache_on();

answered Dec 24, 2013 at 11:54

Marko Aleksić

1,5911 gold badge18 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CodeIgniter Database Query Caching Issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related