April 2001 - Zope - Zope lists

Re: [Zope] field names of a database table
by Dieter Maurer 26 Apr '01

26 Apr '01

Jan Kubatzki writes: > how can i find out the field names of a table of a database ? Most Zope Database Adapters support the "browse" tab. It shows you the available tables with their columns. The database itself surely has means that lets you analyse the datamodel. In Oracle, for example, the command is named "describe". Dieter

2 1

Re: [Zope] Zope management screens and OmniWeb (on OS X)
by Dieter Maurer 26 Apr '01

26 Apr '01

tom smith writes: > just reporting a strange bug when trying to manage zope using OmniWeb > ( a non too shabby (non-MS) browser on OSX). The left-hand and top frame > work fine, but in the right-hand frame where my DTMLMethods and Folders > should be I get the results of the index_html for that folder. That > is...what the folder would look like if I was viewing it. It may help, if you address the right frame directly: localhost:8080/manage_main instead of localhost:8080/manage If you are lucky, you need to do this just once (per session) and can afterwards use the normal "manage". Dieter

3 2

membership directory
by shomon＠softhome.net 26 Apr '01

26 Apr '01

Hi I'm working on an open source project to create a membership directory tool for voluntary organisations. I've recently decided on Zope as the best platform to develop on, and I'm trying to find out if there's already a project vaguely similar to mine (eg: a generic directory product, or even something else that is database backed and deals with sensitive personal data). Also, since I'm thinking of releasing this as a zope product, is there a standard way of doing this, and of publicising this within the zope community? A description of this project can be found at http://mandible.sourceforge.net/ I'd be grateful if someone could point me in the right direction, and if anyone would like to help, please get in touch! I've tried searching on the zope site, but found only the "boring-0.1.tgz" product pages, and an old but more complete manual on creating products. I apologise if this isn't the right place for this kind of question. Ale -- Alejandro Fernandez, Bsc Computer Studies Glasgow Caledonian University 0790 541 8809 / 0141 586 3913

3 2

Re: [Zope] Multiple SQL Updates
by Dieter Maurer 26 Apr '01

26 Apr '01

Craig Stoddart writes: > ... multiple SQL statements in one operation ... You can separate several SQL statements in a single Z SQL Method with "<dtml-var sql_delimiter>". You can even generate the sequence of SQL statements with a "<dtml-in>". An alternative would be to use "dtml-in" in a coordinating DTML object that repeatedly call a Z SQL Method. Dieter

1 0

Finding out if guest previously visited the site
by Adrian Madrid 26 Apr '01

26 Apr '01

I want to know if the user visited the site before and here's why I need this: I have two main audiences (researchers and general public) and I want to show a splash page the first time someone visits the site and let them choose between the two options. From then on they should be able to see pages for their kind even if they don't register. How can I do this? I'm guessing using cookies or even finding out if there is one for my site could be the ticket but I'm not familiar with cookies and I'm wondering if there are other approaches. ===== --------------------------- Adrian Esteban Madrid Benson Institute, Webmaster Brigham Young University --------------------------- adrian_esteban(a)madrid.com =========================== __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

1 0

2.3.2b1 bug? objectIds shows items, but hasattr doesn't, what gives?
by Brad Clements 26 Apr '01

26 Apr '01

I have a strange situation with Zope 2.3.2b1 I'm using Interbase to store information about manufacturers, products groups, products, product variations.. Each of these record types have a primary key (id), which is used to reference .jpg images in ZODB. For example, manufacturer One on 1 Design has a T-Shirt Group with 3 products. These product images would be stored in folders named as Images.one.oneclt.one101clt, Images.one.oneclt.one102clt and Images.one.oneclt.one103clt where "one" is the manufacturer id, "oneclt" is the product group id, and "one101clt" (etc) is the product id. This has been working well at http://www.adirondackcraft.com We recently moved to 2.3.2b1, and added some images. We have a dtml-method that walks the database looking for missing images. What's happening is that hasattr is not finding some of the Product folders, even though zope shows that they are there in the manage screen, objectIds shows them too. -- here's an example output of the report: Checking Group oneclt Contents of http://www.adirondackcraft.com/Holmes/Images/one/oneclt Object one101clt at Object one102clt at Object one103clt at Checking Product "Canoe" design T-shirt (Images.one.oneclt.one101clt) Call Found It Checking Product "Sit Back & Relax" design T-shirt (Images.one.oneclt.one103clt ) Call Failed Product Folder Images.one.oneclt.one103clt MISSING Checking Product "Trees" design T-shirt (Images.one.oneclt.one102clt ) Call Failed Product Folder Images.one.oneclt.one102clt MISSING Note that the objects one102clt, one103clt are shown in the objectlist, but hasattr fails to find these two folders (yet the one101clt folder is found). I've tried two tests, one by dtml-call on the object's id in a try statement, and the other with hasattr. Both fail the same. Also note that the object list shows blank space after "at", what's supposed to be here is the absolute_url of the folder. It's coming bank blank, but works on the parent folder. Here's the dtml-method that produces the report (just a scrap of it) -- snip -- Contents of <dtml-var "Images[manufacturerid][groupid].absolute_url()"><br> <dtml-in "Images[manufacturerid][groupid].objectIds()"> Object &dtml-sequence-item; at <dtml-call "Images[manufacturerid][groupid][_['sequence-item']].absolute_url()"><br> </dtml-in> <dtml-in "SQL_Products(groupid=groupid)"> <li><h5>Checking Product &dtml-title; (Images.&dtml-manufacturerid;.&dtml-groupid;.&dtml-id;)</h5> <dtml-try> <dtml-call "Images[manufacturerid][groupid][id].id"> Call Found It <dtml-except KeyError> Call Failed </dtml-try> <dtml-if "not _.hasattr(Images[manufacturerid][groupid],id)"> <div style="color:#ff0000">Product Folder Images.&dtml-manufacturerid;.&dtml-groupid;.&dtml-id; MISSING</div><br> <dtml-else> snip snip. --- I also tried objectItems and objectValues rather than objectIds, but the returned objects still return blank for absolute_url() I've packed the database and restarted the server, still no worky. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

