Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP Drupal Basics Site Building with the Drupal Interface Creating Content

Malith Senanayake
Malith Senanayake
12,488 Points
Posted by Malith Senanayake
Malith Senanayake
12,488 Points

Getting PDO Exception Error message when trying to save content after editing.

After editing content in About us page, when trying to save I get the following error message.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'cameron_database.cache_field' doesn't exist in engine: DELETE FROM {cache_field} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => field:node:1 ) in cache_clear_all() (line 168 of D:\xampp\htdocs\cameron-site\includes\cache.inc).

Why am I unable to save the content after editing? How to fix this bug?

Malith Senanayake
Malith Senanayake
12,488 Points
Malith Senanayake
Malith Senanayake
12,488 Points

Found answer in the link https://www.drupal.org/node/2144205 . Followed the steps pasted below, copied from one of the answers. It worked for me at first try;

I fix this error by dropping cache_field table in database and create it again, for this you can log in to your phpmyadmin and click on your database>click sql tab> run this code : '''drop TABLE cache_field ''' then click go. now run this code ; '''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 to cache.', expire int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.', created int(11) NOT NULL DEFAULT '0' COMMENT 'A Unix timestamp indicating when the cache entry was created.', serialized smallint(6) NOT NULL DEFAULT '0' COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', PRIMARY KEY (cid), KEY expire (expire) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Generic cache table for caching things not separated out...';'''

I hope it would be good for you.