By Antikx on

I did something that I never thought I would do.
I deleted the Admin account. :(
...so I created a new account, changed it's uid to 1, and I think I'm good now.
Now want to claim my nodes back as they all say they are from Anonymous.
I did search the forum, but I can't seem to find the right keywords to give me an SQL script I could use to get them back.

⋅ Categories: Drupal 4.7.x

Comments

vm’s picture

vm commented

how many are there ? if few, or in the meantime you cause change the author of each node using the edit form.

Antikx’s picture

Antikx commented

probably over a 100. :(

vm’s picture

vm commented

yea it may be best to wait to see if someone can give you an sql snippet to do so.

geojaz’s picture

geojaz commented

What you'll need to do is figure out what ID your old nodes are set to (it sounds like they're UID1?) The way you'll find this is to use phpMyAdmin to look in the node table with for some node you know is yours, and view it and check the UID field.

Now that you know what UID all of your nodes are under, you can use phpMyAdmin to execute the following queries:

UPDATE node SET uid=1 WHERE uid=OLD_UID;
UPDATE node_revisions SET uid=1 WHERE uid=OLD_UID;

OLD_UID is whatever your previous UID is. This should go in and reset all the nodes...

Let me know if this doesn't work, I can probably help you diagnose it if this doesn't work!

Antikx’s picture

Antikx commented

It worked like a charm! Thanks. I've clawed them all back.
http://www.tyrannozaurus.com/?q=node/418

modernaut’s picture

modernaut commented

I just want to point out that it's very, very stupid that they've made it possible to delete the admin account, at least without some easier way of getting it back.