- Zope - Zope lists

Re: [Zope] Problen wtih dtml-in inside Zsql method
by Dieter Maurer 08 Nov '00

08 Nov '00

Alejandro Pancani writes: > .... The problem is that when I execute the Zsql > method 'sql_2' it seems to execute the sql_select_next_val method two times > because at the next time that I execute 'sql_2' the value returned from > sql_select_next_val is incremented in 2 in comparison with last value > returned. I need it to be incremented in 1. > > > > the code of sql_select_nextval method is the following: > > SELECT seq.NEXTVAL val > FROM DUAL > > > the code of sql_2 method is the following: > > <dtml-in "sql_select_nextval"> > > insert into anytable > (oid_anytable, name) > values > (<dtml-var val>, > 'john') > > <dtml-var sql_delimiter> > > select * from anytable where oid_anytable = <dtml-var val> > > </dtml-in> Try to remove the "..." around "sql_select_nextval". I do not understand why your code with the "..." works at all. If this does not solve your problem, you may try: insert into anytable (oid_anytable, name) values (seq.NEXTVAL,'john') <dtml-var sql_delimiter> select * from anytable where oid_anytable = seq.CURVAL That's the code, we use successfully ('CURVAL' may be wrongly spelled, though). Dieter

1 0

RE: [Zope] XMLRPC accessing Zope DTML/SQL methods
by Dieter Maurer 08 Nov '00

08 Nov '00

Mayers, Philip J writes: > def extmethod(self, REQUEST): > return str(REQUEST) > > >From the web that prints the string Representation of REQUEST. But, over > XMLRPC, this: > > s=xmlrpblib.Server("http://server.name/Zope/path/") > s.path.extmethod() > > Returns the string representation of REQUEST, but *this* > > s.path.extmethod('rrr') > > return 'rrr'. What's happening? That's the ZPublisher magic: it tries to match the requirements of the called object with what is provided by the request. In your first example, you did not provide a parameter, but your function requires one. ZPublisher determined the "REQUEST" object as candidate based on the parameters name. In your second example, you did provide a parameter. ZPublisher used this positional parameter to satisfy the first positional parameter of your function. Thus, if your function requires two parameters: say 'text' and 'REQUEST', your second example would behave as your first now does. There is a document on zope.org that describes this ZPublisher magic in more detail. But maybe, you already know enough to fulfill your requirements. Dieter

1 0

calendar help (newbie)
by James Sintz 08 Nov '00

08 Nov '00

I want to use the Calendar Tag product to display the subject of my daily newsletters (newsletter archive), but there are no examples of how to display anything other than propval stuff. I would like the calendar to show the subject for each day and link to the newsletter but only show newsletters prior to or equal to today's date (I create most of them weeks in advance). The newsletters are created with a zclass and have a subject, goLiveDate and body fields. Anyone have example of how to do something like this? Thanks!! Jamey

1 0

Re: [Zope] Cloning a ZClass-Instance
by Dieter Maurer 08 Nov '00

08 Nov '00

brocken22(a)gmx.de writes: > Hallo, > 'news'is a zclass and when I'm using a hardcoded value for x it's working. > > that's the cloning-method: > ------------------------------ > <dtml-in "objectValues(['news'])"> > <dtml-let x=sequence-item> > > <dtml-if "now.isCurrentDay()"> > <dtml- call "manage_clone(_.getitem('x',0),'firstclone', [REQUEST])"> > > Copied! > <dtml-else> > Not needed to clone!! > </dtml-if> > </dtml-let> > </dtml-in> > ------------------------------ > And the traceback: > --------------- > The object one does not support this operation Whereever you use a name in DTML, the referenced object is called, if it is callable. In your case, you use the name "sequence-item" in the "dtml-let". Apparently, your "news" instances are callable. If I am right, then "x" is a string (which of cause does not support cloning). Try: <dtml-let x="_.getitem('sequence-item')"> .... </dtml-let> Dieter

2 2

Re: Re[4]: [Zope] Is data.fs corrupted?
by Chris McDonough 08 Nov '00

