Earnie,
You'd run node_save() in devel's drupal execute block? Does it resave every single node?
Thanks,
Shai
On Tue, Aug 5, 2008 at 3:07 PM, Earnie Boyd earnie@users.sourceforge.netwrote:
Quoting Shai Gluskin shai@content2zero.com:
Drupal Mavens,
On a site with about 600 nodes I need to change the node author on about
300
of them. It's very straightforward in that everything that is written by uid="2" needs to change to uid="4".
I was about to write a simple sql query to implement in phpMyAdmin but thought I'd come here first (*and* back up the db).
I'm seeing uid in two tables: node and node_revisions. Does UID exist anywhere else?
Also, would I be fine with just changing it in the node_revisions table?
The safer method is to node_load(), change the data and then node_save(). This gives any contrib modules you have a chance to do anything necessary.
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
-- [ Drupal support list | http://lists.drupal.org/ ]