March 2002 - Zope - Zope lists

ZSQL question
by Colin Fox 27 Mar '02

27 Mar '02

On Wed, 2002-03-27 at 13:49, Bryan C. Andregg wrote: <..> > > You could do something like this > > <dtml-if "REQUEST.has_attr(cb)"> > <dtml-call dbInsert(str1 = REQUEST[str1], > str2 = REQUEST[str2], > cb = REQUEST[cb] )"> > <dtml-else> > <dtml-call dbInsert(str1 = REQUEST[str1], > str2 = REQUEST[str2], > cb = '' )"> > </dtml-if> Actually, I discovered moments after posting my question that there's an 'optional' keyword, so my statement can now read: insert into mytable(col1,col2,col3) values (<dtml-sqlvar str1 type="string">, <dtml-sqlvar str2 type="string">, <dtml-sqlvar cb type="string" optional> ) and it will work (assuming the col3 column accepts nulls). -- Colin Fox cfox(a)crystalcherry.com CF Consulting Inc. GPG Fingerprint: D8F0 84E7 E7CC 5C6C 9982 F1A7 A3EB 6EA3 BC97 572F

1 0

Zope has encountered an error while publishing this resource
by Rengasamy, Samy 27 Mar '02

27 Mar '02

I installed zope 2.5 and I am going through the documentation. When I tried to add a page template under a new 'trial' folder, I am getting the following error message: ********************************** Error Type: Undefined Error Value: You are not allowed to access manage_page_header in this context not found in 'here/manage_page_header', at line 1, column 1 ---------------------------------------------------------------------------- ---- 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. Traceback (innermost last): File /usr/local/Zope-2.5.0-src/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/Zope-2.5.0-src/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/Zope-2.5.0-src/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook File /usr/local/Zope-2.5.0-src/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/Zope-2.5.0-src/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_addPageTemplateForm) File /usr/local/Zope-2.5.0-src/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_addPageTemplateForm) File /usr/local/Zope-2.5.0-src/lib/python/Shared/DC/Scripts/Bindings.py, line 252, in __call__ (Object: manage_addPageTemplateForm) File /usr/local/Zope-2.5.0-src/lib/python/Shared/DC/Scripts/Bindings.py, line 283, in _bindAndExec (Object: manage_addPageTemplateForm) File /usr/local/Zope-2.5.0-src/lib/python/Products/PageTemplates/PageTemplateFile .py, line 94, in _exec (Object: manage_addPageTemplateForm) File /usr/local/Zope-2.5.0-src/lib/python/Products/PageTemplates/PageTemplate.py, line 86, in pt_render (Object: manage_addPageTemplateForm) (Info: {'container': <__FactoryDispatcher__ instance at bbc2a8>, 'here': <__FactoryDispatcher__ instance at bbc2a8>, 'modules': <Products.PageTemplates.ZRPythonExpr._SecureModuleImporter instance at 0xc28bb4>, 'nothing': None, 'options': {'args': ()}, 'request': <h3>form</h3><table></table><h3>cookies</h3><table><tr valign="top" align="left"><th>tree-s</th><td>'eJyLjlZ3hANPW/XYWAAtiQTP'</td></tr></table> <h3>lazy items</h3><table><tr valign="top" align="left"><th>SESSION</th><td><Python Method object at 0x912148></td></tr></table><h3>other</h3><table><tr valign="top" align="left"><th>BASE5</th><td>'http://208.145.195.99:9090/trial/manage_addP roduct/PageTemplates/manage_addPageTemplateForm'</td></tr><tr valign="top" align="left"><th>AUTHENTICATION_PATH</th><td>''</td></tr><tr valign="top" align="left"><th>BASE2</th><td>'http://208.145.195.99:9090/trial'</td></tr>< tr valign="top" align="left"><th>BASE3</th><td>'http://208.145.195.99:9090/trial/manage_addP roduct'</td></tr><tr valign="top" align="left"><th>URL3</th><td>'http://208.145.195.99:9090/trial'</td></tr><t r valign="top" align="left"><th>URL0</th><td>'http://208.145.195.99:9090/trial/manage_addPr oduct/PageTemplates/manage_addPageTemplateForm'</td></tr><tr valign="top" align="left"><th>BASE1</th><td>'http://208.145.195.99:9090'</td></tr><tr valign="top" align="left"><th>URL2</th><td>'http://208.145.195.99:9090/trial/manage_addPr oduct'</td></tr><tr valign="top" align="left"><th>URL4</th><td>'http://208.145.195.99:9090'</td></tr><tr valign="top" align="left"><th>traverse_subpath</th><td>[]</td></tr><tr valign="top" align="left"><th>URL1</th><td>'http://208.145.195.99:9090/trial/manage_addPr oduct/PageTemplates'</td></tr><tr valign="top" align="left"><th>SERVER_URL</th><td>'http://208.145.195.99:9090'</td></tr><t r valign="top" align="left"><th>tree-s</th><td>'eJyLjlZ3hANPW/XYWAAtiQTP'</td></tr><tr valign="top" align="left"><th>URL</th><td>'http://208.145.195.99:9090/trial/manage_addPro duct/PageTemplates/manage_addPageTemplateForm'</td></tr><tr valign="top" align="left"><th>AUTHENTICATED_USER</th><td>Anonymous User</td></tr><tr valign="top" align="left"><th>PUBLISHED</th><td><PageTemplateFile instance at c419e0></td></tr><tr valign="top" align="left"><th>TraversalRequestNameStack</th><td>[]</td></tr><tr valign="top" align="left"><th>BASE0</th><td>'http://208.145.195.99:9090'</td></tr><tr valign="top" align="left"><th>BASE4</th><td>'http://208.145.195.99:9090/trial/manage_addP roduct/PageTemplates'</td></tr><tr valign="top" align="left"><th>URL0</th><td>http://208.145.195.99:9090/trial/manage_addPro duct/PageTemplates/manage_addPageTemplateForm</td></tr><tr valign="top" align="left"><th>URL1</th><td>http://208.145.195.99:9090/trial/manage_addPro duct/PageTemplates</td></tr><tr valign="top" align="left"><th>URL2</th><td>http://208.145.195.99:9090/trial/manage_addPro duct</td></tr><tr valign="top" align="left"><th>URL3</th><td>http://208.145.195.99:9090/trial</td></tr><tr valign="top" align="left"><th>URL4</th><td>http://208.145.195.99:9090</td></tr><tr valign="top" align="left"><th>BASE0</th><td>http://208.145.195.99:9090</td></tr><tr valign="top" align="left"><th>BASE1</th><td>http://208.145.195.99:9090</td></tr><tr valign="top" align="left"><th>BASE2</th><td>http://208.145.195.99:9090/trial</td></tr><tr valign="top" align="left"><th>BASE3</th><td>http://208.145.195.99:9090/trial/manage_addPr oduct</td></tr><tr valign="top" align="left"><th>BASE4</th><td>http://208.145.195.99:9090/trial/manage_addPr oduct/PageTemplates</td></tr><tr valign="top" align="left"><th>BASE5</th><td>http://208.145.195.99:9090/trial/manage_addPr oduct/PageTemplates/manage_addPageTemplateForm</td></tr></table><h3>environ< /h3><table><tr valign="top" align="left"><th>HTTP_ACCEPT_ENCODING</th><td>'gzip, deflate'</td></tr><tr valign="top" align="left"><th>channel.creation_time</th><td>1017217551</td></tr><tr valign="top" align="left"><th>SERVER_PROTOCOL</th><td>'HTTP/1.1'</td></tr><tr valign="top" align="left"><th>SERVER_PORT</th><td>'9090'</td></tr><tr valign="top" align="left"><th>PATH_INFO</th><td>'/trial/manage_addProduct/PageTemplates/m anage_addPageTemplateForm'</td></tr><tr valign="top" align="left"><th>HTTP_HOST</th><td>'208.145.195.99:9090'</td></tr><tr valign="top" align="left"><th>REQUEST_METHOD</th><td>'GET'</td></tr><tr valign="top" align="left"><th>PATH_TRANSLATED</th><td>'/trial/manage_addProduct/PageTempl ates/manage_addPageTemplateForm'</td></tr><tr valign="top" align="left"><th>SCRIPT_NAME</th><td>''</td></tr><tr valign="top" align="left"><th>SERVER_SOFTWARE</th><td>'Zope/(Zope 2.5.0 (source release, python 2.1, linux2), python 2.1.2, linux2) ZServer/1.1b1'</td></tr><tr valign="top" align="left"><th>HTTP_ACCEPT_LANGUAGE</th><td>'en-us'</td></tr><tr valign="top" align="left"><th>HTTP_ACCEPT</th><td>'image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*'</td></tr><tr valign="top" align="left"><th>REMOTE_ADDR</th><td>'172.16.29.208'</td></tr><tr valign="top" align="left"><th>HTTP_COOKIE</th><td>'tree-s="eJyLjlZ3hANPW/XYWAAtiQTP"'</td ></tr><tr valign="top" align="left"><th>SERVER_NAME</th><td>'sysx.firstam-reis.com'</td></tr><tr valign="top" align="left"><th>GATEWAY_INTERFACE</th><td>'CGI/1.1'</td></tr><tr valign="top" align="left"><th>HTTP_USER_AGENT</th><td>'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)'</td></tr><tr valign="top" align="left"><th>CONNECTION_TYPE</th><td>'Keep-Alive'</td></tr></table>, 'root': <Application instance at bae818>, 'template': <PageTemplateFile instance at c419e0>, 'traverse_subpath': [], 'user': Anonymous User}) File /usr/local/Zope-2.5.0-src/lib/python/TAL/TALInterpreter.py, line 158, in __call__ File /usr/local/Zope-2.5.0-src/lib/python/TAL/TALInterpreter.py, line 191, in interpret File /usr/local/Zope-2.5.0-src/lib/python/TAL/TALInterpreter.py, line 432, in do_insertStructure_tal File /usr/local/Zope-2.5.0-src/lib/python/Products/PageTemplates/TALES.py, line 247, in evaluate File /usr/local/Zope-2.5.0-src/lib/python/Products/PageTemplates/Expressions.py, line 189, in __call__ File /usr/local/Zope-2.5.0-src/lib/python/Products/PageTemplates/Expressions.py, line 179, in _eval Undefined: (see above) ********************************** What am I miising here? Thanks in advance, Samy Rengasamy.

3 2

RE: [Zope] Zope has encountered an error while publishing this re source
by Rengasamy, Samy 27 Mar '02

27 Mar '02

The 'Change User' panel for user 'manager' displays both the roles. Samy Rengasamy. -----Original Message----- From: Mike Renfro [mailto:renfro@tntech.edu] Sent: Wednesday, March 27, 2002 2:59 PM To: Rengasamy, Samy Cc: 'zope(a)zope.org' Subject: Re: [Zope] Zope has encountered an error while publishing this resource On Wed, Mar 27, 2002 at 08:41:33AM -0600, Rengasamy, Samy wrote: > ********************************** > Error Type: Undefined > Error Value: You are not allowed to access manage_page_header in this > context not found in 'here/manage_page_header', at line 1, column 1 See if your logged-in user has both Manager and Owner roles assigned, or just Manager. I think Manager alone isn't enough (for some reason). -- Mike Renfro / R&D Engineer, Center for Manufacturing Research, 931 372-3601 / Tennessee Technological University -- renfro(a)tntech.edu

1 0

Popy and ZPoPyDA on Zope 2.5
by John 27 Mar '02

27 Mar '02

Has anyone been able to get the ZPoPyDa to work with this configuration: Popy 2.0.8 or Popy 3.0 beta1 ZPoPyDA 2.0.8 Zope 2.5.0 I get to the point where the ZPoPyDA is broken and says: The PoPy module is not installed I have put it in the /usr/local/ZopeHome/lib/python2.1 and the /usr/local/ZopeHome/lib/python2.1/site-packages and the /usr/local/ZopeHome/lib/python Directories....to no avail.... Any help would be appreciated. thanks John

2 1

Re: [Zope] page hits ?
by oliver.erlewein＠sqs.de 27 Mar '02

27 Mar '02

Hi Marcio The problem with Z2.log is that it usually logs too much! It shows every file,image,html,... No boss can comprehend what Z2 logs. I therefore wrote my own logger, which logs one line per page called from the server. I used a simple python script, which I call from the standard_html_header. Later I use an AWK script to analyze it and show me the numbers I want. Regards Oliver Erlewein

4 3

FW: [ZC] 313/ 2 Reject "accessing applet code"
by Mike Nourie 27 Mar '02

27 Mar '02

My question was rejected!!!! aggghhhh!!!! PLEASE HELP ME!!!! -----Original Message----- From: Collector: Zope Bugs and Patches ... [mailto:zope-coders@zope.org] Sent: Wednesday, March 27, 2002 9:32 AM To: mike nourie; ajung; klm; Brian; chrism; paul; _Rejected_ recipient Subject: [ZC] 313/ 2 Reject "accessing applet code" Issue #313 Update (Reject) "accessing applet code" Status Rejected, Zope/bug critical To followup, visit: http://collector.zope.org/Zope/313 ============================================================== = Reject - Entry #2 by ajung on Mar 27, 2002 12:32 pm Status: Pending => Rejected Please submit your question to the Zope list zope(a)zope.org. The collector is the wrong place for your question. -aj ________________________________________ = Request - Entry #1 by Anonymous User on Mar 25, 2002 5:12 pm I need some help, and I can't seem to find the answer on your web site -- this may sound simple, but I am stuck: I have an applet in a JAR file -- where can I store this on Zope so that the applet is found by remote users and the darn thing pops up on the screen? (I loaded the file in the root contents of my CMF site, and it works from 'localhost', but if I am remote, I get a class file not found error) -- sounds simple -- please help!!!!! ==============================================================

2 1

RE: [Zope-CMF] Problems with virtual hosting and CMF 1.2
by Wolfgang Klinger (mokka) 27 Mar '02

27 Mar '02

hiya! another possible solution is to use Apache, pcgi and Zope explained in detail here: http://zdp.zope.org/projects/zbook/book/VII/IntegraWebServers/IntegraUnix/Z… and here: http://www.zope.org/Members/cavnit/apachevirt this works ... (if you need help, just ask ...) Wolfgang ----- Klinger Wolfgang Mokka Medienagentur GmbH Mariahilferstr. 170 A-1150 Wien wolfgang.klinger(a)mokka.at On Wed, 2002-03-27 at 15:29, Andrew Sawyers wrote: > On the 3 sites I'm working on at the moment, changing the cookie > authentication name from __ac to __ac_foo works fine; fixed all problems you > described. > Andrew > > -----Original Message----- > From: zope-cmf-admin(a)zope.org [mailto:zope-cmf-admin@zope.org]On Behalf > Of Chris Withers > Sent: Wednesday, March 27, 2002 9:09 AM > To: Tres Seaver > Cc: Alastair Burt; zope-cmf(a)zope.org > Subject: Re: [Zope-CMF] Problems with virtual hosting and CMF 1.2 > > > Tres Seaver wrote: > > > > Alastair, > > > > We know of a problem with certain versions of Apache stripping > > cookies when proxying for Zope: > > > > http://collector.zope.org/Zope/267 > > > > Here is notification about the bug from ApacheWeek: > > > > Proxy users thinking of upgrading to Apache 1.3.23 should be aware > > that there is a bug ([5]PR#9655) in the handling of responses which > > set more than one cookie, and may wish to wait for the 1.3.24 > > release before upgrading. > > Yeah, well, 1.3.24 is out and it don't work either ;-) Stick with 1.3.22 if > you wish to > remain sane. > > > The workaround seems to be to change the name of the cookie used > > by the CookieCrumbler from '__ac' to some other string. > > That workaround doesn't work ;-) (well, at least for me...) > > Going back to 1.3.22 solved the problem for the customer, but when I go > through our proxy > to their site, it still doesn't work in prettymuch the same way. > > Any ideas? > > cheers, > > Chris > > _______________________________________________ > Zope-CMF maillist - Zope-CMF(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-cmf > > See http://www.zope.org/Products/PTK/Tracker for bug reports and feature > requests > > > _______________________________________________ > Zope-CMF maillist - Zope-CMF(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-cmf > > See http://www.zope.org/Products/PTK/Tracker for bug reports and feature requests >

1 0

updataCatalog call
by Niclas Kuehne 27 Mar '02

27 Mar '02

Hello! Can anyone help me on how to call the updateCatalog method in Zope? I would like to call the same method that is called by clicking on the "Update Catalog" button in the Advanced tab of the Catalog Mananagement Screen. I want to run this method in a DTML Script for Xron, since CatalogAwareness doesn't work for me. Thank you! Niclas Kuehne nk(a)nkmail.com

2 1

page hits ?
by Marcio Marchini 27 Mar '02

27 Mar '02

Hi, I was wondering if you guys have any pointers on where Zope logs page hits, so that I can show this info to "internal" people who may want to see web site usage. I was hoping to use http://www.zope.org/Members/teyc/ZGDChart to visualize the data, but I need the data in the first place ! thanks !! marcio

4 3

omni font bug still not fixed?
by marc lindahl 27 Mar '02

27 Mar '02

C'mon guys, it can't be that hard... http://collector.zope.org/Zope/26

3 5