PDOException: SQLSTATE[HY000]: General error:

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
sadig.gulaghayev's picture
Posted by sadig.gulaghayev on May 29, 2013 at 6:22pm

Hi All,
I use sqlite for my drupal site and recently I got the following error message:

PDOException: SQLSTATE[HY000]: General error: 11 database disk image is malformed: DELETE FROM {cache} WHERE (cid LIKE :db_condition_placeholder_0 ESCAPE '\') ; Array ( [:db_condition_placeholder_0] => theme_registry% ) in cache_clear_all() (line 163 of /web/shtml-docs/ols-apps/includes/cache.inc).

I researched a lot and all of the articles telling to increase/change MySQL. But I do not use MySQL. Is anyone knows how can I fix it.
I highly appreciate any suggestions!

Thanks,
Sadig

Comments

Blank screen

Posted by sadig.gulaghayev on May 29, 2013 at 6:28pm
sadig.gulaghayev's picture

I forgot to tell you that, and now I am getting white/blank screen.

Thanks,
Sadig

Make sure that the sqlite

Posted by dalin on May 29, 2013 at 7:08pm
dalin's picture

Make sure that the sqlite database is not being managed by SVN or Git (or any other VCS). Then you may need to do something like this to recover it:
http://techblog.dorogin.com/2011/05/sqliteexception-database-disk-image-...

--

Dave Hansen-Lange
Director of Technical Strategy, Advomatic.com
Pronouns: he/him/his

I've the same problem with

Posted by guoqiang on February 25, 2014 at 3:59pm
guoqiang's picture

I've the same problem with sqlite with my new site. I can still look the site, but i can't manage it.

so i have do what u have said, now this problem it's clear.

othewise, there is a new problem when i do clear all cache.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 column aid is not unique: INSERT INTO {actions} (aid, type, callback, parameters, label) VALUES (?, ?, ?, ?, ?); Array ( [0] => comment_publish_action [1] => comment [2] => comment_publish_action [3] => [4] => Publish comment ) 在 actions_synchronize() (行 297 在 /home/content/51/3655551/html/2lisi/app/includes/actions.inc).