- Zope - Zope lists

SQL-Query works with MySQL-monitor but not with ZMySQLDA
by Andy Pahne 29 May '00

29 May '00

Hi, there, if I use my mysq-monitor to execute the following query, everything works fine: SELECT YEAR(START_DATE) FROM EVENT; but it doesn't work via the ZMySQLDA!?! Here's the traceback: Error, exceptions.KeyError: unhandled Traceback (innermost last): File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /zope/ttl/Zope-2.0.1-src/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /zope/ttl/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_test) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 316, in manage_test (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 297, in manage_test (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/DA.py, line 401, in __call__ (Object: sql_get_years_unique) File /zope/ttl/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/db.py, line 191, in query KeyError: (see above) Andy Pahne ap@net22 net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640

2 1

RE: [Zope] SQL-Query works with MySQL-monitor but not with ZMySQL DA
by Marcus Collins 29 May '00

29 May '00

> -----Original Message----- > From: Andy Pahne [mailto:ap@net22.net] > Sent: 29 May 2000 13:03 > To: zope(a)zope.org > Subject: [Zope] SQL-Query works with MySQL-monitor but not > with ZMySQLDA > > Hi, there, > > if I use my mysq-monitor to execute the following query, > everything works fine: > > SELECT YEAR(START_DATE) FROM EVENT; > > but it doesn't work via the ZMySQLDA!?! > > Here's the traceback: > > Error, exceptions.KeyError: unhandled [...] IIRC, this problem (which occurs when the results of functions, instead of columns, are returned) was mentioned some time back. You should be able to resolve it by aliasing the result: select YEAR(START_DATE) as START_DATE_YEAR from EVENT You can then refer to START_DATE_YEAR in your DTML. hth, -- Marcus

1 0

Expression syntax for sort= attribute in <dtml-in ..> tag.
by Agnieszka Karpierz 29 May '00

29 May '00

It's very, very... great news that Ross Lazarus's multikey sort patch for dtml-in tag is included in current Zope CVS and will be included in Zope 2.2. <dtml in "foo" sort=akey,anotherkey> But for me one important think is very missed. Possibillity of use expression syntax for sort= attribute. Maybe syntax: <dtml in "foo" sort="expression_which_ruturns_sort_keys"> would be possible ? eg. <dtml in "foo" sort="foo()"> where foo() will returns appropriate Python string eq. 'firstname,surname,height, width,weight' :) I hate constructions like this: <dtml-if something> <dtml in "foo" sort=key1,key2,key3> <dtml-elif something> <dtml in "foo" sort=key1,key3,key2> <dtml-elif something> <dtml in "foo" sort=key2,key1,key3> <dtml-elif something> <dtml in "foo" sort=key2,key3,key1> <dtml-elif something> <dtml in "foo" sort=key3,key1,key2> <dtml-else> <dtml in "foo" sort=key3,key2,key1> ... </dtml-in> What we think about ?. Adam Karpierz karpierz(a)itl.pl

1 0

how to keep all captions in one place?
by Philipp Dunkel 29 May '00

29 May '00

Hi I have a big project that is developed in english. Now I want to give this away for translating. The problem is that until now code and text/captions are mixed. Is there any way to store all captions/texts in one single place, so that I could do <dtml-var "CaptionKeeper.hello"> instead of Hello and that we only have to translate all Strings in CaptionKeeper? What kind of objects should CaptionKeeper be? A ZClass? TIA Philipp Dunkel ******************************************** * Philipp Dunkel ICQ# 60149094 * * zReal Productions * * meet me at DALNet chan #phidu * ********************************************

2 1

zcatalog & keyerror 30
by Jon Cheyne 29 May '00

29 May '00

Hi. Looked for but couldn't find any documentation on what these errors mean exactly. I cannot consistently reproduce them but they occur after editing a catalog aware zclass instance when you change indexed fields. The trace back is below. Both are resolved if you manually update the catalog - the edits are accepted but clearly the catalog is not fully updating. My zclass follows the various howtos and uses reindex_object. The 31 error I _can_ reproduce: when the zclass renders itself it includes an edit me link - the page footer lists (in slashdot style) other documents in the catalog. Once one document is selected, all the other links now referenced via the current document (aquisition?) thus the full name of the document on screen after a few clicks could be /db/doc1/db/doc2/db/doc3. It is when you edit a document in this state that produces the error. If you edit it when the name in the address bar is just /db/doc3 then it is fine. The keyerror 30 happens under either condition and not always. Neither error occurs when documents are created for the first time. I am kinda stuck here ... Jonathan the traceback .... Zope Error Zope has encountered an error while publishing this resource. KeyError Sorry, a Zope error occurred. Traceback (innermost last): File /home/zope/Zope-2.1.6-linux2- x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home/zope/Zope-2.1.6-linux2- x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /home/zope/Zope-2.1.6-linux2-x86/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/zope/Zope-2.1.6-linux2- x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: index_html) File /home/zope/Zope-2.1.6-linux2-x86/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: index_html) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: index_html) File /home/zope/Zope-2.1.6-linux2-x86/lib/python/OFS/DTMLMethod.py, line 146, in __call__ (Object: standard_html_footer) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: standard_html_footer) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/Products/Renderable/Renderable.py, line 17, in __str__ (Object: CatalogAware) File /home/zope/Zope-2.1.6-linux2-x86/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: render) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: render) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/DocumentTemplate/DT_In.py, line 493, in renderwb (Object: Catalog.searchResults(type=box_type)) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/DocumentTemplate/DT_In.py, line 710, in sort_sequence (Object: Catalog.searchResults(type=box_type)) File /home/zope/Zope-2.1.6-linux2- x86/lib/python/Products/ZCatalog/Lazy.py, line 190, in __getitem__ File /home/zope/Zope-2.1.6-linux2- x86/lib/python/Products/ZCatalog/Catalog.py, line 181, in __getitem__ KeyError: 30

3 2

Hot backups
by Patrick J.M. Keane 29 May '00

29 May '00

Is there any facility in Zope for doing a hot backup, without shuting down zope, taking a backup copy of var -- can this result in inconsistencies in the internal DB, or does it use something mystical to prevent corruption? If not, what other options exist for this? Thanks Patrick

3 2

perl for zope: a few last comments and then I'm done
by Roman Milner 29 May '00

29 May '00

OK, I just wanted to say a couple more things about this and then I'll shut up. I've given it a lot of thought - trying come up with a way of looking at it that still makes zope attractive. So, I started thinking - what if it had been a language that I like instead of perl. (lisp, java...) Also, many people pointed out that zope already allows methods in other languages. (sql, dtml, xslt). The thing is - the other languages currently supported address specific domains. AFAIK, python is the only "general purpose" language that zope allows methods in. And I don't really think there is much to gain from two tools that do the same thing. It is sort of like the perl vs. python philosophy. Perl - do one thing many different ways, python - one obvious way to do something. So, if this had been a language more pleasing to me, I still think I would be against it. IMHO, I think zope should be developled with the python philosphy as much as possible. That is one of the reason I chose it. Also, I don't really think this is about getting access to all the perl modules. In truth, python can talk to perl in the same way it can talk to java, or any language. Corba, sockets, xml-rpc, any number of ways. So, if there was something that perl could talk to that python can't, or something written in it that you didn't want to write in python - you could get to it one of these ways, without having to have actual perl code (or any other language) *inside* your zope application - which seems to add unneeded complexity. I agree that this will certainly grow the zope community and that many perl coders are highly intelligent and helpful. But I don't think growth at the expense of complexity is necessarily good. The idea of perl "black boxes" is nice - but I think not realistic. People love their favorite languages (including me) and are going to use it for everything they possible can. I I apologize for the emotional bases of my earlier posts. It attests to my love of zope/python. About 8 months ago I left a job at a large corporation where perl was mandated, for a job at a startup where I was basically allowed to decide what would be used for web development. That startup now has the largest voice over ip network in the world, and we are feverishly trying to give our customers a web interface to the network - using zope. This announcement made me question my decision to go with zope - something I thought I would never do. The fact is, I think we have too much code written for zope to switch at this point. Shutting up now, ^Roman

1 0

Zope tutorial problem
by Harry Henry Gebel 29 May '00

29 May '00

I just installed Zope 2.2.0a1 and when I tried to add the Zope tutorial product I got the following error: The database connection connection cannot be found. Here is the traceback from the source: The database connection <em>connection</em> cannot be found. </BODY></HTML> <!-- Traceback (innermost last): File /home/local/Zope/lib/python/ZPublisher/Publish.py, line 224, in publish_module File /home/local/Zope/lib/python/ZPublisher/Publish.py, line 189, in publish File /home/local/Zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /home/local/Zope/lib/python/ZPublisher/Publish.py, line 175, in publish File /home/local/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addTutorial) File /home/local/Zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: addTutorial) File /home/local/Zope/lib/python/Products/ZopeTutorial/TutorialTopic.py, line 194, in addTutorial File /home/local/Zope/lib/python/OFS/DTMLMethod.py, line 160, in __call__ (Object: setup) File /home/local/Zope/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: setup) File /home/local/Zope/lib/python/DocumentTemplate/DT_In.py, line 691, in renderwob (Object: sample_data) File /home/local/Zope/lib/python/DocumentTemplate/DT_Util.py, line 333, in eval (Object: insert(_.getitem('sequence-item'))) (Info: insert) File <string>, line 0, in ? File /home/local/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 412, in __call__ (Object: insert) AttributeError: (see above) If it makes any difference, I am using a Data.fs that I copied in from a 1.1.2 install. I tried to add several other product and they were all successful. -- Harry Henry Gebel, Senior Developer, Landon House SBS West Dover Hundred, Delaware

1 0

test
by Chris McDonough 29 May '00

29 May '00

ignore please

1 0

Where can I install Zope?
by Darin Mosier 29 May '00

29 May '00

I just found out that I cannot run executable files on my server. I have a 9NetAve.net virtual hosting account. They tell me I cannot run Zope on the server. Does anyone know this to be true? (Will not run on a virtual host) Do I have to have my own server? If so could someone suggest an alternate service or something for me? Thank You Darin Mosier _______________________________________________________ Are you a Techie? Get Your Free Tech Email Address Now! Many to choose from! Visit http://www.TechEmail.com

2 1