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 your database?I've seen the Mac version get confused when more than one file path (the hard path and a path with an alias in it) is used to access the same database. 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 copy of a database by using [ListDatabases] or by viewing the page in the WebCat admin 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 your database?I've seen the Mac version get confused when more than one file path (the hard path and a path with an alias in it) is used to access the same database. 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 copy of a database by using [listdatabases] or by viewing the page in the WebCat admin 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)