CiviCRM Community Forums (archive)

As I get more and more PCPs set up by my constituents I've run into an interesting problem. If someone sets up a PCP and decides not to use an image, rather than showing nothing on the page, it will show a file I have uploaded in our backend related to an activity (not a PCP) because the entity_id is the same.

For example, Bob sets up a PCP and his pcp id is 187. The way the databases work, it does into the civicrm_entity_file table and looks for the row with a matching entity_id '187' then it takes that rows file_id in this case let's say '56'. Then it goes to the civicrm_file table and looks for the row with id of '56' and uses whatever file is in that rows URI field.

The problem is, it doesn't take into account that while yes, the entity_id matches the id of the PCP, the entity_table is not 'civicrm_pcp' it's 'civicrm_activity' or a 'custom_field_I_added'.

I've tracked the problem to PCP>Page>PCPInfo.php and I've not gotten anywhere trying to figure out how to add a statement to skip the result if it's not a PCP image. Any suggestions?

Whew, glad I wasn't the only one!! Thanks for submitting the bug report, all is well now!