I assume you tried deleting the cache file again?
common_installation_issues.pdf
What is your OS?
Are you using a local testing server? or a remote one? I recommend using a local testing server with data assist.
what is the structure of the database, can you post the create table syntax?