It might be a problem with the particular template or database you are using. Try to narrow it down. Does it work if you don't use a template when applying? Does it work with a different database table? Does it work on a different site with a different database connection?
It should reset things when deleting the cache file. This isn't a common problem so I can't say for sure the cause with the limited information provided. Maybe try those tests and let me know the results and I can maybe figure it out or give you more tests to try from there.