TRUNCATE error -1 obliterating my sites I keep getting a cache related error.


  PDOException: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine: TRUNCATE {cache} ; Array ( ) in cache_clear_all() (line 165 of C:\Program Files (x86)\EasyPHP-DevServer-14.1VC9\data\localweb\projects\web2\includes\cache.inc).


The issue is tied to the query file. The fix is to replace TRUNCATE with DELETE FROM in a query.inc file. That's all fine and dandy, and that error is gone. But, now I have a new one: The site is completely broken and thinks that the cache database folder still exists, which prevents me from importing the backup database, even if I drop the whole database. 
In short: Backups are useless, as this error seems to do some heavy damage. As well, it shuts down the EasyPHP server.

To make things even worse, I was going over the huge site-crashing error report I just got, and it looks like the fix doesn't even work.  

In regards with the above, I think it worked, but something else tied in with it is causing more cache errors. 


  PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'webone.cache_views_data' doesn't exist: DELETE FROM {cache_views_data} ; Array ( ) in cache_clear_all() (line 165 of C:\Program Files (x86)\EasyPHP-DevServer-14.1VC11\data\localweb\projects\webONE\includes\cache.inc).


I applied the fix I first mention to a new website, as a preventative this time. Low and behold, it came back on the first module install.
Why are these paths different when you talk about "your project":

path 1:
C:\Program Files (x86)\EasyPHP-DevServer-14.1VC9\data\localweb\projects\web2\includes\cache.inc

path 2:
C:\Program Files (x86)\EasyPHP-DevServer-14.1VC11\data\localweb\projects\webONE\includes\cache.inc)

This smells like something is horribly misconfigured.

I've made dozens of drupal sites, typically under Linux, but I have used WAMP myself in the past (not EasyPHP-DevServer). This makes me think it's an issue with the EasyPHP-DevServer and not drupal itself.

While you may not be familiar with it ... have you tried like copying your site files and DB to a Drupal 7 Quickstart project VirtualBox virtual machine, or  DrupalPro ... another off the shelf VM drupal-in-box ...