May 2003 - Zope - Zope lists

DTML-SQLVAR and Unicode and PostgreSQL
by Glenn R Williams 23 May '03

23 May '03

Hi All, I am trying to set up a simple retrieval of data in my PostgreSQL database. The input (in Arabic) has to be in unicode. I can specify an argument of 'arabic_name:ustring' and that is accepted okay. However, something happens between the submission of the form and the execution of the query in the PostgreSQL backend, and no data is returned. If I cut the query, paste it into a terminal window, and excute it in psql, I get the desired data back. Anyone have any ideas? I notice that 'ustring' is not a type you can specify in the dtml-sqlvar tag. (I am running Redhat Linux 9.0, Zope 2.61, and the ZPsycopgDA adaptor). TIA, Glenn -- Glenn R Williams Ghoti Software ---------------------------------------------------------------------- Mathematical theories are the part of science you could continue to do if you woke up tomorrow and discovered the universe was gone.

2 4

where is Richard Jones
by David Bear 22 May '03

22 May '03

looking for Richard Jones author of ReStructuredText .. anyone? ----- Forwarded message from ASU Postmaster <Postmaster(a)asu.edu> ----- Date: Wed, 21 May 2003 18:21:51 -0700 (MST) From: ASU Postmaster <Postmaster(a)asu.edu> To: David.Bear(a)asu.edu Subject: Delivery Notification: Delivery has failed This report relates to a message you sent with the following header fields: Message-id: <20030521182147.J8806(a)asu.edu> Date: Wed, 21 May 2003 18:21:47 -0700 From: David Bear <David.Bear(a)asu.edu> To: richard(a)bizarsoftware.com.au Subject: [ajung(a)andreas-jung.com: Re: [Zope] structuredText vs ReStructureDocument] Your message cannot be delivered to the following recipients: Recipient address: richard(a)bizarsoftware.com.au Reason: Remote SMTP server has rejected address Diagnostic code: smtp;550 5.1.1 <richard(a)bizarsoftware.com.au>... User unknown Remote system: dns;bigboy.bizarsoftware.com.au (TCP|129.219.110.73|47591|203.89.194.114|25) Original-envelope-id: 0HF900C02L4CGR(a)asu.edu Reporting-MTA: dns;post2.inre.asu.edu (tcp-daemon) Action: failed Status: 5.1.1 (Remote SMTP server has rejected address) Original-recipient: rfc822;richard(a)bizarsoftware.com.au Final-recipient: rfc822;richard(a)bizarsoftware.com.au Remote-MTA: dns;bigboy.bizarsoftware.com.au (TCP|129.219.110.73|47591|203.89.194.114|25) Diagnostic-code: smtp;550 5.1.1 <richard(a)bizarsoftware.com.au>... User unknown Date: Wed, 21 May 2003 18:21:47 -0700 From: David Bear <David.Bear(a)asu.edu> To: richard(a)bizarsoftware.com.au Subject: [ajung(a)andreas-jung.com: Re: [Zope] structuredText vs ReStructureDocument] I've been forwarded to the source. any advice? ----- Forwarded message from ajung(a)andreas-jung.com ----- Date: Tue, 20 May 2003 08:30:53 +0200 (CEST) From: ajung(a)andreas-jung.com To: David.Bear(a)asu.edu Subject: Re: [Zope] structuredText vs ReStructureDocument Please contact the author of the product Richard Jones. -aj > I'm confused again -- or just perpetually. > > I've used the structured text product in the past and liked it. Well, > with zope 2.6 and cmf it appears structure text has been buried into > other products but is not itself and 'product' I can use directly, ie > add it from the zmi. > > So, I found ReStructuredText which appears to replace StructuredText. > fine. I added it. However, I note that there doesn't seem to be a way > to add a 'Title' property to the ReStructuredText object when it is > created. Am I missing something very obvious here or it it not > possible to modify the title property on this product? > > -- > David Bear > phone: 480-965-8257 > fax: 480-965-9189 > College of Public Programs/ASU > Wilson Hall 232 > Tempe, AZ 85287-0803 > "Beware the IP portfolio, it will make criminals out of innovators" > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) ----- End forwarded message ----- -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing" ----- End forwarded message ----- -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"

1 0

