Support

January 12, 2017 at 4:40 pm

The email received about the now-missing registration contained an URL with the following: REG_ID=1726 – I’ve checked, and that is definitely missing from the esp_registration table.

January 13, 2017 at 8:27 am

4.9.21.p

Is this a known bug with some older versions?

We’ve used EE for a couple of years now and this is the first time this has happened.

We did start using the multiple event registration add-on which I suspect (with no evidence!) may be related.

Thanks

Jonathan

January 15, 2017 at 2:22 pm

I’ve upgraded to the latest versions and will hope for the best.

Perhaps it would be good if the software marked the database rows as unneeded, rather than deleting them, to help with problem solving in cases such as this.

I wonder if that could be suggested to the developers.

January 16, 2017 at 12:08 pm

You’re right, I had assumed that.

The database row presumably existed when the EE email was sent out (based on the URL). It doesn’t exist any more (there are some with lower and higher IDs). How could it have disappeared?

There was no payment attached so do you think our administrator deleted it by accident (when logging in to attach a cheque payment)? She is very efficient so I doubt that.

Thanks

January 16, 2017 at 2:06 pm

Thanks.

The only lines in the access logs with “REG_ID=1726” are admin attempts to view the registration.

I deleted an old registration from trash tonight – the only line with “&action=delete_registrations” in the access log was this test one.

I couldn’t find anything that appeared relevant in the error logs.

Best wishes

Jonathan

January 16, 2017 at 2:46 pm

I think that I have the answer, and that it is a bug in the multiple events add-on.

To cut a long story short, the failure of the software to remove event 1 from the cart (after finalising registration) will in all likelihood lead the user to remove event 1 from the cart when trying to register for event 2, which in turn will lead to the software entirely deleting the registration for event 1.

I will try to run through it step-by-step, from memory:

Select a ticket for event 1. Select invoice as payment method and click “finalise registration”. This creates a row in the registrations table (e.g. 1742).

Then select a ticket for event 2. At this point a message comes up stating that there are two items in the cart. These relate to event 1 and event 2. At this point only event 2 should be in the cart.

Remove event 1 from cart (as any normal user would do). At this point only event 2 remains. Select invoice as payment method and click “finalise registration”. This creates a row and the registrations table (e.g. 1743).

The TXN_ID field in rule 1742 is changed to 0. Shortly after that the row is deleted. I guess that this is done by the “remove_registration” function in EED_Multi_Event_Registration.module.php, which is called from the “verify_tickets_in_cart” and “adjust_registration_quantities” functions:


protected static function remove_registration( EE_Transaction $transaction, EE_Registration $registration ) {
if ( $registration instanceof EE_Registration ) {
$transaction->_remove_relation_to( $registration, 'Registration' );
$registration->delete();
return true;
}
return false;
}


The user in due course receives “registration pending payment” emails in relation to each of the two events.

When he clicks on the URL in the email for event 1 he gets this message:

The following errors have occurred:
Your Registration and Transaction information could not be retrieved from the db.
Your Registration and Transaction information could not be retrieved from the db.

And event 1 does not show up on the admin pages either.

January 16, 2017 at 4:57 pm

I know it should, but it doesn’t.

Perhaps it hasn’t been tested properly with the “invoice” payment method (it’s a method which doesn’t involve any payment, so may be different to the others).

I replicated the problem using Edge 14 browser, EE 4.9.25.p, MAR 2.0.11.p, Stripe 1.0.14.p, Mover 1.0.0.p, Table View 1.3.5.p.

January 17, 2017 at 1:25 am

Cheers. I can believe that more easily. Before I get on to the hosting company – what method does EE use to clear the session?