CiviCRM Community Forums (archive)

I set up a view on 3.0.3 which pulls the the Title (custom - participant) field.  In 3.1beta6, I no longer have access to any custom data associated with participants.  I have custom data associated with contacts/individuals.  The participant field is now "Broken/Missing Handler".  The participant table is not coming through, and yes, the relevant table is still listed in my settings.php file.  I have made no changes to the view since the upgrade. 

What the view does is show the TITLE (custom field) of the submission, and link it to the filled-in registration form: civicrm/contact/view/participant?reset=1&id=[id_1]&cid=[id]&action=view&context=search&selectedChild=event.  It does this by plugging in the ID numbers, none of which are custom.  So, technically the view works in that the link works.  But the pretty title doesn't show up, and I really like pretty for my customers.

I am not a coder, so looking at the handler itself may not lead anywhere.  However, I have become adept at applying patches and am more than happy to test test test.

Note: This issue originated here: http://forum.civicrm.org/index.php/topic,11656.15.html.  The inability to see participant custom fields in a participant record has been solved.

Many Thanks,
Maria

try running:

truncate civicrm_cache;

on your civicrm database.

lobo

So I decided to compare the emptied cache table on the server with the same table in my local host.  The first obvious thing is that on the local host, there is a row that specifies path as "custom importableFields Participant_0_0_0_0__0__0_0e2edb24".  The 'data' column has the names of all the custom fields in question.  The cache table also has rows for other types of custom data, including other event fields.

The only two fields in the server cache table are related to contact data.

Does this explain why I am only seeing contact custom fields in the local host?  Is there a reason that perhaps not all the custom field sets are being written to the cache?

I tried to import the cache from local db to server db.  No change. 

jim seems a bit busy with a current client / project. your best bet at this stage would be to get someone from http://civicrm.org/professional/ to take a look if its urgent, else wait for a few days for jim or someone familiar with the code to take a look at it

lobo

@mariagwyn: Did you ever find a solution for DBTools error "unrecognized arguments after database name"? I'm having the same issue when trying to run the tools.

I stumbled across this post: http://forum.civicrm.org/index.php?topic=11361.0 which also addresses the issue I am having. Its been awhile since I've rebuilt the DB schema, but that's my next step. http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades

Rebuilding the DB schema worked for me. Good luck.