PDOException: SQLSTATE[HY000]: General error:

sadig.gulaghayev's picture

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

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

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
Technical Lead
Advomatic LLC
Great White North Office
Canada

I've the same problem with

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).

Niagara and Hamilton Region

Group organizers

Group events

Add to calendar

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week