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." ------------------------------------------------------------
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 )
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> </:if> </td> <td> <:if "notes"> <:var notes> <:else> </: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 )
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> </:if> </td> <td> <:if "notes"> <:var notes> <:else> </: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 )
participants (2)
-
Chris McDonough -
Steven Grimes