Welcome Guest, Not a member yet? Register   Sign In
database caching error with query using LIKE
#1

[eluser]dardar[/eluser]
Everything is OK with codeigniter, just if I enable database query caching it returns blank screen:

Code:
$db['default']['cache_on'] = TRUE;
$db['default']['cachedir'] = "cache";

Maybe it's only server fault?

I'm using USB webserver, windows xp 64 OS, from http://www.usbwebserver.nl/ (you can test with it easaly - it's complete portablewebserver)
#2

[eluser]dardar[/eluser]
I found, what only one query is causing error (with caching disabled everything works nice):

Code:
SELECT distinct (artist.name), artist.id FROM artist RIGHT JOIN track ON artist.id=track.artist WHERE artist.name LIKE 'g%' ORDER BY artist.name LIMIT 10

This table is quite large (~ 1 million rows), but there are only 10 results, so is there any fix?




Theme © iAndrew 2016 - Forum software by © MyBB