Re: [Webware-discuss] RE: a patch for better email error notification

Thu, 14 Mar 2002 14:02:58 -0800 

On Thursday 14 March 2002 14:05, Chuck Esterbrook wrote:
> On Thursday 14 March 2002 11:44 am, Tavis Rudd wrote:
> > On Thursday 14 March 2002 10:22, Geoffrey Talvola wrote:
> > >�Tavis Rudd wrote:
> > >�> Geoff,
> > >�> here's a patch to make ExceptionHandler.py email the HTML
> > > error > reports as attachments rather than as part of the
> > > message body. > It makes it easier to save or forward them.
> > >�> Tavis
> > >
> > >�I don't have any trouble saving or forwarding exception emails
> > >�right now. And isn't it harder to view the error report if it's
> > > an attachment?
> >
> > For various reasons I set my email clients to display plain text
> > rather than HTML in the message body. �It would be nice to have a
> > plain text traceback that precedes the HTML version in the email.
>
> Sounds like a multi-part MIME message with a text part and an html
> part would solve this. The default behavior would send both and a
> config would allow you to axe one of them out.

How does this look?



----------  Forwarded Message  ----------

Subject: A Webware Error Occurred
Date: Thu, 14 Mar 2002 12:59:13 -0800
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

WebKit caught an exception while processing a request for
 "/WK/ImageManager" at Thu Mar 14 12:59:12 2002 (timestamp:   
  1016139552.85).  The plain text trackeback from Python is 
  printed below and the full HTMLerror report from WebKit 
  is attached.

Traceback (most recent call last):
  File
 "/usr/local/lib/python2.2/site-packages/Webware/WebKit/Application.p
y", line 448, in _dispatchRequest servlet.respond(trans)
  File
 "/usr/local/lib/python2.2/site-packages/Webware/Cheetah/Templates/Sk
