5 Aug
2008
5 Aug
'08
8:19 p.m.
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? Thanks, Shai