Tell me more ×
Drupal Answers is a question and answer site for Drupal developers and administrators. It's 100% free, no registration required.
up vote 1 down vote favorite
1

I recently went through a Drupal site I'm helping manage, doing a batch delete on a bunch of spam tickets through Administer > Content > Edit.

As it turns out, though, the data for this content seems to still be stored in the database, and is shown on our ticket list. Taking a look at a database dump taken after the deletion took place, confirms that they are in fact still present in the node and node_revisions tables.

Trying to access any of the tickets gives a "Page not found", and they're not listed in the "Edit Content"-list. Clearing the cache has been tried, and didn't resolve the issue.

In case it's useful, the node types are ticket.

Any insight into what has gone wrong and how to fix it would be most appreciated.

share|improve this question
1  
node_delete in the node.module calls db_query('DELETE FROM {node} WHERE nid = %d', $node->nid); db_query('DELETE FROM {node_revisions} WHERE nid = %d', $node->nid); So this isn't a general Drupal problem. What's the node type or module of this nodes? – BetaRide May 14 '11 at 15:28
@BetaRide: The node type is ticket. – Sebastian Paaske Tørholm May 14 '11 at 15:37

migrated from stackoverflow.com May 15 '11 at 1:41

1 Answer

up vote 2 down vote accepted

Turns out that tickets posted by deleted users do not show up in the management interface, but did show up in our view.

Problem was resolved by changing the owner of the tickets to a dummy user, then deleting them through the management interface.

share|improve this answer
Remember to accept your own answer. – kiamlaluno♦ May 15 '11 at 1:59
@kiamlaluno: As soon as 2 days have passed. :) – Sebastian Paaske Tørholm May 15 '11 at 7:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.