Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Registrations not belonging to event 3 years 1 month ago #24699

  • Dete61
  • Dete61's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 5
  • Thank you received: 1
In my events, registrations from past/deleted events appear again and again. The registrations then have a date which is approximately 10 months in the past. It seems they belong to outdated events.
Even manually deleting old events from the website database does not help. Tried also the maintenance tools of 2.2.0 excerpt the complete deletion of all categories, venues etc.
I am still using JEM 2.2.0 under the current Joomla 3 version. I don't think that the update to version 2.2.2 will bring a change, because I had this bug in the previous version of JEM and therefore I had rebuilt the whole website with new Joomla, database and plugins in the beginning of 2017.

Please Log in or Create an account to join the conversation.

Registrations not belonging to event 3 years 1 month ago #24700

  • jojo12
  • jojo12's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 3334
  • Karma: 45
  • Thank you received: 363
Hi, I am trying to understand:
You had events (now in the past) where there were attending users. There names will be there even when the event is finisthed.
Were / are they recurrent events? If so, perhaps the attending is for the whole serie.
In my case I take an old event, actulize it and save it a new copy (and forget to clean the attending list). Then it's my fault.
(Thanks for giving information about your versions. I am using JEM 2.2.2+ on Joomla! 3.8.3 with ja_purity_iii or ja_simply or protostar.)
on JEM 2.3.0 stable in latest Joomla (3.9.22) Protostar php7.4.5

Please Log in or Create an account to join the conversation.

Registrations not belonging to event 3 years 1 month ago #24701

  • Dete61
  • Dete61's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 5
  • Thank you received: 1
Example: There has been an event in March 2017 with several registrations for it. 2 weeks after the end of the event it was deleted.
In January 2018 a new (no copy!) event with a new venue was created. The registration was not activated in this case. Nevertheless, 7 registrations will appear with the registration date of March 2017. Looks like a data base problem?

Please Log in or Create an account to join the conversation.

Last edit: by Dete61.

Registrations not belonging to event 3 years 1 month ago #24773

  • Hoffi
  • Hoffi's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Posts: 2279
  • Karma: 52
  • Thank you received: 449
Hi Dete61,

you're right, it sound like a DB inconsistency.

The registrations will be stored in db table #__jem_register where 'event' is the reference to the event in #__jem_events table. So if you remove (all) events directly on db table you must also remove all corresponding entries on #__jem_register table. Backend's Housekeeping - Delete all JEM data will cleanup all tables.

As far as I can see the daily cleanup - which will delete old events if configured to do so - does unfortunately not cleanup #__jem_register table. This must be fixed, of course. But this should not result in such effects you describe because the event id of deleted events will not be "reused" by database as long as events table is not completely truncated.
Pessimists are optimists with experience!

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.268 seconds

Donate

If you find JEM useful and if you use it on your site, please consider a donation to the project.

Private Messages

You are not logged in.

Follow us......