- Zope - Zope lists

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

field names of a database table
by Jan Kubatzki 26 Apr '01

26 Apr '01

hi everyone, how can i find out the field names of a table of a database ? cu, jkubatzki.

1 0

a LOT of users and roles
by Nils Decker 26 Apr '01

26 Apr '01

Hi there, i need some hints about security with a large number of users and roles. We will have a lot of pages that are within 100 - 200 categorys. Any one of 5000 users will have the right to access documents within any combination of those categorys. Defining 200 roles doesn't seem right, because the security-tab would become huge. Does anybody know a better alternative? My idea was to create a new security-tab that is simpler. There will also have about 50 000 users that will be able to customize the site. There are products to sync a folder to a userfolder, but i don't know how zope handles that many objects within one folder. The other option would be to use a database aware userfolder and store any other info into the database too. Any comments? Thank you in advance Nils Decker

1 0

Translator/render() strangeness
by cg＠cdegroot.com 26 Apr '01

26 Apr '01

I just tried to use Translator in 2.3.1 for the first time. It behaves strange when I use <dtml-lvar some_image>, and it seems to hinge on something in DT_Util.render(): def render(self, v): "Render an object in the way done by the 'name' attribute" if hasattr(v, '__render_with_namespace__'): v = v.__render_with_namespace__(self) else: vbase = getattr(v, 'aq_base', v) if callable(vbase): if getattr(vbase, 'isDocTemp', 0): v = v(None, self) else: v = v() return v When I use <dtml-lvar some_image>, the image is eventually passed to render() by Translator/LocalizeTag. Some print statements reveal in this case: type(v) = <extension class Acquisition.ImplicitAcquirerWrapper at 40201e60> callable(v) = 1 type(vbase) = <extension class OFS.Image.Image at 85acac0> callable(vbase) = 1 So render calls the line "v = v()". Result: Traceback (most recent call last): File "/net/fs-1/bigdisk/opt/zope/current/lib/python/Products/Translator/Loc alizeTag.py", line 102, in render return str(render(md, v)) File "/net/fs-1/bigdisk/opt/zope/current/lib/python/DocumentTemplate/DT_Uti l.py", line 282, in render v = v() AttributeError: __call__ So v is callable, but v() returns this attribute error? (I've wrapped the v=v() inside a try:except: and it now works again...) -- Cees de Groot http://www.cdegroot.com <cg(a)cdegroot.com> GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B

1 0