- Zope - Zope lists

Squishdot error.
by Ignacio Valdes 28 Mar '00

28 Mar '00

Hello all, I've exported my www.linuxmednews.com site from my home machine where I developed it (and on which it was working fine) to my ISP's Zope. For some reason I'm getting the following error. Not sure why as again, it was working fine on my localhost. Any ideas? -- IV Zope Error Zope has encountered an error while publishing this resource. Error Type: KeyError Error Value: squishlogo Troubleshooting Suggestions This resource may be trying to reference a nonexistent object or variable squishlogo. 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 /home/zope/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home/zope/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /home/zope/Zope-2.1.4-linux2-x86/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home/zope/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/zope/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /home/zope/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: index_html) File /home/zope/Zope-2.1.4-linux2-x86/lib/python/OFS/DTMLMethod.py, line 145, in __call__ (Object: index_html) File /home/zope/Zope-2.1.4-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: index_html) File /home/zope/Zope-2.1.4-linux2-x86/lib/python/OFS/DTMLMethod.py, line 141, in __call__ (Object: site_footer) File /home/zope/Zope-2.1.4-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: site_footer) KeyError: (see above)

1 0

External Method2
by Tom Deprez 28 Mar '00

28 Mar '00

I found everything I needed, however the iteration doesn't work :-( Can somebody tell me why the functions below are not giving a result? def recursiveMethod(obj): result = [] if obj.aq_parent != None: result = recursiveMethod(obj.aq_parent) if obj.meta_type=='KBItem': result.append(obj.Title) return result Then call this method like: def GetParentNames(self): recursiveMethod(self) ------ OR -------- def GetParentNames(self): result=[] obj=self while obj.aq_parent != None: obj=obj.aq_parent if obj.meta_type=='KBItem': result.append(obj.Title) return result Thanks in advance, Tom.

1 0

using MySQLdb 0.1.2
by Hugo Ramos 28 Mar '00

28 Mar '00

Yellow, I don't know about all you but I'm trying to use MySQLdb 0.1.2 on NT4 + SP6a + Zope 2.1.4 The Installation Instructions aren't to precise on using it on win32 platforms and Zope doesn't show me the MySQLdb on the product list. Is there some special steps to install it on NT? I've seen the instructions page on zope.org and I know about having to aplly the patch and compiling the .py on unix systems.. but what about win32? anyone? tnks -------------------------------------------------------------- Hugo Ramos - hramos(a)ruido-visual.pt Ruido Visual

3 2

Re: [Zope-dev] Installation/MySql Operational Status
by Chris McDonough 28 Mar '00

28 Mar '00

Ben, Hi... This topic is probably better suited for the main Zope mailing list so I moved my reply to it there. Err... we'd all love to see better docs written for this process. Maybe you can write them once you get it done. :-) No, Zope does not necessarily need to be installed from source, but I think the MySQLdb stuff needs python include libraries. Can you give more specific questions about your problem? Some hints anyway: - the MySQL development libaries need to be installed on the machine. - python 1.5.2 libraries should be installed on the machine "Ben B." wrote: > > Hello All, > This may be a semi-newbie question, but it seems to be stumping us all > around here. We are trying to get MySql 3.22 and Zope 2.1.6 working > together. According to all the documentation that we have been able to > read, we are required to install Zope from source files. Does anyone out > there have a clear cut answer to this problem? Is it feasable to use RPM's > instead of src? Any documentation on installing from source, integrating > with mysql or any of the above would be invaluable at this point. Any > direction towards good documentation would also be helpful. Also, any > python commands or extensions that we would have to build would be > essential. I have yet to see a good explanation to this issue. If anyone > has done it, or knows the correct way to get these 2 working together, > please let us know. Thanks > > ----Ben B. > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) -- Chris McDonough Digital Creations Publishers of Zope - http://www.zope.org

2 1

Re: [Zope] Upload files in Zope and store elsewhere
by Tres Seaver 28 Mar '00

28 Mar '00

Chris Withers <chrisw(a)nipltd.com> writes: > > I'd also love to be able to store files uploaded through a Zope form into a > MySQL database so if > anyone else has done this successfully, particularly for medium size files > (5-6 MB) please can you > let the list know! > > cheers, > > Chris > > Marius Kjeldahl wrote: > > > > After some helpful advice, I have been successful in uploading files > > (images) to Zope. Now I am trying to stuff the uploaded images in a > > MySQL database, but am not able to access the image data. > > > > If I try to stuff the image data "raw" into the database by declaring a > > image:string parameter to the ZSQL Method and <dtml-sqlvar image> in > > the ZSQL code I get a string like "<ZPublisher.HTTPRequest.FileUpload > > instance at 87956214>". > > > > Another approach I have tried was <dtml-var image fmt=sql-quote>, but > > this complains about the image being an instance and not a string. > > > > Another approach has been to access the actual "raw" image data using > > image.data in various combinations, but I have not gotten this to work > > anywhere (contrary to what it seems other people have managed to do), > > see this > > > > http://www.egroups.com/group/zope/26227.html? > > > > posting. > > > > Looking through Image.py I see quote a few methods for accessing the > > image as a "web" object through the use of URL. Internally, Image.py > > uses the data attribute extensively, but I have not been able to access > > this from within DTML (and I guess this has to do with data not being > > listed in either the properties or permission sections of Image.py). > > > > My final try will probably be to resort to using an External method to > > get access to the "full" Image.py object (including data), but I was > > hoping to avoid this. > > > > Has anybody done this (uploading in Zope and storing the data outside of > > Zope) successfully? If so, please give me a hint.. My advice here is not based on work with Zope, but on years of painful RDBMS experience: I do *not* recommend storing large BLOBs in any existing RDBMS -- they aren't built for them, and generally make your life miserable when you try. Most of the reasons you would choose to use an RDBMS (performance, replication, stability, searchability, etc.) don't apply when it comes to large BLOBs; you are still much better off storing the "BLOB" in a filesystem somewhere, and then storing a path/URL to it in the RDBMS. With Zope, BLOBs present another issue: because they aren't standardized, each RDBMS has a proprietary API for BLOBS; the Zope database adapter therefore has to have custom code for each RDBMS, making the BLOB code one of the likeliest sources of weird, hard-to-reproduce bugs I can think of. In short, *don't go there*. Really, I'm serious. Tres. P.S. If you *have* to go there, use the Python base64 module to encode binary data. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

