An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=149026&op=do StatusText: error ResponseText: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'example_dBase01.cache_entity_profile2' doesn't exist: DELETE FROM {cache_entity_profile2} WHERE (cid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 23 ) in cache_clear_all() (line 176 of /home/example/public_html/includes/cache.inc).

This is the message I get when I attempt to cancel a user account and, evidently, the account is not deleted. But the account can be deleted once the Entity Cache module is disabled.

Any fix on this? Thanks. :)

Comments

Maks’s picture

***

cachee’s picture

Title:Cannot cancel user accounts with Entity Cache enabled» Cannot creat or cancel user accounts with Entity Cache enabled

The following error is generated when a user is created:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'techwell.cache_entity_profile2' doesn't exist: DELETE FROM {cache_entity_profile2} WHERE (cid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 118 ) in cache_clear_all() (line 176 of C:\Users\Caroline\Sites\UniServer\www\techwell\includes\cache.inc).

The user is created and when you refresh the page to clear the error the system tries to create the user again causing an expected error if you create the user again.

cachee’s picture

Title:Cannot creat or cancel user accounts with Entity Cache enabled» Cannot createor cancel user accounts with Entity Cache enabled
cachee’s picture

Title:Cannot createor cancel user accounts with Entity Cache enabled» Cannot create or cancel user accounts with Entity Cache enabled
RaulMuroc’s picture

Priority:Normal» Major

It is major because basically it breaks the website, specially if it is multi-language.

This errors seems to be related to: #1387268 Profile2 entity cache table not created, causing PHP exceptions when saving/updating data

Thank you.

Dave Reid’s picture

Status:Active» Closed (duplicate)