- Zope - Zope lists

SquishDot properties
by tom smith 06 Jul '00

06 Jul '00

hi, I'd like to add a URL property to a Squishdot article (and remove the "dept" property), is this possible and how would I do it? Also, can I auto-complete the "from" field with the users' username that they have logged in with....this is for an intranet cheers tom

2 1

Newbe question concerning using python classes and external methods
by Gaspard, Bradley S 06 Jul '00

06 Jul '00

All, I am a new Zope user and I guess I'm missing something fundemental that I haven't been able to glean from the documentation and various "How-to's". As a learning tool I am trying to implement one of Brian Lloyd's examples I found on the Web implementing a GuestBook. I suspect what I don't understand is how to write the external method that would make use of this class (The one I have been playing with follows the class definitions). Anyhow, I've created an an external method and call (e.g. <dtml-var guest>) after which the guestBookForm is displayed. After filling out the form and submitting it Zope does not seem able to find the signGuestBook method. What am I doing wrong?? Other than mostly trivial examples, I haven't been able to find many complete (working) examples of using external methods. Thanks in advance for any help. """Module guestbook: a simple guestbook application""" class GuestBook: """A guestbook object that provides both the forms and the handling of submitted form data.""" def __init__(self, title, filename): self.title=title self.filename=filename def guestbookForm(self): """Return the guestbook from to the user""" return """<HTML> <HEAD><TITLE>%s</TITLE></HEAD> <BODY> <H2>%s</H2> Please sign our guestbook! <P> <FORM ACTION="signGuestBook" METHOD="POST"> Name: <INPUT TYPE="TEXT" NAME="name"><BR> Email: <INPUT TYPE="TEXT" NAME="email"><BR> <INPUT TYPE="SUBMIT" VALUE="Sign Guestbook"> </FORM> </BODY> </HTML>""" % (self.title, self.title) def successPage(self): """Return a page to thank the user on success""" return """<HTML> <HEAD><TITLE>%s</TITLE></HEAD> <BODY> <H2>Thank You!</H2> Thank you for signing %s! </BODY> </HTML>""" % (self.title, self.title) def signGuestBook(self, name, email='not specified'): """Handle a submitted guestbook form""" # Open a file to save the guestbook entry try: file=open(self.filename, 'a') except IOError: file=open(self.filename, 'w') entry='Guestbook entry: %s %s\n' % (name, email) file.write(entry) file.close() return self.successPage() External method import sys sys.path.append('/usr/local/src/Zope-2.1.6-linux2-x86/lib/python/Shard/jscap e/winsat') import guestbook def AddGuest(self): myGuestBook=guestbook.GuestBook('My GuestBook', 'guestbookdata.txt') return myGuestBook.guestbookForm() Brad

1 0

ZWiki with RemoteWikiLink - minor fix and remaining question
by Geoff Gardiner 06 Jul '00

06 Jul '00

I needed to create 'proper' URLs with a remote wiki link, but ZWiki 0.6.1 only allowed things of the form ZWikiName:name-with-characters-only. I suppose my locale setting translates too many things to whitespace, but I'm not sure. A simple fix in the ZWikiPage.py file (sorry no diff here): find line interwikilink = r'!?((?P<local>%s):(?P<remote>[\w]+))' % (wikilink) replace string [\w] by [A-Za-z0-9/:@_~#=\.\-\?] (note I couldn't include the % char because it seems to provoke the need for another string). Remaining question. Does anyone have a fix for the incorrect rendering of [notzwikiname] to nested URL <a href=notzwikiname><a href=notzwikiname>notzwikiname</a></a> or do I have to fix that for myself? This also fails to work as a remote wiki link, and I thought a fix for one might be a fix for the other also. Thanks. Geoff Gardiner

1 0

MacOSX
by tom smith 06 Jul '00

06 Jul '00

I noticed in the how-tos that someone had managed to make a build of zope for MacOSX . Given that I know nothing about unix commands, is there a pre-made binary I can just drop onto my G4 (running OSX DP4) and run? Is this even possible or is it not the unix way? IS there a reason for there not being a macintosh version of zope, does the platform not allow it or is it just that nobody has wanted to do it tom

1 0

RE: [Zope] LONG insert > 2000 chars fail
by Chris McDonough 06 Jul '00

06 Jul '00

Use <form action=bleah method=post>? > -----Original Message----- > From: Andy Gates [mailto:Andy.Gates@bristol.ac.uk] > Sent: Thursday, July 06, 2000 10:32 AM > To: zope(a)zope.org > Subject: Re: [Zope] LONG insert > 2000 chars fail > > > Message-ID: <EXECMAIL.1000706153218.Q(a)kosh.bris.ac.uk> > Priority: NORMAL > X-Mailer: Execmail for Win32 5.1 Build (9) > MIME-Version: 1.0 > Content-Type: Text/Plain; charset="us-ascii" > > Possibly related: Webform-based news story editor generates > long text > strings for body text. Using an ordinary form, this ends up > (url-encoded) in the URL, but it's betting truncated after about 2000 > chars. Many of my stories are longer than that. What to do? > > AndyG > > _______________________________________________ > 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] LONG insert > 2000 chars fail
by Riku Voipio 06 Jul '00

06 Jul '00

