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:
[defined]ish (1997)
Using Plug-In while running 1.6.1 (1997)
$Append for Users outside the ADMIN group (1997)
Sendmail on OSX/Communigate Pro (2002)
[ot] Raid Cards for RH ES (2004)
Creating main- and sub-category search (1997)
Use WebCat to search files in a folder like a search engine? (2001)
[format xs] freeze (1997)
PCS Frames (1997)
Searching multiple Databases (1997)
Pithy questions on webcommerce & siteedit (1997)
Major Security Hole (1998)
pay processing (2001)
[date] formatting bug inside [orderfile]? (1998)
sending formatted e-mail? (1998)
NTbeta18 corrupted? (1997)
Seattle based Webcatters? (2000)
Add more fields to an existent data base (1997)
Database files are being destroyed (2002)
EIMS Problems (1997)