php - PDOException: SQLSTATE[42S02] Drupal Error -


whenever try update or delete on drupal website, confronted error. when try clear cache of website error message pops up.

pdoexception: sqlstate[42s02]: base table or view not found: 1146 table 'drupal_7_38.cache_field' doesn't exist: delete {cache_field} (cid = :db_condition_placeholder_0) ; array ( [:db_condition_placeholder_0] => field:node:10 ) in cache_clear_all() (line 167 of c:\users\hasan\sites\devdesktop\drupal-7.38\includes\cache.inc). 

i have tried updating drupal using update.php error pops in middle of executing.

solved problem. deleted cache_field table using drop command , used command below create table again.

create table if not exists `cache_field` ( `cid` varchar(255) not null default '' comment 'primary key: unique cache id.', `data` longblob comment 'a collection of data cache.', `expire` int(11) not null default '0' comment 'a unix timestamp indicating when cache entry should expire, or 0 never.', `created` int(11) not null default '0' comment 'a unix timestamp indicating when cache entry created.', `serialized` smallint(6) not null default '0' comment 'a flag indicate whether content serialized (1) or not (0).', primary key (`cid`), key `expire` (`expire`) ) engine=innodb default charset=utf8 comment='generic cache table caching things not separated out...' 

hope helps!


Comments