Views handler for Participant Custom Fields broken in 3.1.beta6

[mariagwyn]

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

[mariagwyn]

I did a bit more investigating, and this may be a problem with a particular install.  On my local dev install, the custom table in question appears just fine in 3.1.1, all fields are available. On my server, the custom field set does not appear. 

I have checked to make sure that the table in included in drupal's settings.php, I have flushed ALL caches multiple times.  A small set of custom tables are being picked up by the view, but not all of them.

Any suggestions as to something that might not have upgraded correctly (I think that my server was a beta6 to 3.1.1 upgrade whereas my local was a 3.0.3 to 3.1.1)?  Anything I can check?  This is utterly mystifying to me, but I have enough data on the server that I really don't want to just go back to the 3.0.3 backup and then upgrade again.

Thanks in advance!
Maria

[Donald Lobo]

try running:

truncate civicrm_cache;

on your civicrm database.

lobo

[mariagwyn]

nope.  truncated all cache tables in drupal and civi database.  All my event/participant custom field groups are missing.  But not on my local server.  totally weird. I even deleted, redownloaded and reinstalled civi 3.1.1.  I am not even sure how to go about looking for the problem.

[mariagwyn]

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. 

[mariagwyn]

I have tried to import clean DBs on both local and server.  In all cases, the handler is broken.  Even when I reimported the local DB which was working earlier.  I tried importing/exporting with different software, no luck.  I also can't run the DB Tools b/c it gives an error each time ("unrecognized arguments after database name"). 

Views is simply not picking up any event/participant related custom fields. 

Any ideas?  Can someone look at the DB?  Anything?

[Donald Lobo]

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]

Fair enough.  I am noticing a number of new files in the drupal/views/civicrm folder, some of which are related to Events.  Perhaps this is the source.  If I figure anything out, I will post.  Until then, I will wait on Jim.

[Blake]

@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.

[mariagwyn]

nope.  sorry.  mystified b/c there is nothing after the DB name.  sigh.

[Blake]

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

[mariagwyn]

did that too.  didn't work.  let me know if you figure something out!

[Blake]

Rebuilding the DB schema worked for me. Good luck.