Issue status update for http://drupal.org/node/19055 Project: Drupal Version: 4.5.2 Component: node.module Category: bug reports Priority: normal Assigned to: Anonymous Reported by: menesis Updated by: menesis Status: patch Attachment: http://drupal.org/files/issues/node_user_delete.diff (507 bytes) When a user is deleted, all nodes which he created can't be accessed anymore, because they have non-existing uid and queries which select from node and user tables fail. There are two ways to fix that: 1) also delete nodes. 2) reset nodes' author to Anonymous. 1 is most probably undesirable side effect. When I encountered such problem I was happy those nodes were still in database and I could bring them back by changing uid. Otherwise I would have lost the content. Here is a simple patch which implements 2) - sets node.uid to 0 (Anonymous). menesis