Problem with a python script
by Andreas Pakulat 22 May '03

22 May '03

Hi, got a really weird problem here: Error Type: ValueError Error Value: unsupported format character '"' (0x22) at index 45 testing the following python script: ## Script (Python) "create_tabheader" ##bind container=container ##bind context=context ##bind namespace= ##bind script=script ##bind subpath=traverse_subpath ##parameters=tabs=['tab1','tab2'],activetab=1 ##title= ## # Example code: """ Erzeugt den Tempalte-Code für die Karteikarten, damit wird der HTML-Code übersichtlicher und ist nicht statisch an die Anzahl an Karteikarten gebunden """ # Import a standard function, and get the HTML request and response objects. from Products.PythonScripts.standard import html_quote request = container.REQUEST RESPONSE = request.RESPONSE spsrc = context.getImage('spacer.gif') wsrc = context.getImage('white-border-transp.gif') ysrc = context.getImage('yellow-border-transp.gif') fmtstr = '<tr><td style="background-color:#006699;width:3px"><img src="%s"' %(spsrc) fmtstr += ' style="display:block" width="3" height="3"></td>' fmtstr += '<td style="background-color:#FFFFFF"><table border="0" cellspacing="0" cellpadding="0"><tr>' for i in range(0,len(tabs[:-1])): fmtstr += '<td class="tabborder"><img src="%s" width="3" height="3"' %(spsrc) fmtstr += ' style="display:block"></td> ' fmtstr += '<td style="background-color:#FFFFFF"><img src="%s" ' %(context.getImage('border-begin.gif')) fmtstr += ' width="3" height="3" style="display:block;width:2em;"></td></tr><tr> ' lastelem = len(tabs)-1 for i in range(0,lastelem-1): if i == activetab: fmtstr += '<td class="headernamewhite"><a class="Karteikarte" ' fmtstr += ' href="index_html?activetab=%d">%s</a></td>' %(i,tabs[i]) else: fmtstr += ' <td class="headernameyellow"><a class="Karteikarte"' fmtstr += ' href="index_html?activetab=%d">%s</a></td>' %(i,tabs[i]) if i+1 == activetab: fmtstr += '<td class="headerborderwhite"><img ' else: fmtstr += '<td class="headerborderyellow"><img' if i == activetab: fmtstr += ' src="%s"' %(wsrc) else: fmtstr += ' src="%s"' %(ysrc) fmtstr += ' style="display:block; width:2em; height:2em;" width="10" height="10"></td>' if activetab == lastelem: fmtstr += '<td class="headernamewhite"><a class="Karteikarte" ' isrc = wsrc else: fmtstr += '<td class="headernameyellow"><a class="Karteikarte" ' isrc = ysrc fmtstr += ' href="index_html?activetab=%d">%s</a></td>' %(lastelem,tabs[lastelem]) fmtstr += '<td class="headerborderwhite"><img src="%s" ' %(isrc) fmtstr += ' width="10" height="10" style="display:block;width:2em;height:2em"></td></tr></table></td>' fmtstr += '<td style="background-color:#FFFFFF;width:95%"><img src="%s"' %(spsrc) fmtstr += ' width="3" height="3"></td></tr>' return fmtstr The error is because of the last %(spsrc) on the third-last code-line and I don't understand why it doesn't work there?? Andreas -- You are so boring that when I see you my feet go to sleep.

2 2

properties of ZPT
by Andreas Pakulat 22 May '03

22 May '03

Hi, I've got a small thing with ZPT here. My template got a property "activetab", which represents the number of the active tab in the template. This affects mainly the coloring of table headers. My problem is how to change this property by clicking on a link within one of the tabs?! My first thought was to use a script, but how do I tell the script which tab/link was clicked on? Or can I directly change the property by linking to the template? Andreas -- Try to have as good a life as you can under the circumstances.

2 2

Setting session vars from hyperlinks
by Phil Bradbury 22 May '03

22 May '03

