In case you have not figured this out already, there's a table called "error"
in V1.2 of the Webinator. The purpose of this table is to (of course) log
errors in such a manner as to enable SQL queries to create various reports.
The most important report is probably the one that lists where
you have HREFs to non-existing documents. The following gw command
will generate this report:
gw -s "select refs.Url,error.Url from error,refs where refs.Ref = error.Url and Reason = 'Document not found'"
The output report will show you:
www.yourserver.com/this_document.html
www.yourserver.com/has_this_bad_link.html
.
.
.
If you want to get _really_ fancy about it, gw will can create an
HTML form of the report so that you can actually view the bad links
with a browser:
gw -d. -sh "select '<a href=http://'+refs.Url+'>'+refs.Url+'</a>',error.Url from error,refs where refs.Ref = error.Url and Reason = 'Document not found' | grep -v '<th>' > ~htdocs/errorlist.html
notes: 1: This is all one long command line.
2: Make sure your shell doesn't grok the '<' and '>' inside the quotes.
3: The grep -v command gets rid of the column headers
4: ~htdocs = someplace in your web docs directory
5: The '+' operator in the SQL adds a constant to the column value.
If you want to know more about Texis SQL see:
http://www.thunderstone.com/texisman/texis.html
Have Fun,
Bart Richards
Thunderstone