- Zope - Zope lists

Problem with passing objects from External Methods
by Jason Joy 10 Apr '01

10 Apr '01

This one has been driving me a bit crazy and I think there is a simple solution to this. I have written an external method to return a list of objects back to a DTML method which executes the code via a dtml-in. The dtml code looks like: <dtml-in processMethod(passthis)> <dtml-var sequence-index><dtml-var data><BR> </dtml-in> And this is passthis.py: import string, regex def passthis(passed): class element: pass info = [] structures = string.split(passed) for structure in structures: bit = element() ## Get Information here, and store it in foo. bit.data = foo bit.source = structure info.append(bit) return(info) --- When I run the code, I get a box that asks me to revalidate my Zope login and nothing works, finally, the system gives up and gives me an error with this at the bottom: File /usr/local/Zope-2.3.0/lib/python/AccessControl/ZopeSecurityPolicy.py, line 168, in validate Unauthorized: data Does anyone have any advice on this one? This is an example of what I am doing and I need to pass a list of objects (with about 10 properties on each) to be run through a dtml-in. Thanks, Jason ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1

2 1

any known bugs wrt transactions never being committed?
by Randall F. Kern 10 Apr '01

10 Apr '01

In particular, I'm running Zope 2.3.1 and PostgreSQL 7.1b4, (tried both PoPy and ZPsycopg). The (very annoying!) problem I'm having is the postgres backend is blocking on a transaction that should have already been committed (but wasn't). It seems that a transaction from an earlier request is not being aborted or committed, but rather just left hanging. There are no hung requests, i.e. every page we request we get back in the browser. Any ideas? Thanks! -Randy

2 1

Problems with the catalog
by Antonio João Costa 10 Apr '01

10 Apr '01

Hi I'm having problems with ZCatalog and discouvered that the source to my problems is the way ZCatalog catalogs the underscore character(_). When it gets this character the catalog splits the strings. Example: 'qq_root' is indexed ('qq','root'), instead of ('qq_root') Is there any way of bypass this problem without having to change ZCatalog? I'm working in Python directly. Thanks in advance. Antonio -- /------------------------------------------------\ | "Perfection is achieved, | | not when there's nothing else to add, | | but when there's nothing else to take away." | \----------------------------------------------- / URL: http://www.terravista.pt/Enseada/1831 http://accosta.planetaclix.pt http://students.fct.unl.pt/~anjc PT is Portugal ####### # # # #" #" # Linux ##vvvvv## Rules! ## vvv ## # ## ## ## ### ### +++##### ##++ ++++++# #++++++ +++++++# #+++++++ +++++#######+++++ +++ +++

2 1

Distribution of ZClass Product
by Stefan Mallepell 10 Apr '01

10 Apr '01

Hi I would like to distribute a ZClass Product from my Developing Server (Laptop ;) ) to my real public ZopeServer. I tryed the Distribution-Tab ... but I coudn't install it on my public Server. The tar.gz file contained a lib/python/Products/prodName directory and in that directory I found __init__.py, product.dat and version.txt . I copied the prodName directory (including the three files) to my lib/python/Products directory and restarted the server ... nothing happend ... So I transfered it via Import/Export - it worked and I started to run the website including some of my new objects. But now I developed further on my laptop and I would like to transfer the newer version of my product to the public server ... hmm ... well I tryed to play again the import export game ... this didn't worked, corse the MetaName was already inuse (well my Product which I like to update is using it - of corse) ... so I first deleted the Product on the public Server and imported the newer version - but now the new attributes are not available on the instances of the classes ... after a reboot of the server it worked properly * Now my questions. What have I done wrong in the proper way of distribution Zclass products? Is my "Export - delete - Import - reboot - Version" a valid way of doing it? Or do I wake up with a broken Database, crashed Webside, damaged installation? I'm sorry that I'm such a newbie ... but I really apriciate the help of this MailingList ... Yours Stefan Mallepell www.kisc.ch

1 0

ZStylesheets 4.0
by Danny William Adair 10 Apr '01

10 Apr '01

