Re: Mass deletion of records
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66153
interpreted = N
texte = Donovan Did you read that link I sent. Yes I had backups but they only happen once a day (every hour now) Yesterday over 900 records were deleted - yes GONE. Within the sandbox that the db resides in there is not one [delete] in any of the code ! Delete command is disabled. The db has been stable for years and in the past 2 weeks it has dumped records 3 times. And yes nothing like this has happened to me EVER in 8 years ! I always wondered what it would feel like to see an almost empty db, let me tell you it isn't great! Stuart Tremain idfk web developments, sydney, australia On 31 Jan 2006, at 3:09 PM, Donovan Brooke wrote: > Stuart Tremain wrote: > >> I have had a mass deletion of records from a db that has ben >> stable for a number of years, no work has been done to any of the >> system that would delete records. There is not even a [Delete] in >> the site. >> I noted in the archives other people having this 'mystery' >> deletion. Has anyone come up with an answer ? > > > Stuart, > I'm not saying it didn't happen... but nothing in your > statement makes me certain that this is just some sort of majic > deletion. > There are so many possibilities for mass data deletion that stem > from bad code that it makes it hard for me to believe anyone when > they say this has happened... (knock on wood). Just because it > baffells > someone, doesn't mean its majic. I get baffelled in one way or another > most everytime I code something significant. > > Is there a interpret tag in your "site" somewhere? > Is there a bad CR in your database. > What do you mean by "Site" (you have to be weary of *any* code that > can > reach that database). > Are the records *deleted* for sure, or have the values been replaced? > What kind of commands do you allow? > What platform/permissions. > > Again, I'm not saying some wierd bug didn't happen. I'm just saying > that > I've have never had any mass deletions.. and I'm anxiously > anticipating it.. > because at least I could troubleshoot for myself (and my system is > backed up daily). > > I've done quite a lot of code for ppl and as far as I know, nothing > like > this has happened (that couldn't be explained). > > At any right, sorry that it happened, and I hope you had backups. > > Donovan > > > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE EUCA Design Center > > <- Web Development (specializing in eCommerce),-> > <- Custom Paint, Labels, and Specialty Signage. -> > <- Home and Business Embellishment/Fabrication, -> > <- Glass Blowing, and Art Glass -> > > PH/FAX:> 1 (608) 835-2476 > Web:> http://www.egg.bz | http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Donovan Did you read that link I sent. Yes I had backups but they only happen once a day (every hour now) Yesterday over 900 records were deleted - yes GONE. Within the sandbox that the db resides in there is not one [delete] in any of the code ! Delete command is disabled. The db has been stable for years and in the past 2 weeks it has dumped records 3 times. And yes nothing like this has happened to me EVER in 8 years ! I always wondered what it would feel like to see an almost empty db, let me tell you it isn't great! Stuart Tremain idfk web developments, sydney, australia On 31 Jan 2006, at 3:09 PM, Donovan Brooke wrote: > Stuart Tremain wrote: > >> I have had a mass deletion of records from a db that has ben >> stable for a number of years, no work has been done to any of the >> system that would delete records. There is not even a [delete] in >> the site. >> I noted in the archives other people having this 'mystery' >> deletion. Has anyone come up with an answer ? > > > Stuart, > I'm not saying it didn't happen... but nothing in your > statement makes me certain that this is just some sort of majic > deletion. > There are so many possibilities for mass data deletion that stem > from bad code that it makes it hard for me to believe anyone when > they say this has happened... (knock on wood). Just because it > baffells > someone, doesn't mean its majic. I get baffelled in one way or another > most everytime I code something significant. > > Is there a interpret tag in your "site" somewhere? > Is there a bad CR in your database. > What do you mean by "Site" (you have to be weary of *any* code that > can > reach that database). > Are the records *deleted* for sure, or have the values been replaced? > What kind of commands do you allow? > What platform/permissions. > > Again, I'm not saying some wierd bug didn't happen. I'm just saying > that > I've have never had any mass deletions.. and I'm anxiously > anticipating it.. > because at least I could troubleshoot for myself (and my system is > backed up daily). > > I've done quite a lot of code for ppl and as far as I know, nothing > like > this has happened (that couldn't be explained). > > At any right, sorry that it happened, and I hope you had backups. > > Donovan > > > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE EUCA Design Center > > <- Web Development (specializing in eCommerce),-> > <- Custom Paint, Labels, and Specialty Signage. -> > <- Home and Business Embellishment/Fabrication, -> > <- Glass Blowing, and Art Glass -> > > PH/FAX:> 1 (608) 835-2476 > Web:> http://www.egg.bz | http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Stuart Tremain
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
ACGI processing for .html (1997)
Separate SSL Server (1997)
Location of Browser Info.txt file (1997)
taxTotal, grandTotal (1997)
About Cookies... (2004)
OBDC Support (1997)
Updating fields from different platforms (1998)
[WebDNA] CICADA (2009)
Email notification to one of multiple vendors ? (1997)
WebMerchant issues. [Resent] (2000)
Searching Relational Databases (2004)
detecting if var is blank? (2007)
A multi-processor savvy WebCatalog? (1997)
WebCatalog Technical Reference (1997)
Modifying order output (1997)
Credit card processing - UK (1997)
"top" Clarification ( for apache ) (2008)
How far do [showif]s go? (1997)
Encrypt question. (2000)
[Announce]: Web server security and password protection (1997)