Hi TAZ'ers, I just wanted to let you know that I am no longer an admin virgin as I had my first run in with a problem member last week. We moved servers and changed forum software (as well as CMS) all at the same time and (as far as our members could see) on the same day, although they were pre-warned. Well during the conversion of the forum posts from eBlah to SMF, some of the posts were labelled under the wrong usernames (around 5%). Not a biggie though, right? Wrong! I got this email first (names etc. changed for privacy reasons): The following post, "Example title 1" by Alan has been reported by Bob on a board you moderate: The reporter has made the following comment: THIS IS BOB somebody has taken over my computer or hacked this site.....bob was changed to alan or something..my girlfriend cathy found it and we got bigger problems...hurry up and contact me at email@example.com or delete everything.....this is not a joke...I didn't download that ****... Then this one: The following post, "Example title 1" by Alan has been reported by bob on a board you moderate: The reporter has made the following comment: This is Bob, apparently you downloaded all of my comments and every code that links to my photos to Alan....MY WHOLE COMPUTER IS AT ALAN'S MERCY AND RISK...IF EVERYTHING THAT I HAV EON MY COMPUTER GETS EXPOSED OR ON THE INTERNET, THERE'S GOING TO BE A PRICE TO PAY....DO YOU UNDERSTAND ME CLASSIXUK.....GET IT FIXED NOW!!! Then I received this private message entitled "rEAD THIS NOW CLASSIXUK"(this is all in the same night): THIS IS BOB WHAT THE f*** HAVE YOUE DONECLASSIXUK DO YOU REALIZE THAT YOU PUT EVERYTHING FROM THE OLD SITE ONTO ALANS PROFILE AND NOW EVERYTHING IN MY COMPUTER IS AT RISK TO THE WHOLE f***ING WORLD.... WHAT ARE YOU DOI9NG.... DELETE IT NOW... GOD YOUR IN SO MUCH TROUBLE... MY EMAIL IS firstname.lastname@example.org or call me at 555-555-5555 hurry wtrfufvc By this point I was beginning to get annoyed, as my moderator contacted me to say she was receiving PMs also "threatening to sue", so I reset the member's username and password then emailed the member: Bob, There was a simple problem with the conversion from one database to another. Your username and password were associated with posts made by Alan and vice-versa. The problem is now fixed and you should have by now (if not soon) received an email explaining that your password has been reset. Your username is now associated with the posts you have written and you can change your password to anything you like in your profile. Your computer is not, and never was at risk. It was a tiny database error on the new server. In future I'd appreciate if you would give me a chance to fix things or investigate before you fly off the handle and swear at me or threaten me. The tone of your private messages tonight can only be described as disappointing; you've let yourself down badly by talking to me like that. I know you are very stressed at the moment with all of the pressures you are facing in life but that's no excuse. In future I recommend you "sleep on it" before talking to people like that. Classixuk. So then I received this email back: Hello I hope this goes to Classixuk This is Bob from the forum.... We have got a huge problem here to solve....First off I re-registered as Bob again, Alan had been put in my place with my posts and photos...Now I can't log in, the link here now says invalid log in... So have I been banned from the site??? If so, well I can maybe see why you are mad after the emails I sent...But you don't have a clue to the big picture here yet...There are a lot of things that need to get settled here, whether I am a member or not.. I have been doing research all evening, about 6 hours now non-stop and I am starting to realize that a lot of things happened simutanously....I need to find out the time frame as to when the site was changed over exactly... US time zone of course...I am in the Central Time Zone in America... The problem is that somebody has hacked into my myspace account and got my photos and then put some rather adult photos mixed with them and made a slide show out of it...There are so many factors to this case you would not believe it...It all points in one direction, and that is..defimation of my character...This was not a coincidence, and was not as simple as a mistake from getting the wrong profile user switched around on part of classixukssite.com..This goes much deeper than that.. I had contacted my computer expert and we were prepared to put a time stamp on the site about the time it was all switched back into the name of Bob...But I can not log in now, so there is only so far that I can go...Also another flaw in this system is the forget your password feature..I went to it, and gave my username and my email address..but got a message as not being a valid username....There should be no email feature on there...If somebody went to log in section somebody could put any email address they wanted into it...Unless it happens to be set up to not accept that attempt if it doesn't match up... In the case that I have been banned from the site....Oh well...But I still need to know what is going on here... The bottom line is that I believe I got hacked from something at myspace and another website...Most of the questionable photos from the slideshow, which was found on the topic..."Example Topic 2" under the Example Category 1 section, were taken from myspace..some were mine, but the adult content ones were not..So please get back with me..and let me know what is going on here... I hope together we can figure this mess out, and make sure it doesn't happen again... Thanks...Bob So at this point I contacted my moderator to ask if she had any further news. She explained to me that Bob's girlfriend had allegedly been browsing my forum on the day it changed over and clicked an external link in Bob's post to go to his myspace site. Upon arriving at his myspace site she clicked a link which brought up a slideshow of scantily clad women and was furious. Not being computer literate (or even possessing any common sense by the sounds of things) she went to his house and broke up with him, blaming his POSTS on MY site! My moderator was informed about this because the girlfriend had private messaged her (of course, I was forwarded the private messages)! Here's one of them: this is bob do you realize that classixuk put everything from my account on to alan....and now everything from my computer is linked to the entire f***ing world to see???? what the fucik is going on herere. delete this sh*t now... shut the whole site down... I am going to sue the f*** out of classixuk if you don't I swear to god I will.... you get in touch with me.... 555-555-5555 email@example.com So, armed with a little insight I replied once more: Bob, This is the second email I have sent tonight. I have been sending emails to your firstname.lastname@example.org address. Please check it. I haven't got a clue what your problems are with your girlfriend, my space or anything like that. You have not been banned from the site either. First let me tell you what happened: 1. I don't know if you've ever made a simple database or spreadsheet in Excel or Access, but when you do you put information into columns. You name each column with a title like "Price" or "Name". 2. When the database of posts was transferred over to the new forum, your column of posts was put underneath "Alans" column and vice versa. When you spotted it I fixed it. It was a labelling error in the database. 3. When I renamed the column called "Alan" to "Bob" you were sent an email with a randomly generated password so that you could log in with the name bob and that password. When you log in you will see that your own posts are in your profile and your post count is back at 76 instead of 7. I haven't got a clue about all this porn stuff you're telling me about because you haven't made yourself clear. You only have one picture attached to the post and then a link to your myspace account. Are you saying that when you clicked through to your myspace account it had pictures of pornography on it or that classixuksite.com had pictures of pornography? I can't see any pornography anywhere! Regardless Bob, you've got the wrong end of a very short stick. Neither I nor my site have anything to do with your myspace account and renaming a column in a SQL database from Alan to Bob does not have any effect on what your girlfriend sees at your myspace account. In future I suggest you think before you accuse people of being responsible for something they are not. Your conduct tonight has been alarming to say the least and I won't tolerate threats or abuse of any kind towards any of the users at classixuksite.com. If you wish to use the site or communicate with me it must be in a civil manner. Classixuk. I'm telling you, it's just as well I'm a calm person because I've never faced anything like that on any forums I've been involved in before. I felt like pressing the ban button there and then. I'd be interested to hear from you guys about your simliar stories or even how you would have handled the above situation. What tips and advice would you offer for any TAZ members facing this type of thing in the future? Thanks. Chris.