- Zope - Zope lists

Out of memory while compressing data
by Norman Khine 17 Apr '01

17 Apr '01

Hello, The Zope server still keeps on crashing continiously, I am getting the following error: Error Type: MemoryError Error Value: Out of memory while compressing data Traceback (innermost last): File /usr/home/khine/usr/local/Zope/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/home/khine/usr/local/Zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/home/khine/usr/local/Zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File /usr/home/khine/usr/local/Zope/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/home/khine/usr/local/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_menu) File /usr/home/khine/usr/local/Zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_menu) File /usr/home/khine/usr/local/Zope/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__ (Object: manage_menu) File /usr/home/khine/usr/local/Zope/lib/python/Shared/DC/Scripts/Bindings.py, line 354, in _bindAndExec (Object: manage_menu) File /usr/home/khine/usr/local/Zope/lib/python/App/special_dtml.py, line 236, in _exec (Object: manage_menu) File /usr/home/khine/usr/local/Zope/lib/python/TreeDisplay/TreeTag.py, line 154, in render (Object: a tree tag) File /usr/home/khine/usr/local/Zope/lib/python/TreeDisplay/TreeTag.py, line 260, in tpRender (Object: ApplicationDefaultPermissions) File /usr/home/khine/usr/local/Zope/lib/python/TreeDisplay/TreeTag.py, line 514, in tpRenderTABLE (Object: ApplicationDefaultPermissions) (Info: (['AAAAAAAAAAI=', []], {'childless_decoration': '', 'id': 'tpId', 'branches': 'tpValues', 'nowrap': '1', 'url': 'tpURL'}, (['AAAAAAAAAAI=', []],), (['AAAAAAAAAAI=', []],))) File /usr/home/khine/usr/local/Zope/lib/python/TreeDisplay/TreeTag.py, line 389, in tpRenderTABLE (Object: Traversable) MemoryError: (see above) I am using Zope 2.3.1 with python 2.0 on freebsd4 Any ideas. Thanks Norman ========================================= "Eternity is Time Time, eternity To see the two as opposite Is Man's Perversity" The Book of Angelus Silesius

2 1

zmysqlda connection error
by Vishnu Prasad 17 Apr '01

17 Apr '01

Hi I am getting the following error when I tried starting Zope 2.3.1. This error comes after i extracted the zmysqlda(2.0.6) on Products dir. <ERROR> File c:\progra~1\aukum\lib\python\OFS\Application.py, line 536, in import_produts (object: string) File c:\program files\aukum\lib\python\products\zmysqlda\__init__.py, line 91 in ? File c:\program files\aukum\lib\python\products\zmysqlda\DA.py, line 91 in ? File c:\program files\aukum\lib\python\products\zmysqlda\db.py, line 91 in ? ImportError: No module named _mysql </ERROR> The other resources and versions which i used are: Python: Python2.0 release for Win 32 Zope: Zope 2.3.1 binary release for Win 32 (running as a standalone service) MySQL: mysql-3.23.36 for win 32 I have a doubt in the installation of the MySQLDB(0.3.5). Can someone help immediately for step-by-step from MySQLDB installation? thanks and regards, vishnu __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

2 1

Delete a DTML-document
by Frank Zorge 17 Apr '01

17 Apr '01

Hi, Does anybody know how to delete (one or more) DTML-document(s) in a folder via DTML or Python (in a pythonscript) and not via the manager interface. Or maybe where I can find documentation about it. It's not in the howto's or on the mailinglist. Thanks Frank Zorge Inline informatisering & consultancy Witte Rozenstraat 48 2311 XX Leiden tel: (+31) (0)71 5133577 fax: (31) (0)71 5121366 email: zorge(a)inline-info.nl algemeen: info(a)inline-info.nl website: www.inline-info.nl

2 1

zope + sql
by Duncan Booth 17 Apr '01

17 Apr '01

> Once this is done the values would be passed back to sql and UPDATE > used to replace the old values. I'm not quite sure how to do this > either. Do you have a loop, where inside the loop the UPDATE is goes > through each marked record, or do you loop inside the > > UPDATE tablename set > variable=newvalue > where ----loop here with or's------ > > Any suggestions or similar examples would be appreciated. > I did something similar a while back. I display the results of the query, and each record has an 'approved' field that may be set to 0 or 1. The SQL method to do this looks like: Parameters: fldId fldApproved:int=1 Body: UPDATE O_Fixtures SET fldApproved = <dtml-sqlvar fldApproved type=int> <dtml-sqlgroup where required> <dtml-sqltest fldId multiple type=int> </dtml-sqlgroup> The form displays each record, and includes one column in the output that looks like: <dtml-unless fldApproved> <td><INPUT type=checkbox name="fldId:List" value="&dtml-fldId;"></td> </dtml-unless> The primary key for each database entry is the value fldId. When the form is submitted it includes a variable fldId which is a list of the ids of all records to be updated. The SQL method will expand to apply the update to a single record or all the selected records as appropriate. for example, if record 2 is selected the SQL looks like this: UPDATE O_Fixtures SET fldApproved = 1 where fldId = 2 but if records 2, 3, and 4 are selected the SQL looks like: UPDATE O_Fixtures SET fldApproved = 1 where fldId in (2, 3, 4) -- Duncan Booth duncan(a)dales.rmplc.co.uk int month(char *p){return(124864/((p[0]+p[1]-p[2]&0x1f)+1)%12)["\5\x8\3" "\6\7\xb\1\x9\xa\2\0\4"];} // Who said my code was obscure? http://dales.rmplc.co.uk/Duncan