When trying to add a ZStylesheet instance, I get the following error: TypeError: too many arguments; expected 4, got 5 Traceback (innermost last): File .../Zope/lib/python/ZPublisher/Publish.py, line 223, in publish_module File .../Zope/lib/python/ZPublisher/Publish.py, line 187, in publish File .../Zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File .../Zope/lib/python/ZPublisher/Publish.py, line 171, in publish File .../Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addZStyleSheet) File .../Zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addZStyleSheet) File .../Zope/Products/ZStyleSheet/ZStyleSheet.py, line 39, in manage_addZStyleSheet (Object: Traversable) TypeError: (see above)

2 1

Re: [Zope] LAST_INSERT_ID and ZMySQLDA
by paul_s_johnson＠urscorp.com 10 Apr '01

10 Apr '01

Thanks for the tip! I had to do one other thing to get it work (this will hopefully help someone else down the road): When I did the SELECT this way: SELECT LAST_INSERT_ID() AS LastID I got this error: Error, _mysql.OperationalError: (1064, "You have an error in your SQL syntax near 'LIMIT 1000' at line 1") So I changed the "Maximum number of rows retrieved" property to zero to make that go away. So it still did not work when I tried your suggestion: SELECT filetypes_id where filetypes_id=LAST_INSERT_ID() However when I switched the "Maximum number of rows retrieved" property to something greater than zero it worked! Apparently the former SELECT statement is incompatible with the LIMIT clause that is tacked on by the "Maximum number of rows retrieved" property being greater than zero. Stated the way you suggest makes it compatible with a LIMIT clause. Thanks again. P.S. For me it was not necessary to explicitly insert a NULL or 0 value into the AUTO_INCREMENT field. Well this is not really a Zope question but since I just ported an sqlserver7 app to mySQL, I have the answer. 1) Name the auto_increment column in the column list 2) supply 0 or null as the value 3) To get the last_insert_id, the sytax is a little different, see below. Yours: INSERT INTO FileTypes (FileType, Extension) VALUES ("AutoCAD","DWG") <dtml-var sql_delimiter> SELECT LAST_INSERT_ID() AS LastID Changed (where filetypes_id is the name of your auto_increment column): INSERT INTO FileTypes (filetypes_id,FileType, Extension) VALUES (0,"AutoCAD","DWG") <dtml-var sql_delimiter> SELECT filetypes_id where filetypes_id=LAST_INSERT_ID() This was one of several issues I had to overcome, thank-you google. > ------------ Original Message ----------- > From: paul_s_johnson(a)urscorp.com <paul_s_johnson(a)urscorp.com> > Date: Tue, 10 Apr 2001 12:36:17 -0500 > > I have created a ZSQL method with an INSERT statement and a SELECT > statement containing a LAST_INSERT_ID function in it. These statements > are > separated by a <dtml-var sql_delimiter> tag. This is a typical scenario > in > which I want to grab the UNIQUE ID field value of the last record that was > inserted so I can use that value to insert a linked record in another > table. The ZSQL method returns nothing! If I understand this correctly > each ZSQL is a unique MySQL instance so these statements need to be in the > same ZSQL method in order to capture the correct LAST_INSERT_ID value, > right? > > Here's my ZSQL Method > ======================================== > INSERT INTO FileTypes (FileType, Extension) > VALUES ("AutoCAD","DWG") > <dtml-var sql_delimiter> > SELECT LAST_INSERT_ID() AS LastID > ======================================== > > This inserts a new record in the table and returns nothing. > > I also double checked and yes there is an AUTO_INCREMENT field in the > FileTypes table. I also tried using the alternate statement "SELECT * > FROM > FileTypes" after the delimiter tag thinking that perhaps the > LAST_INSERT_ID > () function was triggering the problem. This alternative returns nothing > as > well. It seems to me that you cannot have more than one statement in a > ZSQL method and have it return anything. > > As a work-around I could use a MAX() function in a separate ZSQL method > and > have it be correct 99.99% of the time since this is a low traffic site, > but > I still prefer a method that is 100%. Why doesn't this work? Aargh. > > P. Johnson > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

Re: [Zope] [Zope][Tree tag] to fade out elements of the Zope tree
by Dieter Maurer 10 Apr '01

10 Apr '01

