Re: WebDNA deletes major DB data big time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55768
interpreted = N
texte = Matthew A Perosi wrote: > I recently had the same thing happen to me. We had 2 months of data > deleted. It seemed random and I spent a week trying to figure out how > it happen. Same thing with me, no hints, no logs, everything seemed > normal. > > My company had to spend $3700 US in our own labor costs to recreate all > the date and contact all the people effected. > > Then 2 weeks later it happen again! But this time I was able to trace > steps because I was waiting for it to happen. > > It turned out that a delete routine I had written, which touched all the > databases effected, had a run time error. The specifics were that I > passed the delete routing a few variables, but some of the variables and > header names did not match the headers for the databases. (simple ex: > eqSKUdatarq=[sku] when it should have been written as eqRSKUdata=[sku]) Hi Matthew, I can relate with you in "learning the hard way". The above needs to have URLS in it: eqRSKUdata=[url][sku][/url] if there is any spaces or non-html characters. 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 Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  2. Re: WebDNA deletes major DB data big time ( John Hill 2004)
  3. Re: WebDNA deletes major DB data big time ( Matthew A Perosi 2004)
  4. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  5. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  6. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  7. Re: WebDNA deletes major DB data big time ( Gary Krockover 2004)
  8. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  9. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  10. Re: WebDNA deletes major DB data big time ( Chris List Recipient 2004)
  11. Re: WebDNA deletes major DB data big time ( "Vincent Medina" 2004)
  12. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  13. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  14. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  15. Re: WebDNA deletes major DB data big time ( John Hill 2004)
  16. Re: WebDNA deletes major DB data big time ( Alex McCombie 2004)
  17. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  18. Re: WebDNA deletes major DB data big time ( Marc Kaiwi 2004)
  19. Re: WebDNA deletes major DB data big time ( Karl Schroll 2004)
  20. Re: WebDNA deletes major DB data big time ( Clint Davis 2004)
  21. Re: WebDNA deletes major DB data big time ( Marc Kaiwi 2004)
  22. Re: WebDNA deletes major DB data big time ( "Brian Boegershausen" 2004)
  23. Re: WebDNA deletes major DB data big time ( Matthew A Perosi 2004)
  24. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  25. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  26. Re: WebDNA deletes major DB data big time ( Clint Davis 2004)
  27. Re: WebDNA deletes major DB data big time ( "Morten Madsen" 2004)
  28. WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
Matthew A Perosi wrote: > I recently had the same thing happen to me. We had 2 months of data > deleted. It seemed random and I spent a week trying to figure out how > it happen. Same thing with me, no hints, no logs, everything seemed > normal. > > My company had to spend $3700 US in our own labor costs to recreate all > the date and contact all the people effected. > > Then 2 weeks later it happen again! But this time I was able to trace > steps because I was waiting for it to happen. > > It turned out that a delete routine I had written, which touched all the > databases effected, had a run time error. The specifics were that I > passed the delete routing a few variables, but some of the variables and > header names did not match the headers for the databases. (simple ex: > eqSKUdatarq=[sku] when it should have been written as eqRSKUdata=[sku]) Hi Matthew, I can relate with you in "learning the hard way". The above needs to have URLS in it: eqRSKUdata=[url][sku][/url] if there is any spaces or non-html characters. 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 Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan Brooke

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:

TaxTotal Problem (1997) RE: IIS4b2 and WebCatalog b19 (1997) [LOOKUP] (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Error handling for accountNum (1997) ShowNext problems (1998) can WC render sites out? (1997) emailer (1997) [WebDNA] [thisautonumber] and [lastautonumber] (2011) WebCat for Unix?? (1997) Problems reading files created by WC (1997) two unique banners on one page (1997) Practice runs ? (1997) A little syntax help (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Product display (2000) NT Setup (1998) [WebDNA] Poll: Discussion Forum (2009) WebCatalog for guestbook ? (1997) TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997)