TOPIC: Timing out on registration and when accessing records

Our client has a pretty busy site using DT Register. Everything was working fine this entire month up until yesterday. Now we are getting internal erros on the front end and backend.

On the FRONT, we get time outs after the user chooses indvidual or group, and if they get past the registration form it times out on one of the next confirmation/payment screens.

On the backend when we go in to edit a registration or try to do a CSV export we also get internal server errors.

We checked with our hosting provider and spent a good 4-5 hours trying to troubleshoot why all of a sudden this is happening.

Here is what the hosting company said...

Hello,

For the delay in the page loading, this looks to be caused by the plugin you are using 'dtregister' querying the database inefficiently which is creating the delay in loading the site. I recommend checking with the developer to optimize the sql query so that it doesn't stay open as long.

20:51:08 read(4, "\1\0\0\1-U\0\0\2\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\6userId\6userId\f?\0\v\0\0\0\3\3B\0\0\0W\0\0\3\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\7eventId\7eventId\f?\0\v\0\0\0\3\1\0\0\0\0Y\0\0\4\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\10userType"..., 16384) = 4602
20:51:08 poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
20:51:08 write(4, "\177\0\0\0\3select * from jos_dtregister_user where CrossFit_Affiliate like '%CrossFit Fury\\r\\n%' and payment_verified = 1 and eventId = 1", 131) = 131
20:51:08 read(4, "\1\0\0\1-U\0\0\2\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\6userId\6userId\f?\0\v\0\0\0\3\3B\0\0\0W\0\0\3\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\7eventId\7eventId\f?\0\v\0\0\0\3\1\0\0\0\0Y\0\0\4\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\10userType"..., 16384) = 4602
20:51:08 poll([{fd=4, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)
20:51:08 write(4, "\201\0\0\0\3select * from jos_dtregister_user where CrossFit_Affiliate like '%CrossFit Fusion\\r\\n%' and payment_verified = 1 and eventId = 1", 133) = 133
20:51:08 read(4, "\1\0\0\1-U\0\0\2\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\6userId\6userId\f?\0\v\0\0\0\3\3B\0\0\0W\0\0\3\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\7eventId\7eventId\f?\0\v\0\0\0\3\1\0\0\0\0Y\0\0\4\3def\rbarbells_main\23jos_dtregister_user\23jos_dtregister_user\10userType"..., 16384) = 4602

The problem with the .csv export is very similar. The same plugin is gathering up the data from the database so that it can give it to the user to download in a .csv file but the query is taking too long and the php process gets killed midway through it. I recommend optimizing this as well but if you would like we can try raising the time limit of it for you. If you have any further questions about this please let us know.

Robert Metzger
Linux Administrator
http://www.hostgator.com/
Toll Free :1-866-96-GATOR (42867)
Local :1-713-574-5287

Can you please help we have almost 4000 registration and can't have issues like these.

Thanks in advance for your timely response!

Hello. What version of DT Register are you using? I know you've been using it for a while... recently some database query related items were improved in recent releases. Then when we release version 2.7, it is even more improved... that of course is just around the corner. If you aren't using 2.6.9, you'll need to upgrade first. You won't lose any data doing so. If you still have these type of issues with 2.6.9, submit a ticket with access to your site so we can investigate further.

We are receiving 100+ registrations per day and can't afford to have anything go bad when upgrading. We made adjustments to the language files and the images.

Is there any other way to upgrade the change from 2.8.5 to 2.9 ?

Your upgrade instructions say to not overwrite the files with the old files , but rather make the changes manually.

I assume you mean you have 2.6.5 and need to upgrade to 2.6.9. Of course, backup everything, but you can't just replace files as there are new database changes. You could be done with everything within a few minutes... just depending on how many custom fields and events you have. Having changes images and language files is no big deal at all. You can quickly replace the images again after the upgrade. Quick. Then take the new language files and you'll see new language tags are added at the end of the file and marked what version they were added in. Just take all tags that are newer than your old version, copy and paste them to the end of your previously modified language files. No prob

After you uninstall and reinstall, you'll need to: re-save DT Reg configuration, making note of new parameters and making sure you set them as needed; open and re-save all custom fields as there are a handful of changes from the version you have. Set default settings as desired; then open each open event and check all settings on the Fields tab as it may not be the same as you had it set before due to the custom field structure changes. Change any fields you need to and re-save.

While you have a handful of tasks to do, none of them are very time-consuming or difficult. I'd suggest doing the upgrade during whatever time is slower hours for your site traffic. But I guess if you're having issues right now, it doesn't matter when you do it if it can't be used presently anyway.

In the end you'll also have some nice new features available to you too!