Ulrike Ainser writes: > I have got another question and maybe somebody can help me....?! > > I want to fade out elements off the tree I have built e.g. acl_users, > index_html etc. and some folders. How can I do that? You define your own "branches" method or "branches_expr" expression filtering away what you do not like. Dieter

1 0

Re: [Zope] External Methods nightmare
by Dieter Maurer 10 Apr '01

10 Apr '01

Felipe Alvarez Harnecker writes: > i'm new to External Methods, and i got the following prob. > > In folder FOLDER a got 3 method A (dtml) B (Zsql) and C ( external ) > > the story is that method A call method B. From zope there is no > prob. with that but when i call A from C, zope complains that it can't > find B. > > I't seems that Zope forget that it is in FOLDER. Almost surely, you call "A" in the wrong way from "C", breaking the namespace/acquisition chain: DTML objects have 2 positional parameters: "client" and "REQUEST". When called automatically from DTML, these parameters are passed as "None" and "_". This way the namespace is passed into the called DTML object. If you call a DTML object explicitly, you must make sure to pass either a senseful "client" or a senseful "REQUEST". Otherwise, a DTML method will have no context at all while a DTML document only has its own containment context. More details in the DTML section of URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html Dieter

1 0

unable to access
by sharlynn 10 Apr '01

10 Apr '01

Hello. I am writing to you in hopes of receiving another avenue to try or a solution to my problem. I have been having a very consistent problem getting zope to work on my WinBook Si with Windows 98 and IE 5.5. When I try to access zope on my machine by typing the URLs http://127.0.0.1:8080 or http://sharlynn:8080/manage (which accurately reflects my local host name and port name), I get to the Zope Quick Start Page. Then, when i try to use the zope management interface, the username and password box comes up. But, when I enter the username and passwords that I entered when i downloaded and installed zope: it gives me three chances but never lets me in. Instead: it gives me the following message. ******************************* Zope Error Zope has encountered an error while publishing this resource. Unauthorized You are not authorized to access this resource. Username and password are not correct. Traceback (innermost last): File C:\Program Files\zopeaaa\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\Program Files\zopeaaa\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\zopeaaa\lib\python\ZPublisher\Publish.py, line 162, in publish File C:\Program Files\zopeaaa\lib\python\ZPublisher\BaseRequest.py, line 462, in traverse File C:\Program Files\zopeaaa\lib\python\ZPublisher\HTTPResponse.py, line 588, in unauthorized Unauthorized: (see above) ---------------------------------------------------------------------------- ---- Troubleshooting Suggestions 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. ************************************** In trying to remedy this problem, I have completely removed zope from my computer and reloaded it 4 times. I have made my user name and password extremely simple (username: aaa password: aaa) to eliminate the possiblity that i am typing it in incorrectly. I have also downloaded the newest version of IE (5.5) to ensure that that wasn't the problem. I do not know what else to try. Perhaps there is some setting on my hard drive...some error in your system... I don't know. If you have any insight, suggestions or ideas I would greatly appreciate them. I am supposed to be learning zope as part of my employment...but I cannot get in the front door! You can call me at (970) 209-9592 and I can work online as we talk, or you can e-mail me at waterstrider(a)frontier.net. Thanks so much. Sharlynn Cobaugh Mindview, Inc. PS... Don't know if this will help, but i want to give you all the information possible... I can access a zope account from the log in at the general zope website with the username: sharlynn and password: bandera. This has not helped me much however, because i am looking for elvis!!!!

1 0

RE: [Zope] insane Central Daylight Time, Zope 2.2.2
by Dieter Maurer 10 Apr '01

10 Apr '01

Brian Lloyd writes: > :( The problem is that DT is probably trying to do too much with > magical timezone recognition. At some point, some bonehead (and > I suspect it probably was me) accepted a request to add CDT to > the mapping without noticing that it is a good example of an > ambiguous timezone name. > > The problem now is how to fix it - we could change it to mean > 'CDT' (american central daylight time), but I suspect I'll then > get another bug report from somewhere in Europe telling me that > now its broken for them :( I never heard of "CDT" as a synonym for "GMT+2". The official timezone name of central Europe is "CET" or "CEST" (daylight saving), replacing the older "MET" and "MEST". Dieter

1 0