Author Topic: Mass deletion of events (Read 511 times)

Upperholme · February 19, 2014, 02:18:24 am

I've been doing some work on a client's site, and have just become aware that nearly 2500 bogus events have been created within CiviCRM. I'm not certain how these events (which as far as I can see are all copies of one or two existing genuine events) came to be created, but based on evidence from the log files I'm assuming that they have been created by an unauthorised user. It looks like the permissions may have been wrongly set, thus allowing the required access.

I've reviewed and tightened up the permissions, and I'm now looking to clean up. Ideally I'd like to just delete the relevant rows from the database table, as manually deleting this many events through the UI would take forever. There's nothing obvious to suggest that deleting rows would cause problems, but I'm aware that the Civi db structure can be fiddly to tinker with, with lots of foreign keys, etc.

Any insight as to whether it is OK to just remove rows from civicrm_events?

Donald Lobo · February 19, 2014, 06:34:46 am

Might want to use the api to loop thru and delete all created events. This will ensure that the various objects linked to an event are also deleted

lobo

Lionsharz · June 11, 2014, 03:03:46 pm

Hey

I have this issue too - not sure how it started but they copy each other constantly. How did you go about the removal?

Any advice mucho appreciato

Dan C · June 12, 2014, 07:41:47 am

I encountered a similar problem a few months back with events seemingly randomly replicating themselves over and over again. I discovered that the cause was that the site had the permissions set incorrectly for the public user group. If you set CiviEvent: access CiviEvent to Allowed for the public user group then when the search engine spiders hit your site it will cause duplication of all events on the site. So you end up with an exponential increase in the number of events each time your site gets crawled. Setting that permission to denied (in my case inherited also worked) solved the problem.

And then clean up is a pain in the but, the API is probably your best bet like lobo suggested.

CiviCRM Community Forums (archive)

News:

Author Topic: Mass deletion of events (Read 511 times)

Upperholme

Mass deletion of events

Donald Lobo

Re: Mass deletion of events

Lionsharz

Re: Mass deletion of events

Dan C

Re: Mass deletion of events