[Zope] Problems with Queries after reinstalling

Chris McDonough chrism@digicool.com
Thu, 8 Feb 2001 13:41:14 -0500


OK, this sounds like a SQL Method bug.  I'm going to add your description to
the Collector on Zope.org.  In the meantime, maybe somebody else can provide
a workaround (I'm no SQLMethods expert, unforunately ;-)


----- Original Message -----
From: "Steven Grimes" <sgrimes@atinucleus.com>
To: "Chris McDonough" <chrism@digicool.com>; "Zope" <zope@zope.org>
Cc: "Yvonne Totty" <ytotty@atinucleus.com>; "Debby Collins"
<dcollins@atinucleus.com>; "Ronald Baum" <rbaum@atinucleus.com>
Sent: Thursday, February 08, 2001 12:43 PM
Subject: Re: [Zope] Problems with Queries after reinstalling


> All,
>
> I'm using Microsoft Visual Foxpro free tables on another machine using
ODBC
> (this was not my choice). I have a DTML Document called procList (see
source
> below) which calls a ZSQLMethod named getAllProcessors() (see source
below)
> it gives repeatedly asks for a password and none of the usernames or
> passwords in my acl_users nor my superuser password works. After three
> attemps the following error message is displayed:
>
>  Zope Error
> Zope has encountered an error while publishing this resource.
>
> Unauthorized
>
> Sorry, a Zope error occurred.
>
> Traceback (innermost last):
>   File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 222, in
> publish_module
>   File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 187, in
> publish
>   File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 171, in
> publish
>   File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\mapply.py, line 160, in
> mapply
>     (Object: procList)
>   File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 112, in
> call_object
>     (Object: procList)
>   File C:\PROGRA~1\ATIANY~1\lib\python\OFS\DTMLDocument.py, line 170, in
> __call__
>     (Object: procList)
>   File C:\PROGRA~1\ATIANY~1\lib\python\DocumentTemplate\DT_String.py, line
> 502, in __call__
>     (Object: procList)
>   File C:\PROGRA~1\ATIANY~1\lib\python\DocumentTemplate\DT_In.py, line
682,
> in renderwob
>     (Object: getAllProcessors())
> Unauthorized: 0
>
>
>
> --------------------------------------------------------------------------
--
> ----
>
> Troubleshooting Suggestions
>
> The URL may be incorrect.
> The parameters passed to this resource may be incorrect.
> A resource that this resource relies on may be encountering an error.
> For more detailed information about the error, please refer to the HTML
> source for this page.
>
> If the error persists please contact the site maintainer. Thank you for
your
> patience.
>
> proclist Source Code:
> <dtml-var standard_html_header>
> <table border="1" cellspacing="0">
>   <tr>
>     <td><b>Proc#</b></td>
>     <td><b>CPU</b></td>
>     <td><b>Architecture</b></td>
>     <td><b>Description</b></td>
>   </tr>
>   <:in "getAllProcessors()">
>   <tr>
>     <td><:var item_id></td>
>     <td><:var item></td>
>     <td>
>       <:if "_.string.strip(category)!=''">
>         <:var category>
>       <:else>
>         &nbsp;
>       </:if>
>     </td>
>     <td>
>       <:if "notes">
>         <:var notes>
>       <:else>
>         &nbsp;
>       </:if>
>     </td>
>   </tr>
>   </:in>
> </table>
> <dtml-var standard_html_footer>
>
> getAllProcessors Source Code: (no arguments, the connection works fine)
> select * from lookup3 where class='PROCESSOR' order by item
>
>
> Thanks,
> Steven Grimes
> Database Engineer
> sgrimes@atinucleus.com
>
> Accelerated Technology, Inc.
> 720 Oak Circle Drive East
> Mobile, AL 36609
> TEL: 334-661-5770
> FAX: 334-661-5788
> www.acceleratedtechnology.com
>
> ------------------------------------------------------------
>    "Nucleus.  All You NEED in an RTOS.  Royalty Free."
> ------------------------------------------------------------
> ----- Original Message -----
> From: Chris McDonough <chrism@digicool.com>
> To: Steven Grimes <sgrimes@atinucleus.com>; Zope <zope@zope.org>
> Sent: Thursday, February 08, 2001 11:16 AM
> Subject: Re: [Zope] Problems with Queries after reinstalling
>
>
> > Queries what?  What database?  Can you give code samples?
> >
> > ----- Original Message -----
> > From: "Steven Grimes" <sgrimes@atinucleus.com>
> > To: "Zope" <zope@zope.org>
> > Sent: Thursday, February 08, 2001 11:45 AM
> > Subject: [Zope] Problems with Queries after reinstalling
> >
> >
> > > All,
> > >
> > > I'm trying to reinstall Zope on a new machine. I'm using Windows NT
4.0
> > with
> > > IIS and pcgi. I have it successfully installed and serving pages but
> > anytime
> > > I try to call a page that runs a query I get an error. If I go to the
> > > management interface and test the queries they return the data I
expect
> > but
> > > when I try to call the query from inside code it doesn't work.
> > >
> > > Any suggestions?
> > >
> > > Thanks,
> > > Steven Grimes
> > > Database Engineer
> > > sgrimes@atinucleus.com
> > >
> > > Accelerated Technology, Inc.
> > > 720 Oak Circle Drive East
> > > Mobile, AL 36609
> > > TEL: 334-661-5770
> > > FAX: 334-661-5788
> > > www.acceleratedtechnology.com
> > >
> > > ------------------------------------------------------------
> > >    "Nucleus.  All You NEED in an RTOS.  Royalty Free."
> > > ------------------------------------------------------------
> > >
> > >
> > > _______________________________________________
> > > 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 )
> > >
> >
> >
>
>
> _______________________________________________
> 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 )
>