June 2000 - Zope - Zope lists

Re: [Zope] Re: FSSession newbie problem
by Hung Jung Lu 12 Jun '00

12 Jun '00

>From: Pavlos Christoforou <pavlos(a)gaaros.com> >On Fri, 9 Jun 2000, Marcello Lupo wrote: > > 1) Is necessary to call FSSession in every document of the site Yes it >is neccessary beacuse HTTP is stateless. It will only start a new >session if FSSession cannot find a valid UID either through a cookie or a >FORM or as part of te URL Pavlos: this is the part that is confusing to newbies. FSSession can be made in such a way that this initial call can be avoided. HappySession works that way: no need for explicit initialization. Matter of fact, in the very first call to the HappySession (any dictionary method), it does the initialization itself behind the scene. FSSession can do the same thing. It's a minor detail, but anything to make a newbie's life easier is worth it. :) regards, Hung Jung ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

3 2

ZOracle connection trouble
by Bak ＠ kedai 12 Jun '00

12 Jun '00

hullo everybody, i want to access data on oracle server that resides on a remote machine. i've installed oracle 8i(client side only) for linux on a redhat6.2 and managed to compile ZOracleDA with no problems. i can connect ok from sqlplus and the test script that comes with ZOracleDA can import and connect to the remote database server OK. however, i can't create a ZOracleDA connection. what's the connection string? i've tried user/passwd@myora_SID - this barfed out connection "Invalid connection string: emedia/emedia123@nstdb" user/passwd crashed zope. i think my environment is all set since i can connect from sqlplus and the ZOracleDA test script runs ok. what more should look at? pointers/docs accepted. p/s - i'm a Oracle newbie and not the DBA for the server that i want to access. i d/l DCOracleDA, compiled it, ran the test script successfully and stopped at that since i'm not quite sure what to do next thanks -- ------------------------------------------------------ http://www.kedai.com.my/kk Am I Evil?

2 1

Re: [Zope] error (200)
by Martijn Pieters 12 Jun '00

12 Jun '00

