Re: webcat serving up 2+ versions of the same db?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26846
interpreted = N
texte = Do you have any aliases (well, symlinks in your case) in the path to yourdatabase?I've seen the Mac version get confused when more than one file path (thehard path and a path with an alias in it) is used to access the samedatabase. This only seems to be a problem with aliased folders in the path,*not* with aliases of the database file itself.You should be able see if WebCat is actually opening up more than one copyof a database by using [ListDatabases] or by viewing the page in the WebCatadmin that shows all open databases.At 3:14 PM 2/1/00, John Butler wrote:>I think I posted this already... but just in case->>I have some admin templates that allow the admin to add/modify/delete>products. No>Problem... the templates have been working fine for weeks and I haven't>been messing with>the code other than tiny cosmetic things. The problem is that all of a>sudden webcat>seems to be holding two (or more?) conflicting versions of the product>db in cache. So>when the admin modifies a product and then goes back to the product>catalog listing (a>search that finds all products and lists them each in their own table>row) she may see>that the product has been modified or maybe it has not. Or another>example - if she>deletes a product then goes back to the catalog listing, it shows the>product has not been>deleted, or maybe it has. I have her on the phone and I say, hold on>don't do>anything. She freezes. I force reload the catalog listing repeatedly>and on every>refresh the template loads one of the apparent 2 versions of the product>database... at>the top I have [numfound] and it says 60 I reload and it says 61. I>reload and it>says 60.... On and on... I close the database (via [closedatabase])>and then it>stops, 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 of>the 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), but>the ram version(s) are not consistent/stable...>>Any clues?>>(On Linux, webcat 3.06f)>>-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>-------------------------------------------------------------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:
Do you have any aliases (well, symlinks in your case) in the path to yourdatabase?I've seen the Mac version get confused when more than one file path (thehard path and a path with an alias in it) is used to access the samedatabase. This only seems to be a problem with aliased folders in the path,*not* with aliases of the database file itself.You should be able see if WebCat is actually opening up more than one copyof a database by using [listdatabases] or by viewing the page in the WebCatadmin that shows all open databases.At 3:14 PM 2/1/00, John Butler wrote:>I think I posted this already... but just in case->>I have some admin templates that allow the admin to add/modify/delete>products. No>Problem... the templates have been working fine for weeks and I haven't>been messing with>the code other than tiny cosmetic things. The problem is that all of a>sudden webcat>seems to be holding two (or more?) conflicting versions of the product>db in cache. So>when the admin modifies a product and then goes back to the product>catalog listing (a>search that finds all products and lists them each in their own table>row) she may see>that the product has been modified or maybe it has not. Or another>example - if she>deletes a product then goes back to the catalog listing, it shows the>product has not been>deleted, or maybe it has. I have her on the phone and I say, hold on>don't do>anything. She freezes. I force reload the catalog listing repeatedly>and on every>refresh the template loads one of the apparent 2 versions of the product>database... at>the top I have [numfound] and it says 60 I reload and it says 61. I>reload and it>says 60.... On and on... I close the database (via [closedatabase])>and then it>stops, 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 of>the 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), but>the ram version(s) are not consistent/stable...>>Any clues?>>(On Linux, webcat 3.06f)>>-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>-------------------------------------------------------------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
Dave MacLeay
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:
Database Posting (2000)
X etc.... (1999)
[subtotal] and others (1997)
[SearchString] usage (1997)
Reversing [ipaddress] normalization (1998)
RealAudio .ram files (2000)
WebMerchant Only reads 1.4 order files error (1997)
date (1999)
[applescript] (1999)
Where's Cart Created ? (1997)
Huge Problem installing Secure Certs (2006)
Sorry WebCatalog server not running. (2002)
quotation marks (2004)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Help! WebCat2 bug (1997)
customizing the color of user's pages (1997)
typhoon... (1997)
WebSTAR/WebCat is serving .db files! (1999)
Help! WebCat2 bug (1997)
Template Security error (1997)