Recover deleted member

[fugiFox]

One member has been deleted by himself.
Now he wants to come back, keeping his previous account.
In other words can I reactivate his account?
SMF 1.0

[Oldiesmann]

Tell him to re-register and then you can give him back his posts...

After he registers again, run this query in phpMyAdmin

Code Select Expand

UPDATE smf_messages SET ID_MEMBER = 'his_new_member_id' WHERE posterName = 'his_membername' AND posterEmail = 'hisEmailAddress';

Then go to Admin -> Forum Maintenance and click on "Recount all totals and statistics" to update everything else.

[fugiFox]

Tell him to re-register and then you can give him back his posts...

After he registers again, run this query in phpMyAdmin

Code Select Expand

UPDATE smf_messages SET ID_MEMBER = 'his_new_member_id' WHERE posterName = 'his_membername' AND posterEmail = 'hisEmailAddress';

Then go to Admin -> Forum Maintenance and click on "Recount all totals and statistics" to update everything else.

Thnx! It worked!

Well, a member recovery feature should be added shouldn't be?

[fugiFox]

Tell him to re-register and then you can give him back his posts...

After he registers again, run this query in phpMyAdmin

Code Select Expand

UPDATE smf_messages SET ID_MEMBER = 'his_new_member_id' WHERE posterName = 'his_membername' AND posterEmail = 'hisEmailAddress';

Then go to Admin -> Forum Maintenance and click on "Recount all totals and statistics" to update everything else.

Cos i dont rememer can u repeat if his_membername and hisEmailAddress are the new or the old ones?

[Aaron]

'his_membername' and 'hisEmailAddress' are the ones he used before he deleted his account.

[raulo]

Worked perfectly for me, thanks !

[chinny]

Hallo,

is it possible that the above solutions only work on a "Live System" and not on a Local Webserver.

i'd like to know that, before i try it on a "Live System"