08 Nov '00

Hi Alexander, I am going to take this back to the Zope list... Have you examined the STUPID_LOG_FILE? It seems you're showing us the error from an interactive session, but there should be more information in the log file. It seems you've narrowed this down in some fashion to Yihaw. How did you do that, what brought you to that conclusion? What class does the pickled data in the "could not load oid" traceback seem to be an instance of (as per STUPID_LOG_FILE)? ----- Original Message ----- From: "Alexander Chelnokov" <alex(a)orto.unets.ru> To: "Chris McDonough" <chrism(a)digicool.com> Sent: Wednesday, November 08, 2000 1:43 PM Subject: Re[4]: [Zope] Is data.fs corrupted? Hello Chris, Wednesday, November 08, 2000, 11:23:44 PM, you wrote: CM> Your ZODB isn't corrupted... it's a configuration issue. You've deleted a CM> class without deleting all of its instances from the ZODB, most likely. I definitely didn't do that. And for example Yihaw directory is present in Products directory and all its class are. I can add any object form Yihaw family and while i in the same session all is working like a charm. But if i close the browser, next attempt to access the object from another session shows the broken object. CM> You can probably figure out which classes they are, reinstall the products I failed to reintstall the products - the error message was in my previous message. I tried to do this over existing product and after its removal with the same result. Looks like some parts of a deleted product persist in ZODB. CM> they come from, and delete their instances, thereby making the errors go I just removed Yihaw, packed the database and tried to import it again and got the same error... Error Type: Could not load oid =², pickled data in traceback info may contain clues Error Value: None -- Best regards, Alexander N. Chelnokov Ural Scientific Institute of Traumatology and Orthopaedics 7, Bankovsky str. Ekaterinburg 620014 Russia ICQ: 25640913

1 0

Second Try: Zope FTP tunneled through SSH1
by Rob Miller 08 Nov '00

08 Nov '00

