- Zope - Zope lists

Zope < - > MySQL
by Carl Blesius 08 Jun '01

08 Jun '01

We are having a problem with the MySQL Zope connection... Zope 2.3.0 (binary release, python 1.5.2, solaris-2.6-sparc) Python Version 1.5.2 (#8, Nov 16 1999, 10:05:41) [GCC 2.8.1] sunos5 ZMySQLDA-1.1.3-nonbin.tar.gz MySQL-python-0.3.5.tar.gz Distutils-1.0.2.tar.gz Traceback (innermost last): File "/usr/local/www/zope/lib/python/OFS/Application.py", line 530, in import_products product=__import__(pname, global_dict, global_dict, silly) File "lib/python/Products/ZMySQLDA/__init__.py", line 106, in ? import sys, os, Globals, DA File "lib/python/Products/ZMySQLDA/DA.py", line 108, in ? from db import DB File "lib/python/Products/ZMySQLDA/db.py", line 106, in ? import MySQL, regex, sys ImportError: dynamic module does not define init function (initMySQL) Anyone have similar problems?

2 1

one step closer to connecting Zope to MySQL
by Horst Wald 08 Jun '01

08 Jun '01

Hi, thanks to all the help I got, I'm a lot closer to connecting Zope to MySQL now and I think I know where the problem is. I have: - started with Suse Linux 7.0 - installed Zope 2.3.2 - installed MySQL 3.22.32 and Python 1.5.2-something with YAST - downloaded and installed MySQL-python-0.3.5, ZMySQLDA-2.0.6 as stated in the ebook I bought myself - downloaded and installed Distutils-1.0.2 - tried to compile the MySQL-python-0.3.5 - got the error message: Traceback (innermost last): File "/usr/zope/lib/python/OFS/Application.py", line 528, in import_products product=__import__(pname, global_dict, global_dict, silly) File "/usr/zope/lib/python/Products/ZMySQLDA/__init__.py", line 91, in ? import DA File "/usr/zope/lib/python/Products/ZMySQLDA/DA.py", line 91, in ? from db import DB File "/usr/zope/lib/python/Products/ZMySQLDA/db.py", line 89, in ? import _mysql ImportError: No module named _mysql I took a look at /usr/zope/lib/python/Products/ZMySQLDA/db.py and it says in line 89: "import _mysql", hard coded. Which explains the error: I found no such file on my computer. So it seems, I still have to install something, right? What is it? I'll have a beer on you all when it works, promise! Horst _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

4 3

The old dmtl namespace question
by Tom Cameron 08 Jun '01

08 Jun '01

I am sorry to ask the same question again, but I am still completely stumped after many hours of trying and reading. I have:- Folder1 - method1 Folder2 - method2 <- this method calls method3 - method3 When I call an object like this... >From method1 <dtml-call "REQUEST.set('variable','value')"> <- I want to set some variables too <dtml-var "folder2.method2"> The method works perfectly, except that it does not render. When I call it like this.... >From method1 <dtml-call "REQUEST.set('variable','value')"> <dtml-var "folder2.method2()"> It seems to have no namespace at all and causes an error (method2 is calling method3 and cant find it.) I have found a few similar posts to the mailing lists and most responses point to.. http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html which I have read over and over and still dont understand. It mentions _.None, and _ but I cant work out how they work. Basically I want method2 to have access to all the methods in folder2 as well as all REQUEST variables. Can someone please show some examples of how to do this. Thanks Tom

7 8

"Bad Request" error on calling a zsql method
by Jean Lagarde 07 Jun '01

07 Jun '01

Good day, I've been using Zope and Python for about two weeks now, and I've been able to figure everything for myself so far (with the help of this list and other docs, of course). I've figured how to work around the following problem, but I don't understand what causes the error in the first place. I have not been able to find an instance of the error type "Bad request" in this group or searching zope.org. The problem comes up when trying to call a zsql method with implicit argument passing. The zsql method (insertOccurences) declares the two arguments 'occurence' and 'problemID'. The calling dtml is as follows: <dtml-let problemID="radarDBSessionData.getSessionData().get('insertedProblemID')"> <dtml-in occurences> <dtml-let occurence=sequence-item> <dtml-call insertOccurence> </dtml-let> </dtml-in occurences> </dtml-let> On running this, Zope returns the following error: Error Type: Bad Request Error Value: ['occurence', 'problemID'] Traceback (innermost last): File D:\pf2\radar\lib\python\ZPublisher\Publish.py, line 223, in publish_module File D:\pf2\radar\lib\python\ZPublisher\Publish.py, line 187, in publish File D:\pf2\radar\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File D:\pf2\radar\lib\python\ZPublisher\Publish.py, line 171, in publish File D:\pf2\radar\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: selectProblemPage) File D:\pf2\radar\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: selectProblemPage) File D:\pf2\radar\lib\python\OFS\DTMLMethod.py, line 189, in __call__ (Object: selectProblemPage) File D:\pf2\radar\lib\python\DocumentTemplate\DT_String.py, line 538, in __call__ (Object: selectProblemPage) File D:\pf2\radar\lib\python\DocumentTemplate\DT_Let.py, line 147, in render (Object: problemID="radarDBSessionData.getSessionData().get('insertedProblemID')") File D:\pf2\radar\lib\python\DocumentTemplate\DT_In.py, line 717, in renderwob (Object: occurences) File D:\pf2\radar\lib\python\DocumentTemplate\DT_Let.py, line 147, in render (Object: occurence=sequence-item) File D:\pf2\radar\lib\python\Shared\DC\ZRDB\DA.py, line 476, in __call__ (Object: insertOccurence) File D:\pf2\radar\lib\python\Shared\DC\ZRDB\Aqueduct.py, line 150, in _argdata (Object: insertOccurence) Bad Request: (see above) My workaround is to pass the arguments explicitely, i.e. <dtml-call "insertOccurence(occurence=_.getitem('occurence'),problemID=_.getitem('problemID'))"> But I think that this should be unnecessary. Anybody has an explanation for the error? I admit that I may still have some fundamental misunderstanding of the Zope namespace and of method calling (for example, why is it necessary to include _=_ in the arguments list to get the namespace in a script, even after declaring the binding?), so maybe the reason will be obvious to some of you Python/Zope Gods. Bonus question: The 'occurences' (plural) variable above was produced by using the :records type qualifier on a form (great feature by the way). I have not been able to figure the type of the returned object, and I am curious. If I iterate over the list, the sequence-item has the keys() method, but trying to set a key in a script (x['thekey']=y) produces the error ("object does not support item assigment"). Similarly, I can use getattr on the object, but setattr returns the error ('attribute-less object'). Is this due to the security limitations of Zope's own implementation of setitem and setattr? Any description of these limitations available somewhere? I suppose I can always try to find out from the appropriate .py file, but given my inexperience with Python, I don't have the time for that right now. If the issue is security, then is the only way to "fix up" (e.g. reformat a date string) items in a form record or records to do it in an external method? Cheers, Jean