So, Tranalyzer says nothing is wrong, but you do get a load state error. Next thing you could try is truncate the Data.fs to the point where things started going wrong. Tranalyzer will tell you for example at which point your Products were installed. If I read things right, the value after the @ of that record is the byte offset of that record in Data.fs. You can now use split to truncate Data.fs to that point. Make sure you then test Data.fs on a Zope install _without_ the offending Products! You can use this technique to further and further back in time to the point that things are still sane. On Sat, Jun 10, 2000 at 11:00:51PM -0700, Mike Mikkelsen wrote: > tranalyzer says nothing is wrong... > the recovery howto says reinstall... > > back to plan A... re-install everything and pray... >8-( > > thank you for your response. > > > On Sat, 10 Jun 2000, you wrote: > > On Sat, Jun 10, 2000 at 09:47:54AM -0700, Mike Mikkelsen wrote: > > > My Zope (2.1.6) installation has just become *very* unstable. My most recent > > > addition has been ZPatterns and LoginManager. My passwords for my virtual > > > sites (using SiteRoot) are no longer accessable by my account and superuser > > > can't access them. The site "disappears" three or four times a day without > > > errors. And clicking on Product Management link sometimes returns "No Data" > > > notice in the browser and then Zope crashes. > > > > > > This is the error that shows up on the console when going to Product Management > > > or accessing the subdir that holds the subdir that has LoginManager: > > > > > > <date> ERROR (200) ZODB Couldn't Load State for > > > '\000\000\000\000\000\000\002\017' > > > > > > > > > I'm exporting the sites now and am going to (I guess) re-install zope and all > > > of the products. >8-/ > > > > > > Are there any other options? > > > Any ideas on what went wrong? > > > Is their a way to fix a corruption in the ZODB? > > > > Have a look at Ty Sarna's Tranalyzer: > > > > http://www.zope.org/Members/tsarna/Tranalyzer > > > > which can tell you where your Data.fs is in trouble. You then can try and > > repair your Data.fs file by truncating the file at the point of corruption. > > For more details see the Disaster Recovery + Avoidance How-To at: > > > > http://www.zope.org/Members/vernier/recovery -- Martijn Pieters | Software Engineer mailto:mj@digicool.com | Digital Creations http://www.digicool.com/ | Creators of Zope http://www.zope.org/ | The Open Source Web Application Server ---------------------------------------------

2 1

ZSQL method broken on 2.1.6
by Umesh Soni 11 Jun '00

11 Jun '00

(using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1) Hi there, I had this ZSQL method (simplified for clarity) working on 2.1.4 select id, nickname from bboard where id<=50 order by id desc limit 30 Now, I've upgraded to 2.1.6 and I get the following error; Error, _mysql.OperationalError: (1064, "You have an error in your SQL syntax near 'LIMIT 1000' at line 4") -this is wierd because my ZSQL method says "limit 30" The traceback displayed is; Traceback (innermost last): File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/Zope/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: simple-test) File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_test) File /usr/local/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 331, in manage_test (Object: simple-test) File /usr/local/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 312, in manage_test (Object: simple-test) File /usr/local/Zope/lib/python/Shared/DC/ZRDB/DA.py, line 430, in __call__ (Object: simple-test) File /usr/local/Zope/lib/python/Products/ZMySQLDA/db.py, line 221, in query OperationalError: (see above) Note: if I remove the limit constraint as in; select id, nickname from bboard where id<=50 order by id desc the ZSQL method works fine. I do need to limit the number of results returned. Does anyone know a workaround for this? umesh

4 4

Re: [Zope] error (200)
by Dieter Maurer 11 Jun '00

11 Jun '00

Mike Mikkelsen writes: > Hello all, > > My Zope (2.1.6) installation has just become *very* unstable. My most recent > addition has been ZPatterns and LoginManager. My passwords for my virtual > sites (using SiteRoot) are no longer accessable by my account and superuser > can't access them. The site "disappears" three or four times a day without > errors. And clicking on Product Management link sometimes returns "No Data" > notice in the browser and then Zope crashes. > > This is the error that shows up on the console when going to Product Management > or accessing the subdir that holds the subdir that has LoginManager: > > <date> ERROR (200) ZODB Couldn't Load State for > '\000\000\000\000\000\000\002\017' The error means that Zope could not unpickle the object with the given object id. I, once, had this problem. I had changed (deleted?) a class in one of my products. An object in the ZODB referenced this class, unpickling failed. The problem disappeared after restoring the old state. I, now, delete objects in Zope before I delete classes in a project that is required by the objects. Dieter

1 0

Re: [Zope] Referencing sql field in a direct traversal
by Dieter Maurer 11 Jun '00

11 Jun '00

Jones, David H writes: > I have set up a direct traversal sqlMethod which has as a DTML method > > The zsql method, sqlModel, is: > > select * > from AP_MDL > where <dtml-sqltest ap_mdl_no type=string> > > The direct traversal url is: > > http://e9999.rt.cs.boeing.com:8080/DB/sqlModel/777/asMeta > > The first DTML method I wrote, asMeta, operated correctly with the following code: > > <meta name="ap_mdl_no" content="<dtml-var ap_mdl_no>"> > <meta name="ap_mdl_cd" content="<dtml-var ap_mdl_cd>"> > <meta name="bus_no" content="<dtml-var bus_no>"> > <meta name="ap_mdl_prod_ind" content="<dtml-var ap_mdl_prod_ind>"> > > Now I want to generalized the DTML method to work with any query. I would like to reference the fields, but haven't figured out how to. Can someone tell me how to reference the fields and field names returned in a direct traversal. The easiest way is to use a "brain" for your database records and let one of its methods return the list of field names. The information is contained in the attribute "__record_schema__" (inaccessable from DTML!). "__record_schema__" is a dictionary mapping field names to field indices (starting from 0). Alternatively, you can use an external method, that accesses "__record_schema__" for you and makes is accessable from DTML. Dieter

1 0

ANN: InterbaseStorage alpha release
by Chris McDonough 11 Jun '00

11 Jun '00

Hi, The alpha release of a Zope storage that uses the Interbase relational database to store object database information is available at http://www.zope.org/Members/mcdonc/RS/InterbaseStorage. It's a full-featured storage. Guinea pigs^H^H^H^H^H^H^H^H^H^H^H Testers wanted. -- Chris

1 0

document in-place editing with zope
by Joachim Müller 11 Jun '00

11 Jun '00

Hi all. I am looking for a solution to do in-place editing of HTML content in connection with ZOPE. It should be able to handle the following tasks: - text editing - text layout editing - insert of pictures - definition of links If you know a product that can handle this, please mail me!!!! Also I would be interested in a solution to edit HTML like Dreamweaver/Frontpage/etc. And have the control if the user can/cannot change the layout of the page or is allowed to change the content (text, pictures) only. I would be glad if you can help me. Thanks in advance. - joachim müller ____________________________________________ joachim müller joachim(a)wemove.com tel +49-69-759003-11 wemove digital solutions contact(a)wemove.com tel +49-69-759003-0 fax +49-69-759003-22 wittelbacher allee 63 60385 frankfurt germany http://www.wemove.com/

1 0

Re: [Zope] ZSQL method broken on 2.1.6
by Dieter Maurer 11 Jun '00

11 Jun '00

Andreas writes: > ZSQLMethod's "advanced" property 'Maximum number of rows retrieved' > makes no sense to me. It prevents stupid queries to kill Zope. Assume, such a query returns 100.000.000 records. This probably will let Zope require several GB memory. > As I know so far there is no way to disable this property or to set a > value like 'maximum' What about a value of 2.000.000.000. Should be enough for most purposes. Dieter

1 0

closed Portal
by Graham Chiu 11 Jun '00

11 Jun '00

I just downloaded and installed the latest checkout from the PTK for the first time. It seems that if I want to have a closed Portal, I can't use Zope's authentication mechanisms to allow users into the folder that contains the Portal as the Portal then complains that the user has already been authenticated outside the Portal. Is that correct? -- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.co.nz/index.php Powered by Interbase and Zope

2 1