I'm close to tears now since I don't seem to find a solution. I'm actually working with the Acquia Dev Desktop 2 (I have to do this for a school assignment), I already installed and removed it like 7 times (also on once on a completely new and empty computer).

I have 2 major problems:

1. my caching tables keep going missing!
I get error messages like: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lisacms.cache' doesn't exist: DELETE FROM {cache} WHERE (cid LIKE :db_condition_placeholder_0 ESCAPE '\\') ; Array ( [:db_condition_placeholder_0] => schema:% ) in cache_clear_all() (line 167 of C:\Users\Lisa\Sites\devdesktop\acquia-drupal-7.38.44.6261\includes\cache.inc).

or: PDOException: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine: TRUNCATE {cache_panels} ; Array ( ) in cache_clear_all() (line167 of C:\Users\Lisa\Sites\devdesktop\acquia-drupal-7.38.44.6261\includes\cache.inc).

I already tried to drop the table with querries and remaking it. That works but only for limited time, whenever I try to make changes again I have to redo the whole process. And it's literaly every caching table that disapears. When I was trying to add fields to my content type I had to drop and create the field table again and again after every field.

2. Another major problem is that I get following error message before I even do anything. When I opened my database right after I installed it (so I didn't add any other modules):

Warning in .\libraries\dbi\DBIMysqli.class.php#258
mysqli_query(): (HY000/1030): Got error -1 from storage engine

Backtrace

.\libraries\dbi\DBIMysqli.class.php#258: mysqli_query(
object,
string 'SELECT COUNT(*) FROM `projectcms`.`cache_panels`',
integer 0,
)
.\libraries\DatabaseInterface.class.php#183: PMA_DBI_Mysqli->realQuery(
string 'SELECT COUNT(*) FROM `projectcms`.`cache_panels`',
object,
integer 1,
)
.\libraries\DatabaseInterface.class.php#1776: PMA_DatabaseInterface->tryQuery(
string 'SELECT COUNT(*) FROM `projectcms`.`cache_panels`',
NULL,
integer 1,
boolean false,
)
.\libraries\Table.class.php#582: PMA_DatabaseInterface->fetchValue(string 'SELECT COUNT(*) FROM `projectcms`.`cache_panels`')
.\libraries\structure.lib.php#1250: PMA_Table::countRecords(
string 'projectcms',
string 'cache_panels',
boolean true,
boolean false,
)
.\libraries\structure.lib.php#1131: PMA_getValuesForInnodbTable(
array,
boolean true,
double 3948544,
)
.\db_structure.php#166: PMA_getStuffForEngineTypeTable(
array,
boolean false,
boolean true,
boolean false,
double 3948544,
double 0,
)

I have no clue what this means. The "(HY000/1030): Got error -1 from storage engine"-error keeps popping up whenever I try to enable/disable/install a module or theme.

If someone could help me with this that would be awesome!

Comments

myke’s picture

What Drupal distro are you using..? What modules..? Did you notice any error messages when running the installer..?

mathobe’s picture

The installer never gave any errors while running it. I tried to install it multiple times always with the same result. For the installation I used acquia dev desktop, and I installed acquia.
I installed some basic modules like: pathauto, webform, link, google analytics, ckeditor, views,backup and migrate, panels, metatag,...

But when I installed drupal directly on my webserver it didn't give any errors so the problem is "fixed". It's just the local installation (with acquia) that doesn't work :)

but thank you very much for replying!

myke’s picture

I see two different database names, is that from two different install attempts..?

barmint’s picture

I just created a website using plain Drupal v7.39, through Acquia Dev Desktop 2.

When I try to create a Basic Page, and if I include a Menu link, when I press Save, I get this error:

"PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'project1.cache_menu' doesn't exist: DELETE FROM {cache_menu} WHERE (cid LIKE :db_condition_placeholder_0 ESCAPE '\\') ; Array ( [:db_condition_placeholder_0] => links:main-menu:% ) in cache_clear_all() (line 167 of C:\Users\Bill\Sites\devdesktop\drupal-7.39\includes\cache.inc)."

I do not get the error when creating a Basic Page without a Menu link.

I do get the same error if I edit a Basic Page to add a Menu link.