Accidently removed admin and moderators.

[KimPlus]

Using SMF 1.1 Beta 3 Public

Rather embarrassed to admit but yesterday whilst deleting a no longer used membergroup I deleted Admin and a moderator.

I rejoined us both and used "PH MyAdmin" to restore my admin status.
Ive also used it restore from a backup my board position for PM's user ="2"

Problem I have is all my old posts several hundred now show as being posted by "My Username" guest.

Can these be re-linked to our names ? And our post counts reflect this.

It does look a bit fishy when we post with a count of 2 or 3 and hundreds of posts to our username but guest. Already had several guys PM me claiming guests are posting as me LOL.

[copter]

Oh no, that's one of the worst things that can happen

But, if you have a back up of your mysql database, you should be able to restore it and it should be back to normal, if not - hopefully someone will be able to help you and then I would advise you to make backups on a daily basis to prevent bad things as such - or maybe a backup before going into admin - that's what I'm having to do all the time

Maybe in your my sql you might be able to edit the posts with guest or link them to your user id? somehow
- does anyone know how to do a query to make this process faster?

Take Care

[KimPlus]

Didn't lose any data just 2 accounts, Admin and a moderator.

Had backup, but would rather not roll forums backwards unless there is absolute need.

[xenovanis]

http://www.simplemachines.org/sitetest/support/faq?action=display&faq=26

[KimPlus]

Many thanks but as I explained I'd already done that and rejoined as admin.

But that did not associate my old posts with this new account.

I even ran an sql query to put me back as the same user number on data base and the same join date I got from a backup.

I was username (KimPlus) position (admin) User Id (u=3)
I'm still username (KimPlus) position (admin) User Id (u=3)  same everything including password and join date but no longer associated with my previous posts as KimPlus.

[xenovanis]

Try this query in phpMyAdmin

UPDATE smf_messages SET ID_MEMBER='YOUR_ID' WHERE postername='YOU';

[DangerGirl]

I had a similar problem and after I put back the user ID, I went to Admin - Forum Maintenance and did a Recount all forum totals and statistics.  It put all my posts back to my name.  The only thing that I could not get back was my total online time, which was a treasure.  Ah well.

That's what I did, though can't guarantee that it will work for you.  But good luck!

[KimPlus]

Many thanks for the assistance but alas even after running the sql query and using forum maintainance old posts still show the early KimPlus as a guest and not associated to newly formed account.

As this is no major problem and not affecting anything other than my ego, guess I'll learn to live with it.

[copter]

What about going into your sql and create a username with ID 1 - this should correspond with the user ID of the posts and messages etc. create that username as your desired name which should sort it out - i think, i actually deleted my admin acount the very 1st time i installed smf cos i didnt know much about smf then last august/september - or start again? and inform the users?

[DangerGirl]

We ended up recreating user ID 1 from scratch and it worked for us after we did Recount.  But we only recreated it because we didn't have the time to work with the backup we had.

[KimPlus]

Accounts 1,2 and 3 were admin accounts KimPlus the one I deleted was user 3.
Ive ran SQL query to reinstate KimPlus as user 3 and even ran a query to show he joined as origenal date but alas, old posts are still credited to KimPlus Guest.