By RoiDanton on

Hi all,

I have a small problem.
One of my users deleted his account by accident.
I managed it to export the corresponding user from a backup and inserted it into the live system.
Everything went fine so far but now all the posts of the user belong to guest.
How could that happen and how could I fix this?
I thought the post will somehow hold the ID of the poster but this seems to be wrong.
It would be also no problem to associate all guest posts with the restored user.

Any ideas?

Thanks in advance!

Regards,

Roi

⋅ Categories: Drupal 6.x

Comments

RoiDanton’s picture

RoiDanton commented

I got it.
In the table node :
UPDATE `db`.`node` SET `uid`=new WHERE `uid`='0';