Take the 2-minute tour ×
Drupal Answers is a question and answer site for Drupal developers and administrators. It's 100% free, no registration required.

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
WHERE 
r.uid = 1
AND n.uid = 1
AND n.type = 'blog'
AND r.nid = n.nid
share|improve this question

1 Answer 1

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 at 18:09
    
I'm looking for the install directions. Does this go in /modules or in /modules/views/modules? –  jerrygarciuh Apr 19 at 18:21

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.