On Thu, Jul 06, 2000 at 08:48:43AM -0400, Satheesh Babu wrote: > Hi, > > We use Oracle v 8.1.5 and 8.1.6 and there we can go upto > 5000 characters for string literals. Anyway, LONG is a > deprecated datatype and we decided to use detail tables > for text more than 4000 chars. Any given string will be > split at 4000 chars and inserted as one or more records > into detail table, as varchar2 fields. Varchar2 fields > are easy to process also. Yes, you are right, we are using 8.1.5 On Linux, and it swallows up to 4k. But having to split a string to get it in the database feels pretty stupid. > I think it is more of an Oracle OCI problem than OracleDA. Yep, I tried to look at oci.c/oci.i sources and got shocked... Maybe overnight I'll gather some courage to see if it would be feasible to use 'bind variables' to push data in to the long columns. Or will it be easier to split text with a python external method. -- Riku Voipio riku.voipio(a)tietoenator.com 09-862 60764

2 1

Re: [Zope] CorruptTransactionError (Bad news for production site!)
by Richard Taylor 06 Jul '00

06 Jul '00

Jim Thank you for your prompt response. This is what I love about using Open Source Software, the responses come from peole who really know what they are talking about. Further responses in-line. Jim Fulton <jim(a)digicool.com> writes: > Richard Taylor wrote: > > > > Today I had to role back two days of transactions from my production > > site because when I packed the database I was informed of a > > CorruptTransactionError. > > Did anything else happen previous to this? Did you run out of space > or anything like that? > We had been doing some extensive development work and the ZDB had reached about 2Gbytes, but the disk was not full. I packed the database (down to 10M approx.) without any trouble. We then carried on using the system for another two days and I then packed the database again. This time I got the CorruptTransactionError. I followed the instruction to truncate the database and successfully recovered it. Close examination of the bobo_modification_times on the objects left in the database showed that the error occurred at about the time of the first pack. > You should have been able to use Data.fs.old, which is a copy > of the database before the pack to restore the data. Or was the > error in there too? I'd be interested in looking at the Data.fs > file before the pack to try to figure out what might have gone wrong. > Unfortunately the error occurred after (or during the first pack) the second pack over-rote the Data.fs.old with the corrupt database. The real problem was that the corrupt transaction did not have an immediate affect. > (If you send my your Data.fs file, please remember to send it > to me privately and to zip or compress it. :) > I would love to send you the Data.fs file but unfortunately it contents sensitive commercial information for my company and I would be sacked for sending it out. I know how difficult it is to track down bugs when people will not give you repeatable examples, but I just can't send this stuff out. > > We are using Zope for an internal knowledge management application > > where anyone in the organization can add objects. So I have no way of > > know what was added after the fateful transaction and no way of > > getting any of it back. > > > > Bummer! > > Indeed. > > > I think this raises a few questions about ZDB: > > > > 1) We need some tools for selectively removing bad transactions > > rather than just truncating Data.fs back to the last good one and > > loosing everything that comes after it. > > Zope 2.2 has just such a tool. In the ZODB directory, there is a > Python script, fsrecover.py which simply calls the recover function > in the FileStorage module. This will work with any 2.x databases. > It scans from both the beginning and the end of the file until > it finds a corrupted section and then removes the corrupted portion > from the file. You utility modifies the file in-place, so you need > to shut-down the site, or work on a copy when you use it. > Fantastic! this is exactly what I was banging on about. No if only I had not deleted the original corrupt Data.fs file out of discussed I would be able to get back my stuff (I think I need a serious talking to.) > > 2) We could do with a tools that can verify the ZODB offline. This > > could then be run at regular intervals (maybe once an hour from > > cron) so that corruptions can be picked up earlier. > > You could use a little Python script that did something like: > > import ZODB.FileStorage > file_name='../../var/Data.fs' > file=open(file_name, 'r+b') > index={} > vindex={} > tindex=[] > ZODB.FileStorage.read_index( > file, file_name, index, vindex, tindex) > > This basically reads the FileStorage index as would normally > be done during startup. > I shall be installing (and testing) this tonight! > > 3) Some way to find out what was added after a corrupt transaction is > > needed so that at least I could see who I need to ask to re-add > > their stuff. > > The fsrecover script should avoid the need for this. > Agreed. > Jim > Richard

1 0

Calling Stored Procedures using DCOracle
by Ronnie Sengupta 06 Jul '00

06 Jul '00

Hi, I am using DCOracle Ver 1.3.1 1b1. Connected to Oracle Ver 8.1.6. When I execute this : >>> conn.callproc('addarticle',['dfdsf']) I get the following Error : __getattr__ raise error, 'no usable procedure named '+name oci.error: no usable procedure named addarticle How ever if I do this : >>> conn.getSource('ADDARTICLE') It returns the source code. In short I need to run my stored procedures from python. They are all ready and waiting to be used. Some one help me :-) Regards, Ronnie ronnie_sengupta(a)jasubhai.com

3 3

Error tracing...
by Peter Arvidsson 06 Jul '00

06 Jul '00

How do I trace errors in Zope? I get the following error message: "Empty entry when integer expected " It gives a hint of the problem but I cant see what value is empty.. how do I control the values? Is there some way to write out variables or do I just have to guess???

3 2

RE: [Zope] wierdness with 2.2, Security, and manage_addProduct[' ']..
by Brian Lloyd 06 Jul '00

06 Jul '00

> Why won't this work in Zope 2.2? Make a DTML method containing: > > <dtml-with "manage_addProduct['ZCatalog']"> > <dtml-call "manage_addVocabulary(id='doofus')"> > </dtml-with> > > I cannot find a way to make the security system let this > through. > > <snip> > > I've pretty much convinced myself it's a bug in the 2.2 > security system... > > Anyone? Brian? It is (or rather was). The fix is in beta 4, out late today/ early tomorrow. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0