Re: [WebDNA] [BULK] strange triggers.db occurrence???
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108888
interpreted = N
texte = Until a few months ago I saw this problem all the time. Donovan explained it well, but here's some other information I've figured out too. On one of my older servers this problem would occur when VERY large databases in RAM were getting close to the physical limit of the server, and in use at the same time one of the Triggers fired and needed to be updated. However, not having enough physical memory to load Triggers.db I would always see Triggers.db-oRiGiNaL- created at the same time Triggers.db was wiped out. Upon close inspection over and over again I always found Triggers.db-oRiGiNaL- to be a viable DB. Renaming it back to Triggers.db is all it needs. I've never seen this problem with any other DB either, although I attribute that to the fact that Triggers is fired several times a second. I've only seen this problem on 6.0, RedHat 4ES, 4GB RAM. -Matt On 3/21/2012 8:21 PM, Marc Thompson wrote: > Anyone ever seen a Triggers.db file get renamed like so? > Triggers.db-oRiGiNaL- > or > Triggers.db-tmp > > I found those two files in my WebCatalogEngine folder today with NO > Triggers.db file!? > WebDNA Version 6.2 on ubuntu 10 > > Marc > > On 3/21/2012 5:14 PM, Donovan Brooke wrote: >> Tony Miller wrote: >>> All, >>> >>> I have WebDNA 6.2 eCommerce and have a couple sites that want to >>> be able to handle recurring orders. They have customers who want >>> to have the same order shipped each month or every-other month. >>> They are keeping track of them manually now and would like to just >>> be able to have the orders process each month. I did see the >>> 'recurringItem' field in the cart.db so thought it might be >>> possible somehow. >>> >>> Do the StoreBuilder storefronts have the ability to handle >>> recurring orders built-in? I've been searching through the talk >>> lists and documentation, but haven't come across anything so far. >>> The only thing that seems to come close is the AuthorizeNet Auth >>> Type 'Auth_Only' setting. Right now the sites are set to >>> 'Auth_Capture'. >>> >>> Thought I'd throw it out there and see if anyone's run into this. >>> >>> Tony Miller >>> tmiller@thehawkeye.com >> >> >> Hi Tony, little known to folks is that 6.2 has a "subscription" >> feature that was built into StoreBuilder by SMSI, but never released >> to the public. However, I left it in 6.2. ;-) >> >> Now, I haven't tested it, but you can find it by logging into the >> StoreBuilder admin, then scrolling down to the "Subscriptions" link. >> >> Perhaps if Doug Deck is listening, he may know more about this? >> >> Donovan >> >> > > > -- > 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:
Until a few months ago I saw this problem all the time. Donovan explained it well, but here's some other information I've figured out too. On one of my older servers this problem would occur when VERY large databases in RAM were getting close to the physical limit of the server, and in use at the same time one of the
triggers fired and needed to be updated. However, not having enough physical memory to load
triggers.db I would always see
triggers.db-oRiGiNaL- created at the same time
triggers.db was wiped out. Upon close inspection over and over again I always found
triggers.db-oRiGiNaL- to be a viable DB. Renaming it back to
triggers.db is all it needs. I've never seen this problem with any other DB either, although I attribute that to the fact that
triggers is fired several times a second. I've only seen this problem on 6.0, RedHat 4ES, 4GB RAM. -Matt On 3/21/2012 8:21 PM, Marc Thompson wrote: > Anyone ever seen a
triggers.db file get renamed like so? >
triggers.db-oRiGiNaL- > or >
triggers.db-tmp > > I found those two files in my WebCatalogEngine folder today with NO >
triggers.db file!? > WebDNA Version 6.2 on ubuntu 10 > > Marc > > On 3/21/2012 5:14 PM, Donovan Brooke wrote: >> Tony Miller wrote: >>> All, >>> >>> I have WebDNA 6.2 eCommerce and have a couple sites that want to >>> be able to handle recurring orders. They have customers who want >>> to have the same order shipped each month or every-other month. >>> They are keeping track of them manually now and would like to just >>> be able to have the orders process each month. I did see the >>> 'recurringItem' field in the cart.db so thought it might be >>> possible somehow. >>> >>> Do the StoreBuilder storefronts have the ability to handle >>> recurring orders built-in? I've been searching through the talk >>> lists and documentation, but haven't come across anything so far. >>> The only thing that seems to come close is the AuthorizeNet Auth >>> Type 'Auth_Only' setting. Right now the sites are set to >>> 'Auth_Capture'. >>> >>> Thought I'd throw it out there and see if anyone's run into this. >>> >>> Tony Miller >>> tmiller@thehawkeye.com >> >> >> Hi Tony, little known to folks is that 6.2 has a "subscription" >> feature that was built into StoreBuilder by SMSI, but never released >> to the public. However, I left it in 6.2. ;-) >> >> Now, I haven't tested it, but you can find it by logging into the >> StoreBuilder admin, then scrolling down to the "Subscriptions" link. >> >> Perhaps if Doug Deck is listening, he may know more about this? >> >> Donovan >> >> > > > -- > 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:
[include ...] behavior (1997)
Formulas.db / Quantity Discount problem (1998)
F*** you (1998)
Parse question (2005)
updating the database (2000)
Press Release hit the NewsWire!!! (1997)
HELP WITH DATES (1997)
Setting up WebCatalog with Retail Pro data (1996)
Truncated value after space - refresh my memory.... (1997)
Is Web Merchant Necessary? (2000)
creating writefile data from a nested search (1997)
Emailer [cart] file names (1997)
Adding To items to cart at once (1999)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
&fieldsdir=ra truely random?? (2000)
Re:Emailer problem....still (1997)
Where has WebDNA shown up in your life? (2003)
Odd [math] behaviour (2003)
Dynamic Pop Up Menus with Record Value Selected (1998)
Addlineitems ... grrr (2004)