CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Urgent!!- Disappearing Event Registrations
Pages: [1]

Author Topic: Urgent!!- Disappearing Event Registrations  (Read 1063 times)

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Urgent!!- Disappearing Event Registrations
March 22, 2010, 12:44:24 pm
I have a server that is currently running a few CiviCRM sites. I have confirmed disappearing registrations on 2 events that are accepting event registrations right now. I don't see any errors in any error logs that correspond with the dates/times of the disappearing registrations. This has happened a few times without any hard evidence, but we have started doing more tracking and confirmed that the registrations are literally disappearing from the system.

In this case, a person registered for an event and then wasn't on the list when she called with a couple of questions. The manager of the event looked at the authorize.net receipts and found the person's receipt for registration. We have since found 3 more registrants in the same event with auth.net receipts and confirmation emails sent but no entry on the list. We also have a previous participant list where at least one of these individuals is listed.

How do I begin to discover what the underlying issue is here? If I can't find the solution I am going to lose a couple of major clients. I am even willing to pay for assistance in resolving this if needed.

Thanks for your assistance,
Quint
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Urgent!!- Disappearing Event Registrations- Update
March 22, 2010, 01:48:06 pm
I think I found a clue to the issue.
The main users of the system have been manually adding participants while logged in as the admin user. They haven't been going to Add Participant, but going to the registration page as the admin and entering the information. Later if the actual person comes to the site to register for another event there is a problem because it looks like they already exist as the admin user.

I am not exactly sure how I can fix the databases to resolve this issue. Any ideas?
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Urgent!!- Disappearing Event Registrations
March 22, 2010, 02:14:34 pm

They should be using either "Add Participant" OR "registering as an anonymous user via another browser"

we should basically prevent multiple registrations of admin from overwriting each other. This has bit a few folks already and needs to be fixed.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Urgent!!- Disappearing Event Registrations
March 22, 2010, 02:38:54 pm
I have a couple of ideas on this:

1. Prevent the admin user from actually registering for an event. Treat the admin account as a special account and only allow them to add a participant, then there won't be the temptation or opportunity to make this mistake.

2. Pop up a jQuery dialog if the admin user goes to the registration page to ask if they really want to register themselves or another participant. If they choose another participant then they are re-routed to the Add Particpant page.

I think #2 would be easier to implement, but #1 might be a better solution longer term.
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Urgent!!- Disappearing Event Registrations
March 22, 2010, 04:44:26 pm
Recent versions of CiviCRM (I think 3.0+ or maybe even some 2.2.x versions) prevent any logged in user from registering more than once for an event. Regardless of whether they are an admin or any logged in user, they would be pushed back to the event information page (civicrm/event/info) and see this message:

"Oops. It looks like you are already registered for this event. If you want to change your registration, or you feel that you've gotten this message in error, please contact the site administrator. "

Your forum profile says you are running 2.2 which is pretty out of date at this point and not supported - so it would best if you can upgrade your site. If you are actually running a current version (3.1.x) and your admins are NOT getting this
Protect your investment in CiviCRM by  becoming a Member!

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Urgent!!- Disappearing Event Registrations
March 22, 2010, 05:07:20 pm
Hi Dave,

I have upgraded one of the sites and the other one will be upgraded this weekend. These sites were originally set up under 2.28. There appear to be a number of issues in the db right now because of the admin adding participants under their own account.

-Orphaned address records (contact id of NULL)
-Same billing address across multiple unrelated contacts as a result of email address not being updated when admin user enters participant info
-Participants disappearing because the admin leaves an old email address in the field and overwrites the previous contact information.

I assume the same issues could arise in 3.x if the admin user incorrectly entered users across multiple events. It becomes more of an issue when you have twice a month events.
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Urgent!!- Disappearing Event Registrations

This forum was archived on 2017-11-26.