Web Hosting Talk







View Full Version : SQL caching problem?


abigsmurf
03-16-2008, 09:04 PM
I recently loaded a bunch of info into a table using phpmyadmin but these entries aren't appearing when I run queries on my site. When I run a query through phpmyadmin, the new entries appear fine.

Anyone know why the database doesn't seem to be updating? I'm guessing it's an issue with caching but I'm not sure. I can't clear the cache myself as I don't have the privaliges. Is there anyway to force an update or do I have to get my provider to do it for me?

Dan L
03-16-2008, 09:08 PM
Did you double check your database connection?

I'd try asking your host to clear the query cache and temporarily disable query caching for your database while you test to see what the issue is.

abigsmurf
03-16-2008, 09:44 PM
Ah discovered what was wrong. Turns out a Wordpress Caching plugin was going haywire and caching everything SQL-wise, wordpress or not. Never done that before and the plugin had been rock solid until then.

Looks like I'll have to do a bug report...