- Zope - Zope lists

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

Re: [Zope] Traversable DTML methods
by Anthony Baxter 11 Jun '00

11 Jun '00

Use a pythonmethod with the traverse_subpath argument... Anthony >>> "Ian Sparks" wrote > It seems strange to me that SQLMethods are traversable out of the box and > "normal" DTML methods are not. > > It seems to me that traversable DTML methods would be useful (to me this > means DTML Methods with parameters). > > Is this something that might make it into Zope in the future or am I missing > something important which means that they simply arn't necessary? > > - Ian Sparks. > > > _______________________________________________ > 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 ) > -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

3 2

[offtopic] Job request
by Petru Paler 11 Jun '00

11 Jun '00

Hello all and excuse me for the off-topic, I'm looking for a Zope/Python related job. Since I'm so offtopic I'm not pasting my resume here but refer you to http://www.brainbench.com/transcript.jsp?pid=45513 and mention that I have 1.5 years experience with Zope. I'm learning very fast, as long as the things I learn don't mean that my job is shifting to PHP, Perl or such other nasties :) For more details, please contact me in private. Thanks, -Petru PS: a Zope job board would be really useful (hint, hint :)

1 0