[Zope] Howto debug (Re: PostgreSQL Problem)

Daniel Rusch drusch@globalcrossing.com
Wed, 21 Mar 2001 10:47:10 -0600


Postgresql defaults all column names to lower case so Menuitem is
actually menuitem

try this


Dan 
>   <dtml-in GetMainMenu>
>     <dtml-var Menuitem><br>   <---------- change to <dtml-var menuitem><br>
>   </dtml-in>
>   <dtml-var standard_html_footer>



Andreas Tille wrote:
> 
> Hello,
> 
> I really wonder how to do debugging in Zope.  I tried several things
> regarding to the available documentation and because I've got no answer
> over this list I think there is no problem in the code I posted (see
> below).
> 
> Are there any methods to track down the problem?
> I know that many people use PostgreSQL with Zope but I wonder how they
> got their very first example working :-(.
> 
> Kind regards
> 
>         Andreas.
> 
> On Tue, 13 Mar 2001, Andreas Tille wrote:
> 
> > Hello,
> >
> > I'm using Zope 2.2.2 and zope-pygresqlda 0.3rjr2.  I have created the
> > following ZSQL method (here displayed in the "Test"-View):
> >
> >  Z SQL Method at /Control_Panel/Products/Ifsg/GetMainMenu
> >
> >  Idmenushow  Idwebseite  Menuitem
> >  54          25          Description
> >  57          110         Components
> >  61          71          Objectives
> >  52          20          Links
> >  51          57          About us
> >
> >
> > SQL used:
> >
> > SELECT i.IdMenuShow, i.IdWebSeite, i.MenuItem FROM Menu m
> >      INNER JOIN MenuItem i ON i.IdMenu = m.IdMenu
> >      WHERE  m.IdMenu = 52
> >      ORDER BY i.Sort ;
> >
> >
> > I try to use the output of this Query in the following DTML-document:
> >
> >  DTML Document at /Control_Panel/Products/Ifsg/Databasetest
> >
> >
> >   <dtml-var standard_html_header>
> >
> >
> >   <dtml-in GetMainMenu>
> >     <dtml-var Menuitem><br>
> >   </dtml-in>
> >   <dtml-var standard_html_footer>
> >
> >
> > If I try to "View" Databasetest I get:
> >
> >   Zope Error
> >
> >   Zope has encountered an error while publishing this resource.
> >
> >   Error Type: KeyError
> >   Error Value: Menuitem
> >
> > Could anybody enlighten me, what's the problem here?
> >
> > Kind regards
> >
> >       Andreas.
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )