Transformation of Ros into 'Guest'

[paolo]

A most humble apology to Ros and all users. In trying to sort out a problem she was having logging in, I somehow managed to delete her as a user. Consequently all her posts are now attributed to Guest. I have asked my technical guy if anything can be done to restore her to her rightful posts. I do hope so.

(And I didn't just do it because she was catching up with me and Alan).

[Guest3]

Oops! Paolo...just wait till she gets back from her hols...you'd better run and find a good hiding place!!

[paolo]

She is back! That's why I was trying to sort it out for her. She couldn't log in. Maybe she could change her name to Guest?

[vrooje]

Hmm... this must be possible... though it'd probably have to be done manually at the database level. Maybe you could have her re-create her user (or create it for her), and then manually assign her new user the same unique id as the old user? It seems like that ought to work... but then I've also never had a look at the way the database tables are laid out...

[Hells Bells]

GUys, if you need help PM me, our admins on SnowHeads may know how.

[vrooje]

There may be another option, too... you could restore the database to an older, backed-up version.

We'd lose the posts we made since then, and any new users would have to be re-created, so maybe it's really only a last resort, but it's an option.

[Hells Bells]

Guys, if you know her membership no, you should be able to recreate her account.

[paolo]

My tech guy says he will try hacking the database. Sounds violent but we need to get Ros out of there...

[vrooje]

You say tomayto, I say tomahto, you say "hack", I say "manually edit the database."

Teehee!

Really, at first pass this could be as easy as changing one column in one table; the second pass, making sure all the cross-checks work, may be more tedious.

I must admit, Paolo, I don't envy you the sinking feeling you must have had when you realized what happened...

[Partridge]

Oh no, are you telling me poor Rozzie is watching all this and cannot post, what are you trying to do to the poor woman, she'll need another holiday to recover Then again, she'll enjoy the challenge of getting her posts up again

Hello Ros, if you're watching, we're thinking of you

[Lesblancs]

Ros - I have now tried five times to post the correct sympathy.

Sorry, best I can do is

PG (first to 240?)

[vrooje]

Sorry, best I can do is

Oh, you are gonna get smacked when she comes back!

Poor Ros.

She could always create a temporary user, just to post over the next couple of days...

[la vache!]

Poor Ros, it must be the ultimate torture for her to be gagged, so to speak - not to mention lose the phenomenal number of posts she has made in less than a year!
I hope you manage to get her ID sorted out Paolo!!

[Hells Bells]

Sorry to hear you're locked out Ros, we shal do our best to post as much as possible.

[Mouse]

I vote we start a 'Save Ros' campaign!

I'm already suffering withdrawel symptoms



Mousie
X