By jo1ene on

Stupid me deleted a user that had previously posted a couple of stories. Now the stories are "dead" and un-administratable, as in I can't get rid of them. Delete them at the database level? How?

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented

delete from node where nid = uid;

uid should be the deleted user's numerical ID.

--
Drupal services
My Drupal services

jo1ene’s picture

jo1ene commented

Thank you. I think I can figure it out from this.

ph4nt0m-1’s picture

ph4nt0m-1 commented

If what the user wanted to do was delete all nodes owned by a certain uid wouldn't the SQL syntax be:

DELETE FROM node WHERE uid = '[uid]'

Where [uid] was the numerical ID of the deleted user. nid is the numerical ID of the node, which is not related to the uid, is it?

killes@www.drop.org’s picture

killes@www.drop.org commented

Sure, it was too late when I posted that...

--
Drupal services
My Drupal services