CiviCRM Community Forums (archive)

Hello,

I am experiencing an unusual issue with the custom search Price Set Details for Event Participants. When I search (selecting my client's only event which uses a price set), I get this:

Database Error Code - Unknown column 'price_field_' in 'field list', 1054

And:

UPDATE civicrm_temp_custom_b455c3578f805118642783dfd0aad8c9
SET price_field_ = 1
WHERE participant_id = 106;
 [nativecode=1054 ** Unknown column 'price_field_' in 'field list']
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_temp_custom_b455c3578f805118642783dfd0aad8c9
SET price_field_ = 1
WHERE participant_id = 106;
 [nativecode=1054 ** Unknown column 'price_field_' in 'field list']

It seems quite odd that the field name should not include an ID. The price set and event registration seem to be working fine otherwise. We have about 100 registered participants at this point. My client wants to export some of the data, but this error is standing in the way. Any ideas?

Thanks in advance.

P.S. Forum admins: wrapping my error info in code tags caused me to be told "Sorry, you are not allowed to post external links." That was pretty confusing, and kept me from formatting this post in a arguably more readable way. Also, I've never failed a CAPTCHA this many times...

--
David Benton

Thanks, Lobo, for the direction. We have found a way to get at the data the client needs, and I am preparing to leave town. We are putting a pin in this issue, but I expect to revisit it later, and I will update here if I learn anything.