- Zope - Zope lists

to all Swiss Zopistats: Invitation to IEXPO2002
by Robert Rottermann 06 Feb '02

06 Feb '02

Hello, I would just like to make sure you don't miss the two Zope boots at the Swiss IExpo 2002 Stephan Goeldi is at boot 1.124 redCOR is at 5.149 (with Internic) see you Robert www.redcor.ch

1 0

OFS object attributes from a SQL DB? (ZPatterns)
by ra＠burningman.com 06 Feb '02

06 Feb '02

Hi all, I'm trying to create a Folder-ish ZClass that has certain attributes which are actually linked to data that lives in a SQL database. I know I could just use methods to access the data, but I'm trying to gain some ZPatterns foo, and it seems to me that I should be able to get this data to be exposed exactly as though it were just a regular attribute on a PropertySheet. I'm having a hard time finding the magic combination, though... As I understand ZPatterns, these folder objects should be DataSkins, with DataManagers that would fetch and store the data where appropriate. However, if I try to create a ZClass with both OFS:Folder and ZPatterns:DataSkin as base classes, whenever I try to add it somewhere I get a Key Error for "_v_dm_". Can anyone help me discover the "right" way to use ZPatterns to make a persistent Object File System type of object transparently mingle attributes from PropertySheets, SQL Methods, etc.? I know that I'm close... I just can't quite wrap my head around it... Thanks, -r

1 1

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