Re: Database access

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 46660
interpreted = N
texte = 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 AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Database access (Glenn Busbin 2003)
  2. Re: Database access (Christer Olsson 2003)
  3. Re: Database access (Donovan 2003)
  4. Re: Database access (lb Lawrence 2003)
  5. Re: Database access (Alex McCombie 2003)
  6. Re: Database access (Frank Nordberg 2003)
  7. Re: Database access (Glenn Busbin 2003)
  8. Database access (Frank Nordberg 2003)
  9. Re: Database Access... (Kenneth Grome 2000)
  10. Database Access... (Jeff Homan 2000)
  11. WebDNA database access and the future of SQL (Patrick McCormick WebD)
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 AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface 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/ Alex McCombie

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:

Pithy questions on webcommerce & siteedit (1997) Web Logs (1998) Summing fields (1997) SiteGuard Use Question (1997) IIS Brain Dead (1998) More on the email templates (1997) Emailer Chokes on bad address (1997) PSC recommends what date format yr 2000??? (1997) TemplateCacheSize preference (1998) Nested Loops and SHOWIFs (1997) RE: new cart IDs being assigned somehow (1997) WebTen? (1997) Unusual characters in the db ... (2002) Date Formats (1997) Not really WebCat- (1997) form validator issue (2005) emailer (1997) Possible Bug in 2.0b15.acgi (1997) A better WebCat whois (was [OT] Domain Name Scam) (2000) Generating Report Totals (1997)