2 1

External Method
by Tom Deprez 28 Mar '00

28 Mar '00

I want to make an external method which does the following : iterates over all the parents, if a parent is of a certain type, the title must be added to a list. However I don't know how to iterate over an object (ZClass) it's parents in Python/Zope. Can anybody help? def GetParentNames(self): obj=self result=[] while obj.parent<>nil: <-- this is wrong obj=obj.parent <-- this is wrong if obj.meta_type=='KBItem': result.append(obj.Title) return result Thanks in advance, Tom.

3 3

Who created this object?
by Chris Withers 28 Mar '00

28 Mar '00

Hi, I'm in the process of cleaning up our production Zope server and I've found a folder which has one file in it. I don't know who created either of them and I'm wondering if they're redundant. I'd like to find out who created the both the folder and the file and, if possible, when it was last created. How do I go about doing this? Cheers for any help, Chris

1 0

Zope hosting
by Marco Mariani 28 Mar '00

28 Mar '00

Hallo! I'm thinking about using zope to develop some sites. May you please advise me about a Zope hoster? I've looked at those listed on zope.org, but some of them offer just 20MB or have most of the site written in german. One of them I can't even reach, others don't mention zope on their pages, or are a bit on the pricey side. I need a flexible, expandable solution. I may need 40MB and two domains for a start, and more in the future. I have to install my products and use pgsql or mysql. Shell access is welcome, too.. Do you have some suggestion? Which ISPs do you think are best? - OR - Do you think I'd better install zope as a normal user, on one of those cheap ISPs that give me 500MB ? Thank you very very much.

6 5

Re: [Zope] Accessing ZSQL connection from external method
by Ragnar Beer 28 Mar '00

28 Mar '00

I just found a HOWTO by jpenny: Accessing a ZSQL method from an external method. It helps a bit but actually I don't want to use a ZSQL method I just want to take advantage of a persistant connection. Wait, I got an idea ... [20 min. later] Hooray! Try this: I have an open ZMySQL Database called 'my_connection'. Now I can query the db from my external method with: self.my_connection._v_database_connection.query('select * from whatever') [another 20 min. later] I benchmarked it agains opening a connection and cursor and then execute() and fetchall(). Using the Zope connection took about 60% of the time the other method took. I wonder if there are any disadvantages??? --Ragnar >I'll look around, but preliminarily, it looks like it has a __call__ >method that can be used to invoke it. Not sure on how you pass >parameters to it. It returns a sequence that contains the records >retrieved, then you can do with the sequence as you see fit. I'll >look around some more and let you know what else I find. > > >On Mon, Mar 27, 2000 at 10:28:27PM +0200, Ragnar Beer wrote: > > >Aha! I have it! > > > > > >Your external methods are given a pointer to self as the first > > >arguement. You can use this to access any methods in the current > > >folder (self is the current folder) So just call: > > > > > >self.MyZSQLMethod(arg1, arg2) > > > > > >where arg1 and arg2 are would be the arguments for the ZSQL Method. > > > > Could you also find out how to do anything useful with it? I have no > > idea how to use it. Is there a cursor() method and so on? > > > >-- >The things that interest people most are usually none of their business.

2 1

can't use a cast operator in a sql query
by Graham Chiu 28 Mar '00

28 Mar '00

I couldn't see this covered in the Zsql user's guide. select myfield from foo works as expected. As the current ODBC driver I am using has a bug which truncates varchar fields, it was suggested I cast it to char while retrieving the field. But select cast(my_varchar_field as char(140)) from foo gives an error with the following traceback... Zope Error Zope has encountered an error while publishing this resource. ValueError Sorry, a Zope error occurred. Traceback (innermost last): File D:\zope2\lib\python\ZPublisher\Publish.py, line 214, in publish_module File D:\zope2\lib\python\ZPublisher\Publish.py, line 179, in publish File D:\zope2\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook (Object: sqlTest) File D:\zope2\lib\python\ZPublisher\Publish.py, line 165, in publish File D:\zope2\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File D:\zope2\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_test) File d:\zope2\lib\python\Shared\DC\ZRDB\DA.py, line 319, in manage_test (Object: sqlTest) File d:\zope2\lib\python\Shared\DC\ZRDB\DA.py, line 300, in manage_test (Object: sqlTest) File d:\zope2\lib\python\Shared\DC\ZRDB\DA.py, line 415, in __call__ (Object: sqlTest) File D:\zope2\lib\python\Shared\DC\ZRDB\RDB.py, line 151, in __init__ ValueError: Empty column name, Using 2.1.6 with the ODBC DA. ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin

2 1