Strange DB could not be found error

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61650
interpreted = N
texte = Hello Everyone, We are experiencing a strange problem on one of our web pages. We have an include file that shows the featured items for the day. We track impressions on these items as well. Here is the problem. There are alot of "Error: the database cannot be found or opened" messages cropping up. As in several every minute or two. But the funny thing is that it will still display what is searched for. We have also experienced times when the databases for these items have gotten corrupted. Here is the code that displays and counts impressions for the items: [search db=blah/blah/this.db&neidNumberdata=[blank]&IDNUMBERsort=1&IDNUMBERsdir=ra&E NDDATEtype=date&geENDDATEdatarq=[date]&STARTDATEtype=date&leSTARTDATEdatarq= [date]&max=3] [founditems] [replace db=blah/blah/this.db&eqidnumberdatarq=[idnumber]]hits=[math][hits]+1[/math][ /replace] [Name]
[Info]

[/founditems] [/search] When the error displays, it displays 3 times, once for each item. This is on the homepage that gets ALOT of traffic. I have checked permissions on everything and cannot figure out why this is happening. I think it may be a problem with writing the updated stats to the database and trying to read it at the same time because of all the traffic. Is that possible? I also tried adding the [ExclusiveLock] to it but it gave me an error message that it could not get exclusive access to the DB. Any ideas would be greatly appreciated!!! Thanks, Eric Miller Web Developer/Programmer The GoTriCities Network ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Strange DB could not be found error ( "Eric Miller" 2005)
Hello Everyone, We are experiencing a strange problem on one of our web pages. We have an include file that shows the featured items for the day. We track impressions on these items as well. Here is the problem. There are alot of "Error: the database cannot be found or opened" messages cropping up. As in several every minute or two. But the funny thing is that it will still display what is searched for. We have also experienced times when the databases for these items have gotten corrupted. Here is the code that displays and counts impressions for the items: [search db=blah/blah/this.db&neidNumberdata=[blank]&IDNUMBERsort=1&IDNUMBERsdir=ra&E NDDATEtype=date&geENDDATEdatarq=[date]&STARTDATEtype=date&leSTARTDATEdatarq= [date]&max=3] [founditems] [replace db=blah/blah/this.db&eqidnumberdatarq=[idnumber]]hits=[math][hits]+1[/math][ /replace] [Name]
[Info]

[/founditems] [/search] When the error displays, it displays 3 times, once for each item. This is on the homepage that gets ALOT of traffic. I have checked permissions on everything and cannot figure out why this is happening. I think it may be a problem with writing the updated stats to the database and trying to read it at the same time because of all the traffic. Is that possible? I also tried adding the [exclusivelock] to it but it gave me an error message that it could not get exclusive access to the DB. Any ideas would be greatly appreciated!!! Thanks, Eric Miller Web Developer/Programmer The GoTriCities Network ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ "Eric Miller"

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:

Can you do this??? and other stuff (1997) [date] +1 (1999) [HIDEIF] inside [FOUNDITEM] (1997) Server capacity (2003) No more misunderstanding ... yay! :) (1997) WCS Newbie question (1997) webcat serving multiple copies of same db from ram (2000) Problems passing [SKU] with $Replace in 2.0 (1997) [math] show=F exists? (1997) Don'y know if this is a sily question... (2003) Apache Question (2003) A question about security (1998) 5.0 feature request: (2001) Database Sizes (2000) Extended [ConvertChars] (1997) WebDNA maxing out processor (2008) notification solutions (1997) 2cd pair of eyes (2003) Mac ticks v PC ticks... (2002) searching numbers (1998)