- Zope - Zope lists

Zope object database capabilities
by Steven Turoff 06 Feb '02

06 Feb '02

Greetings, I'm not sure whether or not to use an external database (mySQL) for my site. I can envision, for example, having a folder, 'reports', that contains 100,000 reports. Each report is either a folder or a dtml-document with a 'client' property. I would use some dtml to go thru all of the reports and list those that belong to the currentClient: <dtml-in "reports.objectValues()"> <dtml-if "client == currentClient"> <dtml-var sequence-item> </dtml-if> </dtml-in> Or, I can do this using mySQL. If Zope's database is capable of scaling this large, I'd rather use it. Any thoughts? Thanks, Steve

1 0

Re: [Zope] ZEO Issue
by Tim Owen 06 Feb '02

06 Feb '02

I stopped ZEO, renamed the log file, restarted ZEO and checked the logs several times today. The problem seems to be gone now. I will check again later, but looks like restarting did the trick. Regards. ----- Original Message ----- From: "Dieter Maurer" <dieter(a)handshake.de> To: "Tim Owen" <timowen(a)voyager.net> Cc: <zope(a)zope.org> Sent: Tuesday, February 05, 2002 5:04 PM Subject: Re: [Zope] ZEO Issue > Tim Owen writes: > > I am trying to learn how to administer my Zope/ZEO servers and need to > > figure out what errors to care about. Is the ZEO error below something I > > can/should resolve. It occurs frequently in the storage_events.log. > > Thoughts? > > > > ------ > > 2002-02-03T16:33:10 ERROR(200) ZEO Server error > > Traceback (innermost last): > > File /usr/local/zope/2.4.3/lib/python/ZEO/StorageServer.py, line 304, in > > message_input > > File /usr/local/zope/2.4.3/lib/python/ZODB/FileStorage.py, line 625, in > > modifiedInVersion > > (Object: /usr/local/zope/instance/var/Data.fs) > > KeyError: ^@^@^@^@^@^@h<9E> > Does not look good! > > I have seen this, too. Restarting ZEO let it go away. > It's not a good sign, though... > > > Dieter > This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies.

1 0

title property bug (zope 2.5.0)
by Adam Warner 05 Feb '02

05 Feb '02

Hi all, It appears that even though you can delete the title property from a folder you cannot add it again. I came across this when trying to debug a duplicate property id error. Say you have called this python script from the current folder: #Delete all existing properties context.manage_delProperties(context.propertyIds()) You can then check the current folder "Properties" and indeed the title property is no longer listed. However you can't add it again: context.manage_addProperty('title', 'test property value', 'string') return This error results: Error Type: Bad Request Error Value: Invalid or duplicate property id Unfortunately I am no longer able to add a title property using the Zope management interface either. Interim workaround seems to be: never delete a folder's title property. How do people suggest I recreate the folder titles that have already been 'deleted'? BTW I've run fstest.py and the Zope database is still fine. Thanks, Adam

4 6

Question Regarding Unauthorized Logins And Custom Error Messages
by J. Joy 05 Feb '02

05 Feb '02

I am trying to make it so that my Zope installation brings up a custom error message if a person cannot log into it successfully. I have tried putting in the standard_error_message, but it seems that this type of error is beyond this as I still get a site error screen? Is it possible to have Zope show something else? Jason __________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com

3 7

Field type 'Date' in SQL request
by champier2002 05 Feb '02

05 Feb '02

Hi, The application has a link with an Oracle database. In the SQL table the field is defined like this : DATE_NAI_IND DATE with NULL When I try to use this field in a SQL request, for example : select DATE_NAI_IND, COD_ETU from VUE_TRAV_EXT_RVM_RES where TO_CHAR(DATE_NAI_IND,'dd/mm/yy')= "08/08/1997" or DATE_NAI_IND = "08/08/1997" I always receive the same error : Error, dco2.DatabaseError: (904, 'ORA-00904: Nom de colonne non valide') Thanks for your help

3 4

ZEO Issue
by Tim Owen 05 Feb '02

05 Feb '02

I am trying to learn how to administer my Zope/ZEO servers and need to figure out what errors to care about. Is the ZEO error below something I can/should resolve. It occurs frequently in the storage_events.log. Thoughts? ------ 2002-02-03T16:33:10 ERROR(200) ZEO Server error Traceback (innermost last): File /usr/local/zope/2.4.3/lib/python/ZEO/StorageServer.py, line 304, in message_input File /usr/local/zope/2.4.3/lib/python/ZODB/FileStorage.py, line 625, in modifiedInVersion (Object: /usr/local/zope/instance/var/Data.fs) KeyError: ^@^@^@^@^@^@h<9E> ___________________ Tim Owen Cell: 517.285.7071 Home: 989.224.4905 eFax: 425.940.5905

3 2

Python script error when tying to manage_addZSQLMethod
by Dean Grubb 05 Feb '02

05 Feb '02

Hi can someone tell me why I get this error Error Type: AttributeError Error Value: manage_addZSQLMethod from this python script item_id = "test_DTMLDocument" item_title = "Test DTML Document" item_body = """<dtml-var header>...<dtml-var footer>""" sqlName = "SQL_SELECT_ALL" sqlTitle = "View All" dbName = "dbConn" argumentString = "wid given surname" templateString = "SELECT * FROM clients" context.manage_addDTMLDocument(id=item_id,title=item_title,file=item_body) context.manage_addZSQLMethod(id=sqlName,title=sqlTitle, connection_idÛName,arguments=argumentString, template=templateString) what have I missed? I can get the manage_addDTMLDocument to work ok, but not the manage_addZSQLMethod. Dean

3 2

upgrading python
by Daniel Mahler 05 Feb '02

05 Feb '02

Hi, If I am using a source zope distribution and upgrade Python (2.1.1 -> 2.1.2 in this case) do I need to rerun the zope build script? thanks Daniel

2 1

versions question
by Steven Turoff 05 Feb '02

05 Feb '02

Greetings, Is it possible to use emacs when working with versions? If so, how do I open files? Thanks, Steve

2 1

Globals disappearing in extmethod?
by Joseph A Knapka 05 Feb '02

05 Feb '02

Hello, friends. It may be that I am misunderstanding something fundamental. I have code that does essentially the following: (1) Defines an external method for processing form data: # In module MyModule: def myExtMethod(req): global Request Request = req action = getFormData("action") #...process request... # And a utility function to help out - this is not an # external method, but is used by myExtMethod. def getFormData(key): return Request.get(key) (2) Defines a DTML document that just passes its input along to myExtMethod(): ... <dtml-var expr="myExtMethod(REQUEST)"> ... The point of this is that myExtMethod() is a wrapper around some old CGI code; I want the state of MyModule to be preserved between invocations of myExtMethod(), for performance reasons. I've been working with Zope for only a very short time (days), so I don't know if this is the "right" way to do this; I'd appreciate any advice on this matter. Now the problem. This code works most of the time. However, apparently at random, when executing a request, I will get an exception from getFormData(): "global name Request does not exist." This is very strange, because /every/ invocation of getFormData() is called from myExtMethod(), so there's simply no way the Request global can be unset, as far as I can see. Can anyone explain what is happening here? A pointer to relevant documentation would be sufficient; I've got "The Zope Book" and "The Book of Zope", neither of which have been much help about this particular issue (though quite helpful in many other ways). Many thanks, -- Joe "I should like to close this book by sticking out any part of my neck which is not yet exposed, and making a few predictions about how the problem of quantum gravity will in the end be solved." --- Physicist Lee Smolin, "Three Roads to Quantum Gravity"

3 11