eletonPage.py", line 225, in respond self.writeBody(trans=trans) #
 generated from ('writeBody', '#block writeBody') at line, col (48,
 1). File
 "/var/www/www.calrudd.com/Webware/Servlets/SiteTemplate.py", line
 408, in writeBody self.writeMainContents(trans=trans) # generated
 from ('writeMainContents', '#block writeMainContents') at line, col
 (33, 1). File
 "/var/www/www.calrudd.com/Webware/Servlets/ImageManager.py", line
 489, in writeMainContents write(filter(VFS(SL,"writeImageTable",1)))
 # generated from '$writeImageTable' at line, col (9, 1). File
 "/var/www/www.calrudd.com/Webware/Servlets/ImageManager.py", line
 228, in writeImageTable for id, img in
 VFN(VFS(SL,"getImagesForSelections",0)(VFS(SL,"session.pw_selections
",1)),"items",0)(): File
 "/var/www/www.calrudd.com/Webware/Servlets/_ImageManager.py", line
 40, in getImagesForSelections cursor.execute("""
ProgrammingError: ERROR:  Relation 'pw__image' does not exist



        SELECT *
        FROM pw__image im, pw__images_selections im_sel
        WHERE im.id=im_sel.im_id AND im_sel.sel_id  = 'bindley'

-------------------------------------------------------
Title: An Error Has Occurred


Error
The site is having technical difficulties with this page. The problem has been logged and will be fixed as soon as possible. Sorry!


Traceback 
Traceback (most recent call last):
  File "/usr/local/lib/python2.2/site-packages/Webware/WebKit/Application.py", line 448, in _dispatchRequest
    servlet.respond(trans)
  File "/usr/local/lib/python2.2/site-packages/Webware/Cheetah/Templates/SkeletonPage.py", line 225, in respond
    self.writeBody(trans=trans) # generated from ('writeBody', '#block writeBody') at line, col (48, 1).
  File "/var/www/www.calrudd.com/Webware/Servlets/SiteTemplate.py", line 408, in writeBody
    self.writeMainContents(trans=trans) # generated from ('writeMainContents', '#block writeMainContents') at line, col (33, 1).
  File "/var/www/www.calrudd.com/Webware/Servlets/ImageManager.py", line 489, in writeMainContents
    write(filter(VFS(SL,"writeImageTable",1))) # generated from '$writeImageTable' at line, col (9, 1).
  File "/var/www/www.calrudd.com/Webware/Servlets/ImageManager.py", line 228, in writeImageTable
    for id, img in VFN(VFS(SL,"getImagesForSelections",0)(VFS(SL,"session.pw_selections",1)),"items",0)():
  File "/var/www/www.calrudd.com/Webware/Servlets/_ImageManager.py", line 40, in getImagesForSelections
    cursor.execute("""
ProgrammingError: ERROR:  Relation 'pw__image' does not exist



        SELECT *
        FROM pw__image im, pw__images_selections im_sel
        WHERE im.id=im_sel.im_id AND im_sel.sel_id  = 'bindley'


Misc Info
os.getcwd() /var/www/www.calrudd.com/Webware/WorkingDir  
sys.path ['/usr/local/bin', '/usr/local/lib/python2.2', '/usr/local/lib/python2.2/plat-linux2', '/usr/local/lib/python2.2/lib-tk', '/usr/local/lib/python2.2/lib-dynload', '/usr/local/lib/python2.2/site-packages', '/usr/local/lib/python2.2/site-packages/PIL', '/usr/local/lib/python2.2/site-packages/Webware', 'Cache/PSP']  
time Thu Mar 14 12:59:12 2002  


Fields


Environment
DOCUMENT_ROOT /var/www/www.calrudd.com/public_html  
GATEWAY_INTERFACE CGI/1.1  
HTTP_ACCEPT text/*, image/jpeg, image/png, image/*, */*  
HTTP_ACCEPT_CHARSET iso-8859-1, utf-8, *  
HTTP_ACCEPT_ENCODING x-gzip, gzip, identity  
HTTP_ACCEPT_LANGUAGE en, en_US  
HTTP_CACHE_CONTROL no-cache  
HTTP_CONNECTION Keep-Alive  
HTTP_HOST calrudd.com  
HTTP_PRAGMA no-cache  
HTTP_USER_AGENT Mozilla/5.0 (compatible; Konqueror/2.2.1; Linux)  
PATH /sbin:/bin:/usr/sbin:/usr/bin  
PATH_INFO /ImageManager  
PATH_TRANSLATED /var/www/www.calrudd.com/public_html/ImageManager  
QUERY_STRING  
REMOTE_ADDR 10.0.0.10  
REMOTE_PORT 33074  
REQUEST_METHOD GET  
REQUEST_URI /WK/ImageManager  
SCRIPT_FILENAME /var/www/www.calrudd.com/public_html/WK  
SCRIPT_NAME /WK  
SCRIPT_URI http://www.calrudd.com/WK/ImageManager  
SCRIPT_URL /WK/ImageManager  
SERVER_ADDR 10.0.0.1  
SERVER_ADMIN [EMAIL PROTECTED]  
SERVER_NAME www.calrudd.com  
SERVER_PORT 80  
SERVER_PROTOCOL HTTP/1.1  
SERVER_SIGNATURE
Apache/1.3.22 Server at www.calrudd.com Port 80
 
SERVER_SOFTWARE Apache/1.3.22 (Unix) mod_ssl/2.8.5 OpenSSL/0.9.6c mod_webkit/0.5 PHP/4.1.1 mod_python/2.7.6 Python/2.2  
URI_MINUS_QSTRING /WK/ImageManager  


Ids
namevalue
getegid100
geteuid510
getgid100
getpgrp4305
getpid4322
getppid4309
getuid510


Fancy Traceback
ProgrammingError: ERROR: Relation 'pw__image' does not exist SELECT * FROM pw__image im, pw__images_selections im_sel WHERE im.id=im_sel.im_id AND im_sel.sel_id = 'bindley'_ImageManager:   40
ImageManager:  228
ImageManager:  489
SiteTemplate:  408
SkeletonPage:  225
Application:  468

A problem occurred while running a Python script. Here is the sequence of function calls leading up to the error, with the most recent (innermost) call first.

Servlets/_ImageManager in getImagesForSelections(self=<ROOT_ROOT.ImageManager.ImageManager instance>, selectionIds=(('bindley',),))
   38         
    39         cursor = self._dbConn.cursor()
   40         cursor.execute("""
       cursor = <cursor object>, cursor.execute = <built-in method execute of cursor object>, selectionSQL = " = 'bindley'"
   41 
    42         SELECT *

Servlets/ImageManager in writeImageTable(self=<ROOT_ROOT.ImageManager.ImageManager instance>, trans=<Cheetah.DummyTransaction.DummyTransaction instance>, dummyTrans=1, VFS=<built-in function valueFromSearchList>, VFN=<built-in function valueForName>, getmtime=<function getmtime>, currentTime=<built-in function time>)
  226         odd = True
   227         write('')
  228         for id, img in VFN(VFS(SL,"getImagesForSelections",0)(VFS(SL,"session.pw_selections",1)),"items",0)():
       id = undefined, img = undefined, VFN = <built-in function valueForName>, VFS = <built-in function valueFromSearchList>, SL = [{}, <ROOT_ROOT.ImageManager.ImageManager instance>, {'bodyTagAttribs': {'text': 'black'}, 'docType': '', 'htmlTag': '', 'javascriptLibs': {}, 'javascriptTags': {}, 'metaTags': {'HTTP_EQUIV': {'keywords': 'Cheetah,'}, 'NAME': {'generator': 'Cheetah: The Python-Powered Template Engine'}}, 'siteCopyrightName': 'Tavis Rudd', 'siteCredits': 'Designed & Implemented by Tavis Rudd', 'siteDomainName': 'www.CheetahTemplate.org', 'stylesheetLibs': {'global stylesheet': 'GlobalStylesheets/calrudd.css'}, ...}] (complete)
  229             write('')
   230             src = 'ImageStore/Small/' + str(VFN(img,"id",1)) + '.jpg'

Servlets/ImageManager in writeMainContents(self=<ROOT_ROOT.ImageManager.ImageManager instance>, trans=<WebKit.Transaction.Transaction instance>, dummyTrans=0, VFS=<built-in function valueFromSearchList>, VFN=<built-in function valueForName>, getmtime=<function getmtime>, currentTime=<built-in function time>)
  487         write(filter(VFS(SL,"writeSelectProjectForm",1))) # generated from '$writeSelectProjectForm' at line, col (8, 1).
   488         write('\n')
  489         write(filter(VFS(SL,"writeImageTable",1))) # generated from '$writeImageTable' at line, col (9, 1).
       write = <bound method Response.write of <WebKit.Response.Response instance at 0x81af2ec>>, filter = <bound method Filter.filter of <Cheetah.Filters.Filter instance at 0x838d7e4>>, VFS = <built-in function valueFromSearchList>, SL = [{}, <ROOT_ROOT.ImageManager.ImageManager instance>, {'bodyTagAttribs': {'text': 'black'}, 'docType': '', 'htmlTag': '', 'javascriptLibs': {}, 'javascriptTags': {}, 'metaTags': {'HTTP_EQUIV': {'keywords': 'Cheetah,'}, 'NAME': {'generator': 'Cheetah: The Python-Powered Template Engine'}}, 'siteCopyrightName': 'Tavis Rudd', 'siteCredits': 'Designed & Implemented by Tavis Rudd', 'siteDomainName': 'www.CheetahTemplate.org', 'stylesheetLibs': {'global stylesheet': 'GlobalStylesheets/calrudd.css'}, ...}] (complete)
  490         write('\n\n')
   491         #  Methods

Servlets/SiteTemplate in writeBody(self=<ROOT_ROOT.ImageManager.ImageManager instance>, trans=<WebKit.Transaction.Transaction instance>, dummyTrans=0, VFS=<built-in function valueFromSearchList>, VFN=<built-in function valueForName>, getmtime=<function getmtime>, currentTime=<built-in function time>)
  406         self.writeNavBarSpacerBottom(trans=trans) # generated from ('writeNavBarSpacerBottom', '#block writeNavBarSpacerBottom') at line, col (27, 1).
   407         write('\n<!-- PAGE CONTENTS - START -->\n')
  408         self.writeMainContents(trans=trans) # generated from ('writeMainContents', '#block writeMainContents') at line, col (33, 1).
       trans = <WebKit.Transaction.Transaction instance>
  409         write('''<!-- PAGE CONTENTS - END -->
   410 

Cheetah/Templates/SkeletonPage in respond(self=<ROOT_ROOT.ImageManager.ImageManager instance>, trans=<WebKit.Transaction.Transaction instance>, dummyTrans=0, VFS=<built-in function valueFromSearchList>, VFN=<built-in function valueForName>, getmtime=<function getmtime>, currentTime=<built-in function time>)
  223         write(filter(VFS(SL,"bodyTag",1))) # generated from '$bodyTag' at line, col (46, 1).
   224         write('\n\n')
  225         self.writeBody(trans=trans) # generated from ('writeBody', '#block writeBody') at line, col (48, 1).
       trans = <WebKit.Transaction.Transaction instance>
  226         write('''
   227 </body>

WebKit/Application in _dispatchRequest(self=<WebKit.Application.ServletBasedApplication instance>, request=<WebKit.Request.Request instance>)
  466                     pass
   467                 
  468                 self.setting('HTTP500ErrorHandler')(rawRequest)
       rawRequest = {'environ': {'DOCUMENT_ROOT': '/var/www/www.calrudd.com/public_html', 'GATEWAY_INTERFACE': 'CGI/1.1', 'HTTP_ACCEPT': 'text/*, image/jpeg, image/png, image/*, */*', 'HTTP_ACCEPT_CHARSET': 'iso-8859-1, utf-8, *', 'HTTP_ACCEPT_ENCODING': 'x-gzip, gzip, identity', 'HTTP_ACCEPT_LANGUAGE': 'en, en_US', 'HTTP_CACHE_CONTROL': 'no-cache', 'HTTP_CONNECTION': 'Keep-Alive', 'HTTP_HOST': 'calrudd.com', 'HTTP_PRAGMA': 'no-cache', ...}, 'format': 'CGI', 'input': <open file '<socket>', mode 'rb'>, 'output': <open file '<socket>', mode 'wb'>, 'time': 1016139552.845741} (complete)
  469 
   470             ## now that everything else has been processed without error flush

ProgrammingError: ERROR: Relation 'pw__image' does not exist SELECT * FROM pw__image im, pw__images_selections im_sel WHERE im.id=im_sel.im_id AND im_sel.sel_id = 'bindley'
      __doc__ = None
      __getitem__ = <bound method ProgrammingError.__getitem__ of <psycopg.ProgrammingError instance at 0x83c53a4>> (complete)
      __init__ = <bound method ProgrammingError.__init__ of <psycopg.ProgrammingError instance at 0x83c53a4>> (complete)
      __module__ = 'psycopg'
      __str__ = <bound method ProgrammingError.__str__ of <psycopg.ProgrammingError instance at 0x83c53a4>> (complete)
      args = ("ERROR: Relation 'pw__image' does not exist\n\n...m.id=im_sel.im_id AND im_sel.sel_id = 'bindley'",) (complete)

Reply via email to