2 1

KeyError with non-existant _[variables]
by Chas Wareing 07 Jun '01

07 Jun '01

I'm getting a KeyError trying to render non-existant _[variables] <dtml-var "_[variable]" null="triedthis" missing="triedthistoo"> say variable == firstname, but firstname is not a variable- I'd like to set it to null and proceed- { I'm using this to build a generic SQL edit form based on column names and keyed input } Chas. <c3w(a)ISP.NET> ISP Networks, Inc.

4 4

dtml-with ONLY, on folders?
by Brian Withun 07 Jun '01

07 Jun '01

<DTML-WITH xxx ONLY> doesn't seem to work the way I expect, when using folders... I have: FolderA FolderA.dtmlmethod1 FolderA.FolderB FolderA.FolderB.dtmlmethod2 dtmlmethod1 contains: this is dtmlmethod1 dtmlmethod2 contains: <dtml-with FolderB only> <dtml-var dtmlmethod1 missing="no method1 found"> </dtml-with> When I view dtmlmethod2, I expect to see "no method1 found", but instead I see "this is dtmlmethod1" It appears that the "ONLY" part of my dtml-with isn't working? Am I missing something? Brian Withun ------------

2 1

newbie: call dtml-method with parameter sequence-item
by Horst Wald 07 Jun '01

07 Jun '01

Hi! How does one call, say, a "Z SQL-method" Z(x) with Parameter x from inside a loop in a DTML-document with "sequence-item" as a parameter? Of course you can't <dtml-in "_.range(10)"> <dtml-call "Z(<dtml-var sequence-item>)"> </dtml-in> because you'd have to nest one dtml-tag in another. But what can you do? I guess the trick is simple, but I can't find it... a humble newbie Horst _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

2 1

RE: [Zope] Upgrade from Zope 2.2 to Zope 2.3
by sean.upton＠uniontrib.com 07 Jun '01

07 Jun '01

Whoever the Debian maintainer is for Zope, they are very good about recency. You can get 2.3.2 plust the latest hostfix by doing an 'apt-get install zope' from unstable or testing; it's been this way since about a week after 2.3.2 was available. Not too bad... I don't know of any issues with this setup on Debian; I am running it right now on about half-a-dozen boxes. The ONLY issue I have found is that I cannot get it to reliably work as a ZEO storage server (this was only on Debian SPARC - I had no problems on Intel); I downloaded the source install for that on my Sun server, and have no problems running 2.3.2 from the deb as a ZEO client. If you are not using ZEO, than pay no attention to my rambling... Upgrading from 2.2 may create some other issues, however, that I have not dealt with. My guess is, though, there would be no issues particular to Debian upgrade. The "apt-get install zope" from unstable/testing should work just fine, without being disruptive toward your current install data or installed products... Good luck, Sean -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Thursday, June 07, 2001 5:32 AM To: Oleg Broytmann Cc: Harris Peter; 'zope(a)zope.org' Subject: Re: [Zope] Upgrade from Zope 2.2 to Zope 2.3 > On Thu, 7 Jun 2001, Harris Peter wrote: > > I have Zope 2.2 running on Debian. The 2.3 package has just recently become > > available, but before I go for the upgrade, I thought I'd ask if there are > > any gotchas (on Debian or otherwise). Well, what's the third point they're used for the package? If it's anything less than 2.3.2, don't use it ;-) cheers, Chris _______________________________________________ Zope maillist - Zope(a)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 )

1 0

Base classes for a folderish portal type (CMF)
by katrin 07 Jun '01

07 Jun '01

Hi everyone, I'm trying to create a ZClass as a base for a folderish portal type. Now it seems I have a problem with the Base classes for my ZClass. When I try to add my portal type as a user in the portal, I get the following error message: Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: creation_date Traceback (innermost last): File C:\KKirchner\Zope2.3.2b\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\KKirchner\Zope2.3.2b\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\KKirchner\Zope2.3.2b\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File C:\KKirchner\Zope2.3.2b\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\KKirchner\Zope2.3.2b\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: invokeFactory) File C:\KKirchner\Zope2.3.2b\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: invokeFactory) File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFCore\PortalFolder.py, line 368, in invokeFactory (Object: Traversable) File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFCore\TypesTool.py, line 714, in constructContent (Object: Traversable) File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFCore\TypesTool.py, line 473, in constructInstance (Object: ElementWithAttributes) File C:\KKirchner\Zope2.3.2b\lib\python\Shared\DC\Scripts\Bindings.py, line 324, in __call__ (Object: addTermPaper.py) File C:\KKirchner\Zope2.3.2b\lib\python\Shared\DC\Scripts\Bindings.py, line 354, in _bindAndExec (Object: addTermPaper.py) File C:\KKirchner\Zope2.3.2b\lib\python\Products\PythonScripts\PythonScript.py, line 336, in _exec (Object: addTermPaper.py) (Info: ({'script': <PythonScript instance at 01404F40>, 'context': <FactoryDispatcher instance at 01584330>, 'container': <FactoryDispatcher instance at 01584330>, 'traverse_subpath': []}, ('sfdd',), {}, None)) File Script (Python), line 2, in addTermPaper.py File C:\KKirchner\Zope2.3.2b\lib\python\ZClasses\ZClass.py, line 535, in createInObjectManager (Object: TermPaperClass) File C:\KKirchner\Zope2.3.2b\lib\python\OFS\ObjectManager.py, line 305, in _setObject (Object: Traversable) File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFCore\PortalContent.py, line 155, in manage_afterAdd (Object: DynamicType) File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFCore\PortalContent.py, line 138, in indexObject (Object: DynamicType) File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFCore\CatalogTool.py, line 225, in indexObject (Object: Traversable) File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFCore\CatalogTool.py, line 218, in catalog_object (Object: Traversable) File C:\KKirchner\Zope2.3.2b\lib\python\Products\ZCatalog\ZCatalog.py, line 429, in catalog_object (Object: Traversable) File C:\KKirchner\Zope2.3.2b\lib\python\Products\ZCatalog\Catalog.py, line 397, in catalogObject File C:\KKirchner\Zope2.3.2b\lib\python\Products\ZCatalog\Catalog.py, line 504, in recordify File D:\Zope Installationen\Zope_2.3.1_final\lib\python\Products\CMFDefault\DublinCore.py, line 268, in created (Object: DynamicType) AttributeError: (see above) The problem seems to be the DublinCore but one of my ZClasses base class is the DefaultDublinCoreImpl. Does anyone know which classes are necessary? Thanks, Katrin --------------------------------------------------------- Katrin Kirchner beehive elektronische medien GmbH Fischerhüttenstr. 79 b D-14163 Berlin Tel.: 0 30 / 84 78 20

1 0

Re: [Support] Re: Collector #2244: Zope, sequence-
by Evan Simpson 07 Jun '01

07 Jun '01

From: "Chris Withers" <chrisw(a)nipltd.com> > Say I want to build something like this: > > <<< Showing 4 to 10 of 400 >>> Then you would probably find the Batch class from ZTUtils valuable. It's available from the same place as ZPT, which depends on it. It doesn't have all of the fancy features of dtml-in, but it is much simpler. You pass the sequence and batching parameters to the Batch constructor, and get an object that you can iterate over normally (using dtml-in or Python for:). Given Batch instance "b": <dtml-with b> <dtml-if previous><dtml-with previous> <a href="...?start=&dtml-start;"><<<</a> </dtml-with></dtml-if> Showing &dtml-start; to &dtml-end; of <dtml-var expr="_.len(seq)"> <dtml-if next><dtml-with next> <a href="...?start=&dtml-start;">>>></a> </dtml-with></dtml-if> </dtml-with> This code will work above, below, or inside of the <dtml-in b> loop. Cheers, Evan @ digicool

2 4