Drupal Answers is a question and answer site for Drupal developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm taking over maintenance of a Drupal site but the old admin is staying on as a user.

I need to adjust the ownership of the posts currently under uid 1.

Is this query sufficient or is uid associated with a blog post in other ways?

Is there an admin module for this process?

UPDATE `drupal_node_revisions` r,
`drupal_node` n
SET n.uid = 13392, r.uid = 13392
r.uid = 1
AND n.uid = 1
AND n.type = 'blog'
AND r.nid = n.nid
share|improve this question
up vote 3 down vote accepted

Node data is stored in node table also.. It's a bad practice to change node content directly using sql queries...

You can use Views Bulk Operations (VBO) module to change node authors in bulk...

This module augments Views by allowing bulk operations to be executed on the displayed rows. It does so by showing a checkbox in front of each node, and adding a select box containing operations that can be applied. Drupal Core or Rules actions can be used.

enter image description here

share|improve this answer
Thank you! I assumed like most platforms hand editing would not be best. This site is on Drupal 6x so I will install drupal.org/node/161539/release?api_version%5B%5D=87 and see if I can resolve. Much obliged! – jerrygarciuh Apr 19 '14 at 18:09
I'm looking for the install directions. Does this go in /modules or in /modules/views/modules? – jerrygarciuh Apr 19 '14 at 18:21

Your Answer


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.