July 2000 - Zope - Zope lists

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

LONG insert > 2000 chars fail
by Riku Voipio 06 Jul '00

06 Jul '00

Hi, Looks like DCOracle/Zoracle still doesn't support LONG objects properly. According to Oracle's overly verbose "SERVER MESSAGES" manual the following means that oracle will accept only upto 2000 chars as quoted string, anything more should be uploaded via binded variables... Error Type: oci.error Error Value: (1704, 'ORA-01704: string literal too long') Traceback (innermost last): File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/lib/zope/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/lib/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: insert_reporter) File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: insert_reporter) File /usr/lib/zope/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: insert_reporter) File /usr/lib/zope/lib/python/DocumentTemplate/DT_String.py, line 504, in __call__ (Object: insert_reporter) File /usr/lib/zope/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: insert_report(app=app,tmodule=tmodule,ver=ver,header=header,text=text, tyyppi=TYYPPI)) (Info: header) File <string>, line 0, in ? File /usr/lib/zope/lib/python/Shared/DC/ZRDB/DA.py, line 430, in __call__ (Object: insert_report) File /usr/lib/zope/lib/python/Products/ZOracleDA/db.py, line 189, in query File /usr/lib/zope/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 298, in execute File /usr/lib/zope/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 221, in _parse File /usr/lib/zope/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 109, in _error oci.error: (see above) -- Riku Voipio riku.voipio(a)tietoenator.com 09-862 60764

1 0

keyword index and netscape vs ie
by Jonathan Cheyne 06 Jul '00

06 Jul '00

Hi all. I am using a keyword index as per the excellent howto. I use the following snippet to list the keywords as a series of links to further searches. (this is the objects index_html) related topics: <dtml-in keywords> <a href="search?key=<dtml-var sequence-item>"><dtml-var sequence-item></a><br> </dtml-in> This works fantastic if you are using IE or a keyword is just one word. Netscape does not seem to do anything intelligent if it is a key phrase instead and returns an error. Below are examples of the resolved urls it is trying to load IE .../search?key=direct%20access Netscape .../search?key=direct access Explorer pads out with the %20 - netscape does not - in fact netscape only works if a + appears instead. Netscape and Explorer add the + if a form field is used instead (similar to that at the top of the zope site etc) So my question to the gurus is is there an attribute or expression I can use to get round this? How can I specify that the two (or more) words in a keyword phrase are separated by pluses when the link is generated? yours in hope Jonathan

3 3

Zope-help
by Bruno Nana 06 Jul '00

06 Jul '00

Please would you help me to resolv this problem. That is that some search im Database after you chose a group of letters: <<< <form action="anzeige_sort_kunden" method="post"> <TR> <td width="30"> </TD> <TD >alphabetisch</TD> <TD><SELECT NAME="alphabet" SIZE="1" TITLE="Alphabet" STYLE="width:140"> <option value="alle">alle Firmen</option> <option value="A_D">beginnend mit A-D</option> <option value="E_H">beginnend mit E-H</option> <option value="I_L">beginnend mit I-L</option> <option value="M_P">beginnend mit M-P</option> <option value="Q_T">beginnend mit Q-T</option> <option value="U_Z">beginnend mit U-Z</option> </SELECT></TD> </TR> >>> I have this in web. And in the ZMethod i have this: select * from iekunde  where (substring(firma,1,1)=substring(,1,1) or substring(firma,1,1) > substring(,1,1)) and (substring(firma,1,1)=substring(,3,1) or substring(firma,1,1) < substring(,3,1))  And the error is this: Error Type: Error Error Value: Error processing select * from iekunde where (substring(firma,1,1)=substring(UuZ,1,1) or substring(firma,1,1) > substring(UuZ,1,1)) and (substring(firma,1,1)=substring(UuZ,3,1) or substring(firma,1,1) < substring(UuZ,3,1)) Invalid column name 'UuZ'. Invalid column name 'UuZ'. Invalid column name 'UuZ'. Invalid column name 'UuZ'. That mean that the operator ">" can only compare two number. So that my question: How can convert substring(UuZ,1,1) ( i mean a string) in a number im zope Method. So can i do: substring(firma,1,1) > substring(UuZ,1,1) or substring(firma,1,1) < substring(UuZ,1,1)) when the two member are comparable(number) Bruno

2 1

Reportlab and Zope
by Jorge Magalhaes 06 Jul '00

06 Jul '00

Hi: In this post i report my experience with Reportlab in Zope: 1. Install the Reportlab package in /usr/local/Zope/lib/python1.5 directory 2. in the Zope directory i create a sub folder ./pdffiles and: > cd /usr/local/Zope/pdffiles > su > chmod 777 3. in the Extensions folder i create ####################### # mymodule.py ####################### import string from reportlab.pdfgen.canvas import Canvas from reportlab.lib.pagesizes import A3, landscape from reportlab.pdfgen.textobject import PDFTextObject from types import * def helloworld(): c = Canvas("./pdffiles/helloworld.pdf", pagesize=landscape(A3), bottomup=0) c.setFont("Times-Roman", 12.0, leading=10.0) c.drawString(100,100, "Hello World") c.showPage() c.save() ######################## 4. In Zope: External module: ID: HelloW function: helloworld module: mymodule Local File System ID: Hello patch: /usr/local/Zope/pdffiles DTML Method: ID: HelloWorld .... <dtml-call "HelloW"> <a href="Hello"> See the pdf file </a> ... My question is: How i can insert the contents of the Local File System in to HTML environment? Have a nice day Jorge

1 0

wierdness with 2.2, Security, and manage_addProduct[' ']..
by Anthony Baxter 06 Jul '00

06 Jul '00

Ok, this is driving me slightly nutso. 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. method is owned and executed by a user who is a manager, no wierd permissions, nothing. I get a permission failure trying to look up and access the 'manage_addVocabulary' method. The example of ZCatalog.Vocabulary is simply chosen because it is a standard product that is a) a python product, b) using the "new-style" __init__ method (as opposed to the ancient one). The actual product I'm seeing the problem on is a bit more complex, but Vocab will do. It's been driving me insane for most of this evening - I'm positive you _used_ to be able to do stuff like this, and it works when the product is a ZClass-based one... I've pretty much convinced myself it's a bug in the 2.2 security system... Anyone? Brian? Anthony -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0