Some Registrants have dissapeared

Are you a Director, Presenter, Reviewer or Conference Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael

Forum rules
The Public Knowledge Project Support Forum is moving to

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 178
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Some Registrants have dissapeared

Postby mendesrocha » Sun Aug 19, 2012 7:19 pm

Hello all!

Conference Manager (OCS 2.3.5) has just written me telling that they had 162 registrants and now system shows only 65. Therefore almost 100 registrants dissapeared from list!

I was wondering about what could happen and found the following hypothesis: before there were 8 registration types and now only 5. They removed 3 types. Do you think that this deletion could have also removed users registrated under these excluded type?

Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: Some Registrants have dissapeared

Postby asmecher » Mon Aug 20, 2012 9:08 am

Hi mendesrocha,

Yes, that might account for the discrepancy. Deleting the registration type doesn't delete the registrations themselves, but does leave a foreign key pointing to a non-existent entry. You can find out what registrations were affected in the database:

Code: Select all

SELECT r.* FROM registrations r LEFT JOIN registration_types rt ON (rt.type_id = r.type_id) WHERE rt.type_id IS NULL;
Alec Smecher
Public Knowledge Project Team

Posts: 178
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: Some Registrants have dissapeared

Postby mendesrocha » Mon Aug 20, 2012 1:14 pm

Hi Alec,

Thanks for your quick response. Nevertheless, this query returned empty results.

By the way, I could identify in the "registration_types" table the missing rows in "type_id" column. Consulting the "registrations" table I couldn't locate any rows with the excluded "type_id".

Anyway, I got a database backup and I will try to restore those missing registrants.


Posts: 409
Joined: Thu Mar 29, 2007 2:09 pm

Re: Some Registrants have dissapeared

Postby michael » Tue Aug 21, 2012 9:19 am

Hi Renato and Alec,

Deleting registration types will in fact delete the registrations associated with those types (there is a warning and confirmation message to this effect before the actual deletion is made).

If you need to delete a registration type and wish to preserve the actual registration record, you will first need to assign a new, replacement registration type for the registration to avoid the above default behaviour.


Return to “OCS Conference Support and Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest