By JPV on

I made a mistake when I created my site, and added lots of content with my original user account (user 1). I will need to rename that account to something like "admin" and create a regular user account (jp) for me. How can I fix it so that all my existing content is assigned to "jp" instead of "admin" so people know who to blame? :-)

I'm using mysql-3.23.58-16, mysql-server-3.23.58-16. I'm not a DBA-type, but am OK with dumping the DB, editing things (vi, Perl, whatever), and re-importing. I just don't know what to do or edit. It's currently Drupal 4.6.5 but I hope to make it 4.7.2 Real Soon Now (see next).

As a side note, I've never been able to figure out how to get nodes to display the last update time, in place of or ideally in addition to the created time. I don't care when something was created, I need to know how recently it was edited. I'm hoping 4.7.2 will help with this, but I can't get THAT to work either (see http://drupal.org/node/71742).

Any clues for either/any issue?

⋅ Categories: Drupal 4.6.x

Comments

Cromicon’s picture

Cromicon commented

No expert but assign the user account you want to have the nodes assigned to a node maintenance role by creatinf one with uid1, log in on that then edit the author name on the nodes to your username.

There's probably a quicker and more elegant way.

beginner’s picture

beginner commented

Update your {node} table in phpmyadmin: update the uid field to be jp's uid where it previously was uid=1.

--
http://www.reuniting.info/
Healing with Sexual Relationships.
http://www.wechange.org/
We live in a world of solutions.