By jonathanod on

I did a quick search and was unable to find this error and a way to fix it. I received this message after installing some modules and trying to activate them. If you all might have any suggestions that would be great! I did try to update to the new version of drupal but that just gave me a 500 error that was able to be corrected after a little bit of work.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drp_i21edcm47l.ctools_object_cache' doesn't exist: SELECT * FROM {ctools_object_cache} WHERE sid = :session_id AND obj = :object AND name = :name; Array ( [:session_id] => KES-0YUpPuW6wW2H-6EhseCp5Hw6BiDxCgR_JDTueHI [:object] => view [:name] => node_gallery_gallery_item_views ) in ctools_object_cache_get() (line 45 of /hermes/bosweb/web133/b1332/ipg.heritagedesigngroupf/sites/all/modules/ctools/includes/object-cache.inc).

⋅ Categories: Drupal 7.x

Comments

groovedork’s picture

groovedork commented

I have a very similar problem:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'USERNAME_betatest.ctools_object_cache' doesn't exist: SELECT * FROM {ctools_object_cache} WHERE sid = :session_id AND obj = :object AND name = :name; Array ( [:session_id] => 5LZWiayhKfMF38wr4nQFYmyG1wAfFS_xcnk87ZxkMtc [:object] => view [:name] => Upcoming_events ) inctools_object_cache_get() (line 45 of /home/USERNAME/domains/DOMAIN.nl/public_html/sites/all/modules/ctools/includes/object-cache.inc).

(username and domain changed for security reasons)

groovedork’s picture

groovedork commented

The fix is simple: go into your database editing tool (phpmyadmin), and rename the "views_object_cache" table into "ctools_object_cache".

leisurman’s picture

leisurman commented

I did a d6 to d7 upgrade and started enabling modules, as soon as I enable ctools I got errors like this:

error php PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd3.ctools_object_cache' doesn't exist: SELECT * FROM {ctools_object_cache} WHERE sid = :session_id AND obj = :objec

I looked at the sql tables on a fresh d7 site with ctools installed and compared the tables with my broken site. I was missing these 4 tables.
ctools_access_ruleset
ctools_css_cache
ctools_custom_content
ctools_object_cache

I copied all 4 tables to my broken site, and then i was able to update the db

CREATE TABLE d3.ctools_object_cache LIKE

drush3.ctools_object_cache;
INSERT INTO d3.ctools_object_cache SELECT * FROM drush3.ctools_object_cache;

CREATE TABLE d3.ctools_custom_content LIKE drush3.ctools_custom_content;
INSERT INTO d3.ctools_custom_content SELECT * FROM drush3.ctools_custom_content;

CREATE TABLE d3.ctools_css_cache LIKE drush3.ctools_css_cache;
INSERT INTO d3.ctools_css_cache SELECT * FROM drush3.ctools_css_cache;

CREATE TABLE d3.ctools_access_ruleset LIKE drush3.ctools_access_ruleset;
INSERT INTO d3.ctools_access_ruleset SELECT * FROM drush3.ctools_access_ruleset;

These updates ran afterwards
6008 - ctools_object_cache needs to be defined as a blob.
7000 - Enable the custom CSS cache handler.
7001 - Increase the length of the ctools_object_cache.obj