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