CiviCRM Community Forums (archive)

I just launched a site with Drupal 7 and Civi 4.2.  And we just started getting the first event signups, but some strange stuff is being added to the line-items in the purchases.  I don't think any of the users are seeing them, and they don't seem to be affecting the actual prices, but I can't figure out where there are coming from.

See the attached image.  For each purchase you see 2 lines under "Fee Level". The second line on each one is the correct one: "Event Fee - Ticket....".  The first line of each of them is totally out of left field.  Things like "Tournament Fees", "Festival Fees" and "Dinner contribution" are being entered from god knows where.  I have scoured the menus of Civi and cannot figure out where these options are coming from.

What's also strange is that when I click on any of these items in the participant list for the event, to view the actual participant page, it seems these additional items are listed with a price, but the price seems to have no actual bearing on the purchase.  For example: "Tournament Fees - Tiny-tots (ages 5-8): 1" is listed on the participant page as $800!, but this is not factored into the actual price.

Please help to preserve my sanity and let me know where these are coming from.

As a second side-question: A few of these items had gone through before I took Authorize.net out of test mode.  I removed those from the participants, but they still show up in the dashboard as "Top Donors".  Any idea how to remove those since they did not actually donate anything?

Thanks.

Chris

Not sure what you mean by what version of 4.2.  When I look in the Drupal modules list, all the civicrm modules just say 4.2.

Chris

It appears that price set field options from sample events have somehow gotten linked to this event. Not sure how that could happen :-( Might help to have some history of how this event was created. Did someone perhaps take an existing sample event ("Rainforest Cup Youth Soccer Tournament") and modify it to use for your event? Do you recall any database error messages appearing during create / edit of the event? Is this a multiple domain site? Installed from scratch as 4.2 or upgraded from earlier version ...

In any case I would expect the 'weird' fee fields to show up in the registration form based on the fact that line items are being created for them - but I think you're saying that's also not happening ??

One approach to trying to get a handle on this would be to 'convert the event fees to the explicit price set model'.  To do this click the link in this sentence (appears above the table of Regular Fees on the event's Fees tab):

"Click here if you want to configure the Regular Fees below as part of a Price Set, with the added flexibility and complexity that entails. "

Then examine the price set fields and options associated with the event from Events > Manage Price Sets.

That change should not affect the existing registrations AFAIK. Can you provide any more info about my earlier questions? Do the "weird" fields appear on the registration form (as input fields)?

If you've got access to MySQL and are comfortable w/ it - you could do some investigation in the DB - you'll want to drill down from civicrm_event.id to civicrm_price_set_entity to civicrm_price_set to civicrm_price_field to civicrm_price_field_value and see what options are linked via FK's to your event.

You may still want to delete those line_item rows in the DB - but assuming they're still being created would be good to stop that from happening first IMO.

OK, so I tried as you said, but the weird line items are still showing, even with the price set enabled for that event.

Any ideas?

Chris

There is nothing in the price sets at all on the UI side that shows these items.  I have been drilling into the DB and looked around and for instance searched for "Tiny Tots" in the DB and I have found items in the line items table and the price sets table for these things.  I think a previous programmer of mine might have orphaned some of these items in the DB when he was cleaning out some of the other test data in the DB

What's bugging me now is even when I search for something like "Tiny Tots" (one of the things showing as these weird line items) and I delete all I find in the DB directly of those, and even after I clear the caches, I STILL see them showing up as line items, not only in the transactions that have already occurred but also in new transactions!  Is there somewhere else this data might be being stored or cached than in the DB? Or is it possibly being stored in some encoded format int he DB so that when I use a search string to look for it I cannot find it?

Chris