- Zope - Zope lists

dtml-tree very slow
by Florian Schuler 06 Nov '01

06 Nov '01

Hello everybody, I´m using the dtml-tree to generate a mailinglist tree out of a postgres database. Is it possible that it takes nearly one second per tree entry to display ? Is there a trick to increase speed ? I´m using Zope 2.3.2 and Postgres 7.1 with psycopg 0.96 Thaks in advance Florian Schuler

1 0

RE: [Zope] MySQL Admin Tool Recommendations
by Pieter Claerhout 06 Nov '01

06 Nov '01

For Windows, I always use MySQL-Front. You can find it at: http://www.anse.de/mysqlfront/ <http://www.anse.de/mysqlfront/> . Cheers, Pieter -----Original Message----- From: Tim Owen [mailto:timowen@voyager.net] Sent: Tuesday, November 06, 2001 11:19 AM To: zope(a)zope.org Subject: [Zope] MySQL Admin Tool Recommendations Anyone have a recommendation as to what the best Windows admin tool for MySQL databases for use with Zope is? I looked at the Windows admin tool that comes with MySQL but it does not create tables, etc. I also looked at MySQLGUI and it looked weak as well. I would rather not have to run MyPHPAdmin since I am running Zope not PHP. I would be interested in the same for Linux (SuSE 7.2). Thanks in advance.

3 3

(no subject)
by prabu 06 Nov '01

06 Nov '01

How do I access a ZSQL method in a python script? Prabu _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

2 1

MySQL Admin Tool Recommendations
by Tim Owen 06 Nov '01

06 Nov '01

Anyone have a recommendation as to what the best Windows admin tool for MySQL databases for use with Zope is? I looked at the Windows admin tool that comes with MySQL but it does not create tables, etc. I also looked at MySQLGUI and it looked weak as well. I would rather not have to run MyPHPAdmin since I am running Zope not PHP. I would be interested in the same for Linux (SuSE 7.2). Thanks in advance.

2 1

My never-ending aquisition problem (calling ZSQL from PythonScript)
by Tom Smith 06 Nov '01

06 Nov '01

I'm having severe problems calling a ZSQL query from a Script from a form. MyFolder create_article_sql(params) (ZSQLMethod) create (PythonScript) MySubFolder get_article_form (DTMLMethod) In "create_article_sql" I create a record then select that record to return. In "get_article_form" I have <form action="create" ... etc (This should resolve to "/MyFolder/MySubFolder/create" shouldn't it?) In "create" I have... results = context.create_article_sql(params) return results But all I ever get is a Not Found error. I don't get a Not Found error if in "create" I just return 1.... So the "create" script is not finding the "create_article_sql" ZSQL Method, even though it is in the same folder (though being called from a sub-folder) Can anyone help please? ta tom -- tom smith | tom(a)othermedia.com http://www.othermedia.com/blog 3rd Floor, The Pavilion, Newhams Row, London, SE1 3UZ 0207 089 5959

1 1

Upgrading a product.
by Jason C. Leach 06 Nov '01

06 Nov '01

hi, If i install and run Product X version 1.2.3, then a month later install version 1.2.4 of the product what happens to: 1. My existing objects? Does there code get upgraded, or do they keep the old code. 2. My modifications? If I change a DTML in the created object, will the upgrade overwrite it? Anythin else I should be asking? Thanks, j. -- ...................... ..... Jason C. Leach .. PGP/GPG Public key at http://www.keyserver.net/ Key ID: 157BD48C

2 1

INSTANCE_HOME - where are my Products???
by Paul Winkler 06 Nov '01

06 Nov '01

I've just switched to using an $INSTANCE_HOME, following the HOWTO at Two problems: 1) The HOWTO needs to be updated for Zope 2.4.x - you can't use PYTHONHOME as an environment variable anymore, Python reserves that for its own purposes. No big deal, I just call it ZHOME instead. 2) I moved my Products from lib/python/Products to $INSTANCE_HOME/Products. Now when I start Zope, all my products show up in the Products management page and appear to be OK, but all existing instances are broken, and my Products don't show up in the "Select type to add..." list. Log shows nothing unusual until I visit a directory containing one of these products, then I get this: 2001-11-05T20:24:49 PROBLEM(100) ZODB Could not import class 'ZopeHolCategories' from module 'Products.ZopeHolCategories.ZopeHolCategories' ------ 2001-11-05T20:24:49 PROBLEM(100) ZODB Could not import class 'ZopeCalOrder' from module 'Products.ZopeCalOrder.ZopeCalOrder' But everything's there ... for example: $ cd $INSTANCE_HOME/Products $ ls ZopeCalOrder/ cal_icon.png __init__.py refresh.txt ZopeCalOrder.py index.zpt README.txt ZopeCalOrderAdd.zpt I'm running Zope 2.4.2, python 2.1.1 on linux. -- paul winkler home: http://www.slinkp.com music: http://www.reacharms.com calendars: http://www.calendargalaxy.com

1 1

exUserFolder error:NETBIOStimout
by Erik Myllymaki 06 Nov '01

06 Nov '01

Using the latest exUserFolder on Winnt 4.0 w/zope-2.3.2. When setting up the product for the first time I get a NETBIOSTimeout error in nmb.py. I am using the appropriate servername and have tried IP as well. Any ideas? Thanks, Erik Myllymaki erik(a)pacific-shores.com

1 0

Re: [Zope] Re: minor bug CoreSessions - patch
by Frank Tegtmeyer 06 Nov '01

06 Nov '01

Frank Tegtmeyer <fte(a)lightwerk.com> writes: Answering myself: > So it seems that validator.w3.org is broken in this aspect? It's a FAQ answered in http://www.htmlhelp.com/tools/validator/problems.html#amp So my patch would be the right thing. Regards, Frank -- CTO Lightwerk GmbH Email: fte(a)Lightwerk.com Phone: +49 2434 800781 Fax: +49 2434 800794 An der Kull 11 * 41844 Wegberg * Germany

3 2

Those Eternal Zope Errors that noone seem to know how to avoid - Why do they happen?
by Dario Lopez-Kästen 05 Nov '01

05 Nov '01

Hello! Can someone explain this to me: Zope 2.4.1 SunOS 5.8 Generic_108528-05 sun4u sparc Python 2.1.1 --without-pymalloc DCO2 latest from release TransparentFolders 0.3.2 Oracle 8.1.7 We keep getting these errors: ------ 2001-11-05T21:07:10 INFO(0) Z2 CONFLICT Competing writes at, /ka/acl_users/manage_edit Traceback (innermost last): File /usr/local/zope/dist/Zope-2.4.1/lib/python/ZPublisher/Publish.py, line 175, in publish File /usr/local/zope/dist/Zope-2.4.1/lib/python/Zope/__init__.py, line 240, in commit File /usr/local/zope/dist/Zope-2.4.1/lib/python/ZODB/Transaction.py, line 302, in commit File /usr/local/zope/dist/Zope-2.4.1/lib/python/ZODB/Connection.py, line 324, in commit ConflictError: '\x00\x00\x00\x00\x00\x006\xc7' ------ 2001-11-05T18:57:51 PROBLEM(100) ZServer unhandled connect event + a bunch of asyncore.py related errors The question - are we the only one experiencingthese errors or is anyone else having them? And what to do to avoid them? /dario - -------------------------------------------------------------------- Dario Lopez-Kästen Systems Developer Chalmers Univ. of Technology dario(a)ita.chalmers.se ICQ will yield no hits IT Systems & Services

3 3