1 0

Re: [Zope] Wrong <base href=""> for .HTM file
by Dieter Maurer 26 Apr '01

26 Apr '01

Loren Stafford writes: > Look at this pywatch output below. When I request a file that ends in .HTM > the <base> tag ends with a / which confuses the browser. The browser makes > all relative references in the .HTM file (<img> tags for example) relative > to http://localhost/Engineering/LSFReports/cibhrm6.HTM/ not to > http://localhost/Engineering/LSFReports/ as you would expect. > > When I try this with a file that is named with a lowercase .htm extension, > no <base> is generated, and the browser fetches all relative <img> tags just > fine. Apparently, you get an object with an "index_html" method that is not "None". In this case, ZPublisher calls the "index_html", adds an "base" tag and appends a '/' to the URL as it would be necessary for a folder. Dieter

1 0

Re: [Zope] Unsightly data.fs buildup?
by Dieter Maurer 26 Apr '01

26 Apr '01

Tony Tocco writes: > While adjusting security and roles I noticed some behavior that concerns me > a little. If you create a new role, assign it some rights, delete that > role, then recreate a new role with that same name, it retains the rights of > the deleted role. Put it into the Collector - seems to be a bug. > Is there an easy way to remove this information? Are there other scenarios > like this that might cause the system to gather useless data? I fear it will not be too easy. I looked at the code in "AccessControl.Permission". It is not easy. It would take me some time to understand what happens there. If you are lucky, then all base information is contained in declarations of the form: _<mangled_permission_name>_Permission= <role tuple> If I had your problem, I would use "ZopeFind" to locate all objects, look at all permission declarations that have the form above and remove the role to be deleted. As mentioned, permission mapping information may be hidden in other attributes, too. Then the algorithm above would not be complete. Dieter

1 0

changing ownership
by nuno 26 Apr '01

26 Apr '01

Hi guys ! does anyone knows how tho change / setting the ownership of an Object with python or with DTML !! I tried in python and it gave me the following error : Zope Error Zope has encountered an error while publishing this resource. Error Type: TypeError Error Value: cannot marshal objects ---------------------------------------------------------------------------- ---- 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/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: teste) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: teste) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/OFS/DTMLDocument.py, line 189, in __call__ (Object: teste) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String. py, line 538, in __call__ (Object: teste) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_In.py, line 713, in renderwob (Object: acl_users.getUsers()) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_Let.py, line 147, in render (Object: user=sequence-item) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_Let.py, line 147, in render (Object: usernam="user.getUserName()") File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_Util.py , line 337, in eval (Object: gtOwner(user)) (Info: gtOwner) File <string>, line 0, in ? File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/Products/ExternalMethod/Ext ernalMethod.py, line 269, in __call__ (Object: gtOwner) (Info: ((epires,), {}, None)) File /usr/local/Zope/Zope-2.3.0-linux2-x86/Extensions/getowner.py, line 8, in GetOwner (Object: Traversable) File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/xmlrpclib.py, line 547, in __call__ File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/xmlrpclib.py, line 625, in __request File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/xmlrpclib.py, line 503, in dumps File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/xmlrpclib.py, line 278, in dumps File /usr/local/Zope/Zope-2.3.0-linux2-x86/lib/python/xmlrpclib.py, line 289, in __dump TypeError: (see above)

1 0

Mailhost trouble
by Jeff Peterson 26 Apr '01

26 Apr '01

1) The particulars... Zope version: Zope 2.2.2 (source release, python 1.5.2, linux2) Python version: 1.5.2 (#1, Nov 20 1999, 01:15:10) [C] System Platform: irix6-n32 2) The error... Zope Error Zope has encountered an error while publishing this resource. Debugging Notice Zope has encountered a problem publishing your object. Cannot locate object at: http://dev.rangetvcable.com/combinedSite/manage_addProduct/MailHost/manage_a ddMailHost ---------------------------------------------------------------------------- ---- 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/current/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/current/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/current/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /usr/local/zope/current/lib/python/ZPublisher/Publish.py, line 162, in publish File /usr/local/zope/current/lib/python/ZPublisher/BaseRequest.py, line 367, in traverse File /usr/local/zope/current/lib/python/ZPublisher/HTTPResponse.py, line 539, in debugError NotFound: (see above) 3) More info... This zope instance has this and one other site running on it. Both are in sub-folders off the root and are using SiteRoot and proxy pass for the root urls. The other site has a working MailHost, I cannot to this point add another, to any level without getting this error. I looked in the code and found that the manage_addMailHost method exists, which I expected. I tried different mailservers, ports, etc. trying to get a different error but to no avail. Any help would be appreciated. -- Jeffrey D. Peterson Webmaster/Web & Web Applications Engineer Range TV Cable & Broadband 1818 E. 3rd Ave. Hibbing, MN 55746 jpeterso(a)the-bridge.net

1 0