Re: Database access
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 46662
interpreted = N
texte = Reading Frank's problem. I have checked 2 db.http://www.royaltyfreephoto.com/admin/cd.db (1mb) and http://www.royaltyfreephoto.com/admin/states.dbthe first one can not be seen using fetch or ie, the second can. The first one has been access often and written by webcat. The second one has been written in BBedit.Isn't the protection effective once webcat has written or modified the db?Lawrence le 6/01/03 15:04, Alex McCombie à alex@newworldmedia.com a écrit :> On 1/5/03 2:09 PM, Frank Nordberg
wrote: > >> My WebCatalog error log is pretty useless most of the time (less than >> one error in ten thousand is actually shown there), but suddenly it came >> up with this: >> date time command ipaddress errormessage >> 05.01.2003 18:22:40 SHOWPAGE 064.154.072.055 Error: the database >> '/wc/base.db' could not be found or opened > This is not likely what you think it is. > > If I had to give an opinion I would say that this is a read/write error on a > db that isnt using exclusive lock and is being written to and read from at > the same time (or at least tried to) which results in this error from > webcat. > > Secondly, since it is an error that appear on a webcat page it is logged > into the webcat error page. > > To see an example just create a page that tries to search a non-existent Db > or call a missing includes file. Your log file will show the same style. > > > 2 things. > 1 Make sure .db is not a valid Webcat extension (to protect your db from > direct DL). > > 2 Check the db that generated the errors above. Find out where you call it > and wrap it in a an exclusive lock. > > HTH > Alex > > > > > > Alex J McCombie New World Media > Chief Information Officer Drawer 607 > 800/724.8973 Fair Haven, NY 13064 > Alex@NewWorldMedia.com http://OurClients.com > > Interface Designer WebDNA Programmer Database Designer > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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:
Reading Frank's problem. I have checked 2 db.http://www.royaltyfreephoto.com/admin/cd.db (1mb) and http://www.royaltyfreephoto.com/admin/states.dbthe first one can not be seen using fetch or ie, the second can. The first one has been access often and written by webcat. The second one has been written in BBedit.Isn't the protection effective once webcat has written or modified the db?Lawrence le 6/01/03 15:04, Alex McCombie à alex@newworldmedia.com a écrit :> On 1/5/03 2:09 PM, Frank Nordberg wrote: > >> My WebCatalog error log is pretty useless most of the time (less than >> one error in ten thousand is actually shown there), but suddenly it came >> up with this: >> date time command ipaddress errormessage >> 05.01.2003 18:22:40 SHOWPAGE 064.154.072.055 Error: the database >> '/wc/base.db' could not be found or opened > This is not likely what you think it is. > > If I had to give an opinion I would say that this is a read/write error on a > db that isnt using exclusive lock and is being written to and read from at > the same time (or at least tried to) which results in this error from > webcat. > > Secondly, since it is an error that appear on a webcat page it is logged > into the webcat error page. > > To see an example just create a page that tries to search a non-existent Db > or call a missing includes file. Your log file will show the same style. > > > 2 things. > 1 Make sure .db is not a valid Webcat extension (to protect your db from > direct DL). > > 2 Check the db that generated the errors above. Find out where you call it > and wrap it in a an exclusive lock. > > HTH > Alex > > > > > > Alex J McCombie New World Media > Chief Information Officer Drawer 607 > 800/724.8973 Fair Haven, NY 13064 > Alex@NewWorldMedia.com http://OurClients.com > > Interface Designer WebDNA Programmer Database Designer > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/
lb Lawrence
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:
Server Freeze (1998)
Re1000001: Setting up shop (1997)
[WebDNA] is webdna.us site having issues? (2018)
ANother SHOWIF problem (1997)
Delete tag (2000)
Multipart/alternative e-mail (2003)
[WebDNA] NOT serving WebDNA, just running it locally. (2012)
[delete] problem (1997)
Uploading Files and Descriptions W* (2000)
Nested vs conditional (1997)
[BULK] [WebDNA] How to code a 301 redirect (2009)
[WebDNA] mail header timezone problem (2008)
whole word matching (2004)
can WC render sites out? (1997)
multi-paragraph fields (1997)
2nd WebCatalog2 Feature Request (1996)
Replace with Producteditor.tpl (2000)
[click][/click] (1999)
[random] only for 1-100??? (1997)
Graphing Modules (2004)