1 0

Growing Refcounts
by Juan Carlos Coruña 17 Apr '01

17 Apr '01

Hello all! I'm requesting a Zope server through xmlrpc every 3 seconds. If I look at the debug information I can see that the refcounts of xmlrpclib.Unmarshaller and xmlrpc.FastParser grows: Class April 17, 2001 11:28 am April 17, 2001 11:57 am Delta xmlrpclib.Unmarshaller 2927 9655 +6728 xmlrpclib.FastParser 1465 4829 +3364 Is there a memory leak in Zope?

2 1

Re: Broken Pipe again
by Chris McDonough 17 Apr '01

17 Apr '01

Hi Luiz, I'd like to try to continue including the list on this conversation. The pattern you've observed isn't really enough to go on... if Zope is dying during a request, that log script thingy should show you that fact... but if you say that it happens every morning, on any link you click on... well... I'm not sure. ;-) Did I already ask you to send object reference information from the debug screen of the control panel? If not, could you send it (preferably before you go home for the night, before it crashes, but after it's been running for a while). Thanks! - C ----- Original Message ----- From: Luiz Antonio B. Silva To: Chris McDonough Sent: Monday, April 16, 2001 8:31 AM Subject: Broken Pipe again > Hi Luiz, > > I cc'ed the zope mail list on this question... > > That message appears when a browser breaks the current connection before the > response is returned, and it's normal under most circumstances. It may or > may not have anything to do with your Zope stability problem. > > A good thing to do would be to turn on detailed logging via the "-M" switch > to z2.py. After you gather information in the log, use the script at > http://www.zope.org/Members/mcdonc/HowTos/DEBUG-LOG to figure out what > requests aren't returning. See if there's a pattern. > Well Chris, I did that. Nothing but dots from the log. Here goes another strange thing that may help solve this: Currently, I´m the only one working on that zope. I work all day long with no problems (except that exceptions poping up on the console side), but EVERY morning, when I start to work with it, click on the view tab and then click on any link, the server dies. So, I start it up again, click on the view, then on the same link again and "voilá", it works fine until next morning. What could be happening?

3 5

Zope Forms (Newbie help)
by Barry Robinson 17 Apr '01

17 Apr '01

Gday all, Anyone know a good place to start with learning about using forms in Zope? Cya round Barry _____________________________________________________________ Get a game -> the Wedge Tailed Eagles

3 2

zope + sql
by William Herring 17 Apr '01

17 Apr '01

I hope someone has an example or suggestion. Using Znolk, I SELECT from a table and the list is viewed. However, I would like to choose certain records (mark them from the viewed list) and then change a variable of only the marked records to a single new value. The new and old variable values are finite, they could come from a pull down list. So the idea would be to show the list from SELECT, but have an pull-down menu of new values at the top of the page that should be replaced for the variable to edit. The user would choose the new value from the pull-down and then go down the page and mark each record for which that value would be UPDATEed in the table Once this is done the values would be passed back to sql and UPDATE used to replace the old values. I'm not quite sure how to do this either. Do you have a loop, where inside the loop the UPDATE is goes through each marked record, or do you loop inside the UPDATE tablename set variable=newvalue where ----loop here with or's------ Any suggestions or similar examples would be appreciated. -- ======================================== William Herring Beef Cattle Genetics S-132 Animal Science Research Center University of Missouri, Columbia 65211 voice:573.884.6860 fax:573.882.4798 ========================================

1 0

Allowing secure 'import' access in zope folder hosting
by Ivo van der Wijk 17 Apr '01

17 Apr '01

Hi All, We provide zope hosting, both folder based (where people have access to their own folder, mapped to a domain, and no access to the zope server / source / var / import / lib directories) and pure zope hosting (i.e. an entire own zope server for this customer) In the folder case, one of our customers whishes to upload his locally developped site as .zexp to our zope server and import it there. Can this be done safely? I.e. withouth compromising the other customers security? >From some discussions where had on #zope I understand that expecialy proxy roles may be a problem which may be fixed by requiring the user to take ownership. Would this fix all security issues? Or are there any other unforseen problems? Would anyone know another solution to achieve the same functionality? (ftp won't work, as you can't, for example, upload userfolders) Would it be possible to perform a scan on an xml exports for unwanted proxy roles and other security issues? Thanks, Ivo -- Drs. I.R. van der Wijk -=- Brouwersgracht 132 Amaze Internet Services V.O.F. 1013 HA Amsterdam -=- Tel: +31-20-4688336 Linux/Unix based corporate Fax: +31-20-4688337 and Web: http://www.amaze.nl/ Internet Solutions Email: ivo(a)amaze.nl -=-

1 0

Fulltextsearch with ZCatalog
by Steffen Bergmann 17 Apr '01

17 Apr '01

Does anybody know how I can do a fulltext search over the whole content of a Zope structure with ZCatalog. In the ZBook it is mentoined but not explained. And is there any way of automatic indexing over all objects of ZOPE? In one ZClass this works good, but I don´t want too add an Catalog for each of my ZClasses. Steffen

2 1