database caching error with query using LIKE |
[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; 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)
[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? |
Welcome Guest, Not a member yet? Register Sign In |