Re: [BULK] Re: [WebDNA] triggers.db "next execute" fails to update
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108356
interpreted = N
texte = Thanks to email archives I never delete I was able to dig up this info:WebDNA 5.0 circa March 2003WebDNA 5.1 circa August 2003WebDNA 5.1e circa November 2003WebDNA 6.0 announcement Feb 17, 2004-MattOn 1/30/2012 8:50 AM, Kenneth Grome wrote:> Hi Matthew,>> Thanks for this very valuable information.>> I thought the host was running 6.2 but I checked the server> this morning and he is still running 6.0! This explains the> trigger problems I've been wasting my time on ... :(>> Does anyone remember when version 6.0 was released? I'm> thinking it was almost 10 years ago, is this correct?>> Sincerely,> Kenneth Grome>>>>> Kenneth,>>>> I've had the same issues on all my WebCat 4.x, 5.x, and>> 6.0 servers over the years. The problems does not seem>> to happen on 6.2 for me.>>>> In my case, I had many triggers in a single Sandbox that>> would work fine for months and then one of them would>> stop updating. Or, even stranger, it would update to>> some time into the future. It never happen often enough>> to figure out a pattern.>>>> My solution was to simply delete the next trigger date>> and time. Save. Open the trigger record again and let>> it fill in the next execute time on it's own.>>>> I always suspected that it would only happen when WebDNA>> was close to, or exceeded, the available RAM, but that's>> such a hard thing to figure out.>>>> -Matthew>>>> On 1/29/2012 6:53 PM, Kenneth Grome wrote:>>> Nope, just>>>>>> Sincerely,>>> Kenneth Grome>>>>>>> Typo in your "Validation Text" ?>>>>>>>> On 29/01/2012, at 4:29 PM, Kenneth Grome wrote:>>>>> I created a trigger on WebDNA 6.x via WebDNA Sandbox>>>>> Admin. This is the only trigger used in this sandbox.>>>>>>>>>> When it runs WebDNA fails update the "next execute">>>>> value like it is supposed to. Therefore the trigger>>>>> runs again every 10 seconds, and the same template is>>>>> interpreted by WebDNA again ...>>>>>>>>>> This is a "bad thing" when the template has a>>>>> sendmail context it it to alert me that the trigger>>>>> has run, because it sends me another email every 10>>>>> seconds. I got more than 1500 emails this morning>>>>> before the host put an end to it by rebooting the>>>>> server ... :(>>>>>>>>>> Flushing the databases does not stop the trigger from>>>>> running. Deleting the target template via FTP does>>>>> not stop it, because even though the file is no>>>>> longer on disk it is apparently still cached in RAM.>>>>> Strangely enough, the template seems to remain>>>>> cached in RAM , thus ignoring the WebCatalog Prefs>>>>> that's supposed to force the template out of ram>>>>> every 2 seconds. Issuing a FlushCache command also>>>>> fails to purge the template from RAM.>>>>>>>>>> :(>>>>>>>>>> My host refuses to investigate this issue. Whether>>>>> he is lazy, irresponsible, incompetent, or all of>>>>> the above, cannot say for certain. Nevertheless I>>>>> need the problem fixed, so I'll have to figure this>>>>> out myself, hopefully with some bright ideas from>>>>> others here.>>>>>>>>>> Any idea why WebDNA might fail to update the "next>>>>> execute" value when the trigger is run?>>>>>>>>>> Sincerely,>>>>> Kenneth Grome>>>>> ----------------------------------------------------->>>>> -- -- This message is sent to you because you are>>>>> subscribed to the mailing list
. To>>>>> unsubscribe, E-mail to:>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>> Bug Reporting: support@webdna.us>>>> ------------------------------------------------------>>>> --- This message is sent to you because you are>>>> subscribed to the mailing list.>>>> To unsubscribe, E-mail to:>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>> Bug Reporting: support@webdna.us>>> ------------------------------------------------------->>> -- This message is sent to you because you are>>> subscribed to the mailing list.>>> To unsubscribe, E-mail to:>>> archives: http://mail.webdna.us/list/talk@webdna.us>>> Bug Reporting: support@webdna.us>>>>>>>>>>>>>>> Psi Prime, Inc.>>> 323 Union Blvd.>>> Totowa, NJ 07512>>>>>> Service: 973.413.8211>>> Training: 973.413.8214>>> Fax: 973.413.8217>>>>>> http://www.perosi.com>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list.>> To unsubscribe, E-mail to:>> archives: http://mail.webdna.us/list/talk@webdna.us>> Bug Reporting: support@webdna.us> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list.> To unsubscribe, E-mail to:> archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us>>>> -- > Matthew A Perosi> Corporate Consultant> Mobile Marketing Expert> Senior Web Developer> SEO Analyst& Educator>> Psi Prime, Inc.> 323 Union Blvd.> Totowa, NJ 07512>> Service: 973.413.8211> Training: 973.413.8214> Fax: 973.413.8217>> http://www.perosi.com
Associated Messages, from the most recent to the oldest:
Thanks to email archives I never delete I was able to dig up this info:WebDNA 5.0 circa March 2003WebDNA 5.1 circa August 2003WebDNA 5.1e circa November 2003WebDNA 6.0 announcement Feb 17, 2004-MattOn 1/30/2012 8:50 AM, Kenneth Grome wrote:> Hi Matthew,>> Thanks for this very valuable information.>> I thought the host was running 6.2 but I checked the server> this morning and he is still running 6.0! This explains the> trigger problems I've been wasting my time on ... :(>> Does anyone remember when version 6.0 was released? I'm> thinking it was almost 10 years ago, is this correct?>> Sincerely,> Kenneth Grome>>>>> Kenneth,>>>> I've had the same issues on all my WebCat 4.x, 5.x, and>> 6.0 servers over the years. The problems does not seem>> to happen on 6.2 for me.>>>> In my case, I had many triggers in a single Sandbox that>> would work fine for months and then one of them would>> stop updating. Or, even stranger, it would update to>> some time into the future. It never happen often enough>> to figure out a pattern.>>>> My solution was to simply delete the next trigger date>> and time. Save. Open the trigger record again and let>> it fill in the next execute time on it's own.>>>> I always suspected that it would only happen when WebDNA>> was close to, or exceeded, the available RAM, but that's>> such a hard thing to figure out.>>>> -Matthew>>>> On 1/29/2012 6:53 PM, Kenneth Grome wrote:>>> Nope, just>>>>>> Sincerely,>>> Kenneth Grome>>>>>>> Typo in your "Validation Text" ?>>>>>>>> On 29/01/2012, at 4:29 PM, Kenneth Grome wrote:>>>>> I created a trigger on WebDNA 6.x via WebDNA Sandbox>>>>> Admin. This is the only trigger used in this sandbox.>>>>>>>>>> When it runs WebDNA fails update the "next execute">>>>> value like it is supposed to. Therefore the trigger>>>>> runs again every 10 seconds, and the same template is>>>>> interpreted by WebDNA again ...>>>>>>>>>> This is a "bad thing" when the template has a>>>>> sendmail context it it to alert me that the trigger>>>>> has run, because it sends me another email every 10>>>>> seconds. I got more than 1500 emails this morning>>>>> before the host put an end to it by rebooting the>>>>> server ... :(>>>>>>>>>> Flushing the databases does not stop the trigger from>>>>> running. Deleting the target template via FTP does>>>>> not stop it, because even though the file is no>>>>> longer on disk it is apparently still cached in RAM.>>>>> Strangely enough, the template seems to remain>>>>> cached in RAM , thus ignoring the WebCatalog Prefs>>>>> that's supposed to force the template out of ram>>>>> every 2 seconds. Issuing a FlushCache command also>>>>> fails to purge the template from RAM.>>>>>>>>>> :(>>>>>>>>>> My host refuses to investigate this issue. Whether>>>>> he is lazy, irresponsible, incompetent, or all of>>>>> the above, cannot say for certain. Nevertheless I>>>>> need the problem fixed, so I'll have to figure this>>>>> out myself, hopefully with some bright ideas from>>>>> others here.>>>>>>>>>> Any idea why WebDNA might fail to update the "next>>>>> execute" value when the trigger is run?>>>>>>>>>> Sincerely,>>>>> Kenneth Grome>>>>> ----------------------------------------------------->>>>> -- -- This message is sent to you because you are>>>>> subscribed to the mailing list. To>>>>> unsubscribe, E-mail to:>>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>>> Bug Reporting: support@webdna.us>>>> ------------------------------------------------------>>>> --- This message is sent to you because you are>>>> subscribed to the mailing list.>>>> To unsubscribe, E-mail to:>>>> archives: http://mail.webdna.us/list/talk@webdna.us>>>> Bug Reporting: support@webdna.us>>> ------------------------------------------------------->>> -- This message is sent to you because you are>>> subscribed to the mailing list.>>> To unsubscribe, E-mail to:>>> archives: http://mail.webdna.us/list/talk@webdna.us>>> Bug Reporting: support@webdna.us>>>>>>>>>>>>>>> Psi Prime, Inc.>>> 323 Union Blvd.>>> Totowa, NJ 07512>>>>>> Service: 973.413.8211>>> Training: 973.413.8214>>> Fax: 973.413.8217>>>>>> http://www.perosi.com>> --------------------------------------------------------->> This message is sent to you because you are subscribed to>> the mailing list.>> To unsubscribe, E-mail to:>> archives: http://mail.webdna.us/list/talk@webdna.us>> Bug Reporting: support@webdna.us> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list.> To unsubscribe, E-mail to:> archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us>>>> -- > Matthew A Perosi> Corporate Consultant> Mobile Marketing Expert> Senior Web Developer> SEO Analyst& Educator>> Psi Prime, Inc.> 323 Union Blvd.> Totowa, NJ 07512>> Service: 973.413.8211> Training: 973.413.8214> Fax: 973.413.8217>> http://www.perosi.com
"Psi Prime Inc, Matthew A Perosi "
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:
snicker, snicker (1997)
problems with WebCat-Plugin ()
More questions about serial number dishing (1997)
[WebDNA] limit found per row (2011)
Store Builder, technical infos (1998)
Storebuilder Problems...Looking for last minute heroic (2004)
More Hide IFs (2000)
Realtor Search (2000)
MySQL TIME_FORMAT (2005)
UNSUBSCRIBE ME (2004)
WebCatalog can't find database (1997)
Weird error/limit - something amiss? (1997)
[format 40s]text[/format] doesn't work (1997)
textarea question (1998)
Webcatalog and foreign languages (1998)
TARGET=window_name (1996)
Multiple prices (1997)
Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003)
banner ad redirection page (1999)
Before I Can Begin . . . (1998)