Drupal - Mass Delete Events

Drupal - How to Mass Delete Events

Are you stuck with a gazillion recurring events? Want to clear out the calendar all at once? CWD shows you how...

Drupal - Delete All Events At Once

Use the following code to delete Drupal 4.7 event nodes (courtesy of kingandy) (please note this is PHP code):

$aquery= db_query("SELECT nid FROM {node} AS n WHERE n.type = '%s'",$contenttype);

if( db_num_rows($aquery) && user_access('administer nodes')) {

  while ($row = db_fetch_object($aquery))
    {
set_time_limit(5); // prevents server timeout
node_delete($row->nid);

  }

} else {

print "No entries found for node type $contenttype, or you do not have permission to modify nodes.";

}

Clearing out the Event Calendar

The above script clears out all event nodes. You may need to clear out your events tables as well to clear the repeat pattern, calendar map, etc.).

First, access your database (via phpMyAdmin). Then, simply execute the following SQL query:

TRUNCATE TABLE event; TRUNCATE TABLE event_repeat; TRUNCATE TABLE event_repeat_calendar_map; TRUNCATE TABLE event_repeat_nodes;

Voila It's also possible to run this within Drupal:

TRUNCATE TABLE {event}; TRUNCATE TABLE {event_repeat}; TRUNCATE TABLE {event_repeat_calendar_map}; TRUNCATE TABLE {event_repeat_nodes}; 

Post any questions below.

Mass Deleting Nodes in Drupal 5.x+

For versions of Drupal above 5.x, you can use the mass delete or delete all modules.