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 aninclude file that shows the featured items for the day. We track impressionson these items as well.Here is the problem. There are alot of "Error: the database cannot be foundor opened" messages cropping up. As in several every minute or two. But thefunny thing is that it will still display what is searched for. We have alsoexperienced times when the databases for these items have gotten corrupted.Here is the code that displays and counts impressions for the items:[searchdb=blah/blah/this.db&neidNumberdata=[blank]&IDNUMBERsort=1&IDNUMBERsdir=ra&ENDDATEtype=date&geENDDATEdatarq=[date]&STARTDATEtype=date&leSTARTDATEdatarq=[date]&max=3][founditems][replacedb=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 onthe homepage that gets ALOT of traffic. I have checked permissions oneverything and cannot figure out why this is happening.I think it may be a problem with writing the updated stats to the databaseand trying to read it at the same time because of all the traffic. Is thatpossible? I also tried adding the [ExclusiveLock] to it but it gave me anerror message that it could not get exclusive access to the DB.Any ideas would be greatly appreciated!!!Thanks,Eric MillerWeb Developer/ProgrammerThe 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:
|
- 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 aninclude file that shows the featured items for the day. We track impressionson these items as well.Here is the problem. There are alot of "Error: the database cannot be foundor opened" messages cropping up. As in several every minute or two. But thefunny thing is that it will still display what is searched for. We have alsoexperienced times when the databases for these items have gotten corrupted.Here is the code that displays and counts impressions for the items:[searchdb=blah/blah/this.db&neidNumberdata=[blank]&IDNUMBERsort=1&IDNUMBERsdir=ra&ENDDATEtype=date&geENDDATEdatarq=[date]&STARTDATEtype=date&leSTARTDATEdatarq=[date]&max=3][founditems][replacedb=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 onthe homepage that gets ALOT of traffic. I have checked permissions oneverything and cannot figure out why this is happening.I think it may be a problem with writing the updated stats to the databaseand trying to read it at the same time because of all the traffic. Is thatpossible? I also tried adding the [exclusivelock] to it but it gave me anerror message that it could not get exclusive access to the DB.Any ideas would be greatly appreciated!!!Thanks,Eric MillerWeb Developer/ProgrammerThe 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:
Sandboxes (2004)
[WebDNA] WebDNA 6.2 ErrorLog.txt (2014)
Secure server question (1997)
Attn: Bug in GeneralStore example b15 (1997)
Math with Time (1997)
[returnraw] and form variables (1998)
Duplicate Carts (2006)
MacAuthorize order data fields WAS:How To question... (1997)
limitation found on group searching (1997)
OS X (2000)
Intermitent problem using [referrer] (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Web Catalog Instability (2000)
Autoreturn Submit? (1997)
Fufillment e-mail? (1998)
service stop and restart (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Error Log.db --however (1997)
Most Recent version of WebDNA For RH ES (2006)
How do you TEAM Code? (2004)