Digital Point Forums
Western Union

Go Back   Digital Point Forums > Products & Tools > Optigold ISP > Bugs
Google Analytics
Log In to view
your analytics

Reply
 
Thread Tools
  #1  
Old Sep 13th 2004, 9:14 pm
devnull4u's Avatar
devnull4u devnull4u is offline
Peon
 
Join Date: Jun 2004
Location: Azalia, Michigan
Posts: 3
devnull4u is on a distinguished road
Exclamation Scary incident: records in Activity_ table deleted

Shawn,

We had a very odd incident with OG today. An employee was working with a customer today changing their email password. He went into their record, clicked on Services, double-clicked on the email account, changed the password, and clicked on the Change Pass button (he has done this procedure literally hundreds of times before). He told me he had a couple of error messages flash by (too fast to read) and then a message about deleting around 15,000 records appeared. He called me on my cell phone and I was able to come in and have a look a few minutes later (10-15 minutes). When I arrived it appeared to me that the records in the Activity_ table had been deleted. We lost all messages, to-do's, planner, tech support notes, and call activity across the entire database....we haven't noted any other losses yet.

This employee does not have any deletion rights and no-one has the God-Level delete rights. Audit trail doesn't seem to pick up this activity either.

We are using FM5.03 Server and clients.

Have you heard of things like this ever happening to anyone else? Possible causes? We've been using OG since 1999 and have never seen anything like this before!

Rick Rountree
Dundee.Net
Reply With Quote
  #2  
Old Sep 13th 2004, 9:38 pm
digitalpoint's Avatar
digitalpoint digitalpoint is online now
My cat is on Prozac... really. lol
 
Join Date: Mar 2004
Location: San Diego, California
Posts: 22,359
digitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond repute
Phone Verified
Hmmm... I have never heard of anything like that before to be honest. I can't think if anywhere to even look for it to be a possibility since the services (and changing a password on an email) doesn't make any reference to anything within the Services table. As far as what is in that table, you are right, the things you mentioned are the only things in that table.

I will do a little testing on this end (although going to be a little hard to troubleshoot if I can't make it happen), but for now you probably will just want to restore that table from a backup.
__________________
- Shawn
Keyword Tracker now supports Google (once again) as well as Bing (new) and Yahoo
Please do not PM, IM or email me for product or tool support (they will go unread/ignored), and don't "friend" me unless we are really friends.
Reply With Quote
  #3  
Old Sep 13th 2004, 10:10 pm
devnull4u's Avatar
devnull4u devnull4u is offline
Peon
 
Join Date: Jun 2004
Location: Azalia, Michigan
Posts: 3
devnull4u is on a distinguished road
Assuming what the employee told me isn't entirely accurate...is there any way in the OG interface, including scripts, to delete all the records in the Activity_ table?

Rick Rountree
Dundee.Net
Reply With Quote
  #4  
Old Sep 13th 2004, 10:35 pm
digitalpoint's Avatar
digitalpoint digitalpoint is online now
My cat is on Prozac... really. lol
 
Join Date: Mar 2004
Location: San Diego, California
Posts: 22,359
digitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond reputedigitalpoint has a reputation beyond repute
Phone Verified
No, there is not.
__________________
- Shawn
Keyword Tracker now supports Google (once again) as well as Bing (new) and Yahoo
Please do not PM, IM or email me for product or tool support (they will go unread/ignored), and don't "friend" me unless we are really friends.
Reply With Quote
  #5  
Old Apr 26th 2007, 5:47 am
Junichiro-Tokuoka Junichiro-Tokuoka is offline
Peon
 
Join Date: Apr 2007
Posts: 19
Junichiro-Tokuoka is on a distinguished road
Exclamation

it may be a bug in the program where arbitry code is stored unintentionaly and then releases to perform unusual requests and actions. Otherwise known as the ghost in the machine. AND STUFF LIKE THIS DUS HAPPEN AND EXSIST.
Reply With Quote
  #6  
Old Jun 12th 2007, 6:56 am
kirby009's Avatar
kirby009 kirby009 is offline
Twilight Vanquisher
 
Join Date: May 2006
Posts: 608
kirby009 is on a distinguished road
sounds like a malfunction. 1 in a million
__________________
www.manitowaning.net manitoulin
www.wikwemikong.net forum
Reply With Quote
  #7  
Old Oct 22nd 2007, 6:10 am
Martens's Avatar
Martens Martens is offline
Champion of the Naaru
 
Join Date: Oct 2007
Posts: 122
Martens has a little shameless behaviour in the past
Seems like
Reply With Quote
  #8  
Old May 14th 2008, 1:43 am
w424637 w424637 is offline
Grunt
 
Join Date: Apr 2008
Posts: 36
w424637 is on a distinguished road
thanks great post
Reply With Quote
  #9  
Old Feb 4th 2009, 9:42 am
Twine Twine is offline
Grunt
 
Join Date: Oct 2008
Posts: 46
Twine is on a distinguished road
Hmm very strange, how many times has it happened? Never seen that before..
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -8. The time now is 9:08 am.