Delete a recurring event?

  • Eoin Feeney
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 2 weeks ago #115035 by Eoin Feeney
Delete a recurring event? was created by Eoin Feeney
I've done mad with the recurring events. what's the best way to delete them all?

Also, in doing so i fI do the dropdown to "all" my page white screens. Perhaps there should be some error checking?

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

  • Eoin Feeney
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 2 weeks ago #115036 by Eoin Feeney
Replied by Eoin Feeney on topic Delete a recurring event?
I used PHP admin to drop the table and then reinstalled it

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

  • Eoin Feeney
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 2 weeks ago #115037 by Eoin Feeney
Replied by Eoin Feeney on topic Delete a recurring event?
Crap. That was a bad idea. Didn't work.

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

More
7 years 1 week ago #115040 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Delete a recurring event?
Instead of drop the table, you should only truncate the table #__eb_events. Otherwise, go to Events Booking -> Events, and delete all of those events should work, too

For now, what's the issue you are having? Do you need help from us?

Regards,

Tuan

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

  • Eoin Feeney
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 1 week ago - 7 years 1 week ago #115046 by Eoin Feeney
Replied by Eoin Feeney on topic Delete a recurring event?
There were thousands of events so going to Booking -> Events wouldn't work. I did too high a recurring number.

Dropping the table worked, but then I could not use the component obviously.

Reinstalling the component didn't reinstall the table.

Uninstalling the component and reinstalling it worked. I'll try to truncate the table next time. All sorted, I only posted this information in case someone else has the same issue.
Last edit: 7 years 1 week ago by Eoin Feeney.

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

More
7 years 1 week ago #115047 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Delete a recurring event?
I see. Please note that if you drop the table, you will need to uninstall the extension and re-install it to have the table created again

Tuan

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

  • Eoin Feeney
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
7 years 1 week ago #115049 by Eoin Feeney
Replied by Eoin Feeney on topic Delete a recurring event?
But you only lose the data in the dropped table right? Obviously dropping the table loses all of your events

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

More
7 years 1 week ago #115052 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Delete a recurring event?
Yes. You will only loose data of dropped table. And Yes, if you drop the table, you will loose all events data

Tuan

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

More
7 years 1 week ago #115053 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Delete a recurring event?
If you only want to empty children events of a certain event, you can run a SQL command like below

DELETE FROM #__eb_events WHERE parent_id = ID_OF_PARENT_EVENT

ID_OF_PARENT_EVENT is id of the event which you want to delete all children events. By doing that, you will only delete data of that recurring event, not all events

Tuan

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

Moderators: Tuan Pham Ngoc