Hello, Probably an easy solution but it is evading me. I basically want to code some 'text only' and 'printer friendly' links at the top of each page which, when clicked, will set a session variable checked on the index_html page to determine which template to use for each page. Is there a standard way to do this sort of thing, and if so what is it?? Do I need to direct the hyperlinks to a python script to set the session var and then to redirect back to the initial page (this seems clumsy), or is there some more elegant way? I have currently defined a file with many macros in it and use this to build up the current view by stipulating a layout and using the macros in the relevant places. This template (called 'standard') is just 'directed to' by the index_html file which is called whenever a navigation link is chosen. The new index_html file would (I presume) simply check for the existence and value of the session var and then decide which template to use based on it.... I am unsure how to actually best set the session var in the first place though! Your help and comments would be appreciated! Phil Bradbury

2 1

Temporary Storage?
by Chris Withers 22 May '03

22 May '03

Hi, I'm hoping someone can shed some light on this... What is a 'Temporary Folder'? How does it relate to a 'Session Data Container'? What happens if you instantiate a 'Session Data Container' in a normal folder? Are previous revisions for objects kept in memory or on disk for information stores in a TF or SDC? Can you use either of these to store a mapping where you want key/value pairs to expire after a certain amount of time? If so, how would you do so? cheers, Chris

2 1

Data.fs corruption, __before_publishing_traverse__ and POSKeyError
by Alexander James Tucker 22 May '03

22 May '03

Hi, I'm currently trying to rebuild a system after some kind soul installed a rootkit, and having some difficulty bringing back a Zope installation. I copied out the 1/2Gb Zope database, reinstalled everything from scratch, including an upgrade to Zope 2.6.1, and copied back the Data.fs, expecting at least to be able to get at the management interface to see what damage was left to patch up, which products I had to install etc. However, the first problem is that it seems the database is quite corrupt. Zope starts, but accessing any page including management screens gives me AttributeError: __before_publishing_traverse__ I have tried various incarnations of the fsrecover.py script, which most of the time gets rid of the corruption but leaves me with the same error. I did once manage to get the database to a stage where I could get in, albeit having rolled back to August 2002 (I guess the last time anyone did a pack!) However, I then came across a couple of POSKeyErrors :( Has anyone come across the first error before? Is there any way I can get some useful traceback to indicate what's causing the error, since looking at the page source there is no trace information. Hopefully, Alex.

2 1

Flash Problem with Zope
by beno 22 May '03

22 May '03

Hi; I need to redirect the index_html page to different Flash files based on screen res. I have done this successfully before, but with the strange effect that I've had to put the .swf file in the root dir of the site. I prefer to have it in a higher dir. Has anyone else had this problem? Am I doing something wrong? TIA, beno

3 4

Re: How to Add a File Dynamically??
by Josef Meile 22 May '03

22 May '03

> While adding a new folder I would like to add 3 files by default into the > folder (like when i add a folder object through ZMI) > 1) index_html - (Page Template) > 2) tree.py - (Python Script) > 3) getPath.zsql - (ZSQL Method) I did it for a DTMLMethod, but I think it is similar to the other cases. In my case, I just created an external method with this: from OFS import DTMLMethod def createMethod(folderObj, id, title, text): # Creates a dtml Method DTMLMethod.addDTMLMethod(self=folderObj,id=id,title=title) #Gets a reference to the created object ob=folderObj._getOb(id) #Changes the contents of the created object ob.manage_edit(data=text,title=title) You just have to look at the html source code of the Zope's manage interface and see what methods are called when creating/editing a python script, page template and a ZSQL Method. Then, you have to search the implementation of this methods to see what parameters you need and which packages you have to import. Regards, Josef

4 4

Fresh install fails in minutes
by Scott Wunsch 22 May '03

22 May '03

I've just set up a fresh new Red Hat 9 installation, and dropped in a fresh install of Zope 2.6.1 (from the binary tarball on the Zope site, which I believe includes its own Python interpreter). I'm currently testing it out by starting it like this: su - zope -s /bin/sh -c "/opt/zope/start" Yes, the /opt/zope/var directory is properly owned by the zope user. It works fine for a few minutes, but after I poke around a bit (especially once I hit the management interface), it suddenly stops responding to requests. The process is still running, and it's still accepting connections, but it completely ignores those connections. Nothing is logged (not even the requests I'm making) after it stops responding. I'm running it through Apache via FastCGI, but I've also tried running only the HTTP server on port 8080, and the same thing happens there. Any ideas what I should be looking for? -- Take care, Scott \\'unsch ... Oh give me a phone, with a modem on loan...

5 4