webcat serving up 2+ versions of the same db!!!??

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 26802
interpreted = N
texte = I am real spooked.On Linux, webcat 3.06f,I have some admin templates that allow the admin to add/modify/delete products. NoProblem... the templates have been working fine for weeks and I haven't been messing withthe code other than tiny cosmetic things. The problem is that all of a sudden webcatseems to be holding two (or more?) conflicting versions of the product db in cache. Sowhen the admin modifies a product and then goes back to the product catalog listing (asearch that finds all products and lists them each in their own table row) she may seethat the product has been modified or maybe it has not. Or another example - if shedeletes a product then goes back to the catalog listing, it shows the product has not beendeleted, or maybe it has. I have her on the phone and I say, hold on don't doanything. She freezes. I force reload the catalog listing repeatedly and on everyrefresh the template loads one of the apparent 2 versions of the product database... atthe top I have [numfound] and it says 60 I reload and it says 61. I reload and itsays 60.... On and on... I close the database (via [closedatabase]) and then itstops, but as soon as any action is taken which tries to modify the database in any way,the same problem arises again. And for sure no one else is in with any access to any ofthe templates... When I download the db and look in with BBedit I see the correct version(so it seems the [commitdatabase] is working on the right version at the right time), butthe ram version(s) are not consistent/stable...I think webcat is haunted... this is not good... (ultimately the product db will bechanging all the time during remote business transactions as inventory control code doesits job etc... I guess I don't need to point out further why this behaviour is bad...)Any clues?-John-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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  Associated Messages, from the most recent to the oldest:

I am real spooked.On Linux, webcat 3.06f,I have some admin templates that allow the admin to add/modify/delete products. NoProblem... the templates have been working fine for weeks and I haven't been messing withthe code other than tiny cosmetic things. The problem is that all of a sudden webcatseems to be holding two (or more?) conflicting versions of the product db in cache. Sowhen the admin modifies a product and then goes back to the product catalog listing (asearch that finds all products and lists them each in their own table row) she may seethat the product has been modified or maybe it has not. Or another example - if shedeletes a product then goes back to the catalog listing, it shows the product has not beendeleted, or maybe it has. I have her on the phone and I say, hold on don't doanything. She freezes. I force reload the catalog listing repeatedly and on everyrefresh the template loads one of the apparent 2 versions of the product database... atthe top I have [numfound] and it says 60 I reload and it says 61. I reload and itsays 60.... On and on... I close the database (via [closedatabase]) and then itstops, but as soon as any action is taken which tries to modify the database in any way,the same problem arises again. And for sure no one else is in with any access to any ofthe templates... When I download the db and look in with BBedit I see the correct version(so it seems the [commitdatabase] is working on the right version at the right time), butthe ram version(s) are not consistent/stable...I think webcat is haunted... this is not good... (ultimately the product db will bechanging all the time during remote business transactions as inventory control code doesits job etc... I guess I don't need to point out further why this behaviour is bad...)Any clues?-John-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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  John Butler

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:

japanese characters (1997) Error Lob.db records error message not name (1997) Problem with Formulas.db (1998) why is this line in GeneralStore? (1998) PCS Frames (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Roundup function? (1997) Running 2 two WebCatalog.acgi's (1996) Another question (1997) Some shell fun (2004) Lookup command (1998) Hello??? (1997) Need relative path explanation (1997) convert characters (2003) Expires header (1999) pc (1997) WebCat2 - Getting to the browser's username/password data (1997) dos performance (1998) [WebDNA] duplicate cookies being stored in browser (2010) Webcat causing crashes left and right! (1997)