Nobody picked up at all on my first post of this question, so I'm hoping I have better luck this time. Does anyone out there even have any leads for me in this situation? Here's the repost: I'm trying to tunnel FTP connections to a Zope server through SSH1 to ensure that passwords don't get sent in the clear. (I know the session will still be unencrypted; that's okay for now.) I've followed the instructions for doing so that are available at http://www.employees.org/~satch/ssh/faq/ssh-faq-5.html#ss5.6, and doing so I can successfully create an FTP session through an SSH tunnel. The problem is, once I've logged in, Zope won't let me do anything. It responds to every valid command with a single word: 'Unauthorized.' I know I'm connected to the server, because 'cd'ing into a nonexistent directory gives me a 'No Such Directory' response, byt 'cd'ing into a valid directory gives me th 'Unauthorized' response. If I connect directly to the FTP server using the same login and password, all works well. If this can't work, does anyone have Zope FTP server connections being tunneled through an encryption layer? I'd really like my developers to be able to use their favorite editor with an FTP connection, but I really don't want management-capable passwords flying around in the clear. Thanks for your time and assistance, rob

1 0

tags for export & import
by jacintha menezes 08 Nov '00

08 Nov '00

Hi, Kindly give dtml tags or python module for doing import & export in zope.Since i am not able to send the query output as an attachment with zope mail facility i am thinking of using import & export. thanks, bye, jacintha

2 1

Re: Is data.fs corrupted?
by Darcy Clark 08 Nov '00

08 Nov '00

Alexander, we encountered a similar error (i.e. Could not load oid + broken products etc....) a while back on our install of 2.1.6 on Windows. We first tried deleting all products gradually in the hope that we could trace which one of them had caused the 'corruption', but to no avail. The error would not go away even after we had essentially deleted everything from the Zope installation other than the basic products. The only way we solved the problem was by upgrading to 2.2.2 and then manually importing all products and content into the new Zope installation :( If I am not mistaken this problem has been reported several times to this list with essentially the same reported symptoms. Darcy --- In zope(a)egroups.com, Alexander Chelnokov <alex@o...> wrote: > Hello All, > > After a linux machine crash or cold restart something strange is going > on with Zope (2.2.2) - all objects built on ZClass-based products like > Yihaw or QSurvey are broken. Products are in Product folder, and i > even can add an object and it works, but when i try to access it in a > new browser window it reports > ========== > This object is broken because the unknown product that created it is > no longer installed or is installed incorrectly. Please contact your > product vendor for assistance. > Note that the data associated with this product has not been lost, and > will be accessible again if the product is reinstalled. > ========== > > Well, i removed QSurvey and tried to re-install its current version - > something goes wrong again: > > ========== > Zope Error > Zope has encountered an error while publishing this resource. > > Error Type: Could not load oid ={, pickled data in traceback info may > contain clues > Error Value: None > ========== > > Is there any way to fix ZODB less radical than complete reinstall? > > -- > Best regards, > Alexander N. Chelnokov > Ural Scientific Institute of Traumatology and Orthopaedics > 7, Bankovsky str. Ekaterinburg 620014 Russia > ICQ: 25640913 > > > > _______________________________________________ > Zope maillist - Zope@z... > 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

Tar Ball with all Zope-Howtos
by Manuel Gutierrez Algaba 08 Nov '00

08 Nov '00

Is there such a best ? I email zope admin and he kindly pointed me to a site where I could download a .pdf with all Howtos. Is there the _real_ .tar.gz ? Thanks zope admin and thank you guys. BTW, what means things like " _.method()" In pure python the "_" has not special sense, what object is "_" ? -- Regards/Saludos Manolo www.ctv.es/USERS/irmina /TeEncontreX.html /texpython.htm /pyttex.htm /cruo/cruolinux.htm ICQ:77697936 (sirve el ICQ para algo?)

2 1

Product removal stress: a plea for help
by seb bacon 08 Nov '00

08 Nov '00

If anyone can shed some light on this it would be a great help to the newbies out here. Perhaps I could even do a HOWTO, and lighten the load on the list considerably ;) I don't have a solution to Alexander's problem quoted below, but it's one I keep hitting and one that is frequently asked on this list. In fact it's one I recently asked for more info on, to no avail. So I thought I'd add my voice to the clamour. Deleting products seems to be a very risky business in Zope. Things apparently get left behind in the ZOBD which shouldn't be there. If I delete a product that was used at some point elsewhere, I don't just get broken objects, I get pickled data streaming out of my Zope most of the time. Today I had an interesting one: I thought I had cleaned up thoroughly after an unwanted product, and I was getting no error messages and no pickled junk on stderr. The only thing I couldn't do is add ZClasses, for which I got the error message quoted by Alexander below (could not load object oid=[random character]). Please, can any Master Zopician give an explanation: 1) what causes this kind of error? 2) how do you debug it? 3) how do you fix your Data.fs? Thanks! Seb. * Alexander Chelnokov <alex(a)orto.unets.ru> [001108 18:21]: > Hello All, > > After a linux machine crash or cold restart something strange is going > on with Zope (2.2.2) - all objects built on ZClass-based products like > Yihaw or QSurvey are broken. Products are in Product folder, and i > even can add an object and it works, but when i try to access it in a > new browser window it reports > ========== > This object is broken because the unknown product that created it is > no longer installed or is installed incorrectly. Please contact your > product vendor for assistance. > Note that the data associated with this product has not been lost, and > will be accessible again if the product is reinstalled. > ========== > > Well, i removed QSurvey and tried to re-install its current version - > something goes wrong again: > > ========== > Zope Error > Zope has encountered an error while publishing this resource. > > Error Type: Could not load oid ={, pickled data in traceback info may > contain clues > Error Value: None > ========== > > Is there any way to fix ZODB less radical than complete reinstall? > > -- > Best regards, > Alexander N. Chelnokov > Ural Scientific Institute of Traumatology and Orthopaedics > 7, Bankovsky str. Ekaterinburg 620014 Russia > ICQ: 25640913 > > > > _______________________________________________ > 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