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:

2 field showif/hideif's (2002) Appending Record Prob (2001) Location of Browser Info.txt file (1997) Multiple Ad databases? (1997) Grep issue (2003) [date] problem with %d%m%Y (1998) WebTen and WebCat (1997) [WebDNA] WebDNA app store (2011) [Sum] function? (1997) Re:Help name our technology! (1997) HELP WITH DATES (1997) Help formatting search results w/ table (1997) Protect vs Authenicate (1997) replace problem (1999) "The event log file is corrupt" (2003) my price won't move (1997) Variable Math (1998) document contains no data (1999) You know you have made your client successfully when... (2003) Configuring E-mail (1997)