I noticed the following behaviour when trying out Commons (commons-7.x-3.0-beta1-core).

Visit the Events page
'Attend' the Ribfest
Click 'Cancel' to change your mind and...

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'commons.cache_entity_registration' doesn't exist: DELETE FROM {cache_entity_registration} WHERE (cid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 2 ) in cache_clear_all() (line 176 of C:\d7\local\commons\includes\cache.inc).

I noticed also that clicking 'back' on the browser and then clicking 'Cancel' a second time successfully cancels your attendance.

CommentFileSizeAuthor
#7 1867318.registration.entity_cache_support.7.patch565 bytesjpontani
#7 1867318.commons.registration_entity_cache_path.7.patch588 bytesjpontani
#9 1867318.commons.registration_entity_cache_patch.9.patch585 bytesjpontani

Comments

user654’s picture

user654 commented

.

Anonymous’s picture

Anonymous (not verified) commented

Same here. Tracked it down to registration module not supporting entity cache properly.

I've posted a patch, if you apply that to the registration module then it works ok. Here it is:

#1867564: Update Entity cache support

geigerg’s picture

geigerg commented

Same here. Install time patch from #2 applied.

PDOException: SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Ungültiger Objektname 'registration_type'.: SELECT base.[id] AS [id], base.[name] AS [name], base.[label] AS [label], base.[weight] AS [weight], base.[locked] AS [locked], base.[data] AS [data], base.[status] AS [status], base.[module] AS [module] FROM {registration_type} base; Array ( ) in EntityAPIController->query() (line 152 of C:\inetpub\wwwroot\profiles\commons\modules\contrib\entity\includes\entity.controller.inc).

ezra-g’s picture

ezra-g commented
Title: PDOException: SQLSTATE[42S02]: » PDOException Canceling event registration with Entity Cache
ezra-g’s picture

ezra-g commented
Priority: Normal » Major

Bumping priority to "major" so we can address this before 3.0.

jpontani’s picture

jpontani commented
Assigned: Unassigned » jpontani
jpontani’s picture

jpontani commented
StatusFileSize
new 1867318.commons.registration_entity_cache_path.7.patch588 bytes
new 1867318.registration.entity_cache_support.7.patch565 bytes

Attached is a patch that fixes the Registration module to properly support entitycache. The issue is the entity info was not properly adding the entity cache config to the return array.

Also attached is a patch for commons makefile to include the patch until it gets applied to the Registration module.

See latest comment, didn't see the patch in the linked issue from #2.

jpontani’s picture

jpontani commented
Status: Active » Needs work

#7 may be pointless. See #1867564: Update Entity cache support. Will create a commons patch to include that patch instead of mine.

jpontani’s picture

jpontani commented
Status: Needs work » Needs review
StatusFileSize
new 1867318.commons.registration_entity_cache_patch.9.patch585 bytes

Updated commons makefile patch that has the patch from linked issue in #8.

ezra-g’s picture

ezra-g commented
Status: Needs review » Fixed

Thanks!

I updated the code comment to point to the Registration module issue that contains the patch and committed.

http://drupalcode.org/project/commons.git/commit/518fe58

ezra-g’s picture

ezra-g commented
Status: Fixed » Needs work

This breaks the Commons build because the referenced patch doesn't apply. Per #3 on that issue, the patch also needs to be re-rolled to include a hook_update_n() implementation. I've reverted the commit in #10: http://drupalcode.org/project/commons.git/commit/fb8ae00.

matt v.’s picture

matt v. commented

I've added an updated patch in the #1867564: Update Entity cache support issue.

ezra-g’s picture

ezra-g commented
Status: Needs work » Fixed

The latest patch to Entity Registration module is now included. Thanks, Matt V!

http://drupalcode.org/project/commons.git/commit/6a61fbd

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.