- Zope - Zope lists

uploading from client PC in MySQL thru ZSQL
by Didier Georgieff 04 Jul '00

04 Jul '00

Hello, I'm trying to "import" a CSV text file for feeding a MySQL database. I have : * DTML method including : <form method="post" action="import" enctype="multipart/form- data"> <input type="file" name="loadFileAnnu"> <input type="submit" value="Import File in MySQL"> </form> * ZSQL method 'import' parameter : loadFileAnnu query template : LOAD DATA LOCAL INFILE '<dtml-var loadFileAnnu>' INTO TABLE annuaire FIELDS TERMINATED BY ';' when i process the form, i always get the import/manage_testForm and if i try to upload the (local on my PC) file thru this, i get an MySQL error Error, _mysql.InterfaceError: (0, "File 'D:/AnnuaireTest.csv' not found (Errcode: 2)") SQL used: LOAD DATA LOCAL INFILE 'D:/Data/SIT67/AnnuaireTest.csv' INTO TABLE annuaire FIELDS TERMINATED BY ';' Am i doing something wrong or is it impossible to load/import in MySQL from the local file (so i should upload the file on the server then load into MySQL) ?? Thanks in advance for any tip or info. -- Didier Georgieff DDAF du Bas-Rhin - Cellule SIG 2, rue des Mineurs 67070 Strasbourg Cedex tél : 03.88.25.20.33 - fax : 03.88.25.20.01 email : didier.georgieff(a)agriculture.gouv.fr GéoWeb http://10.67.90.3 (Intranet Agriculture) GéoWeb http://sertit10.u-strasbg.fr (Internet)

2 1

NOTICE: issue with database packing in current Zope releases
by Brian Lloyd 04 Jul '00

04 Jul '00

Hi all, Jim found a problem with the algorithm for packing the Zope database that we wanted to announce so that folks can avoid being bitten by it until the fix is out (in b4). The gist of it is that you should not pack your database to a given time and then subsequently pack the database to an *earlier* time. For example, do not pack to "older than 0 days" and then pack to "older than 10 days". The algorithm in the current Zope releases doesn't handle this correctly and depending on the exact circumstances can end up getting rid of objects that it shouldn't in the packed version of the database. Note that if you _are_ inadvertantly bitten by this, you can recover by using the Data.fs.old in the /var directory that is created at pack time. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

2 1

XMLDocument appendChild
by Olivier Deckmyn 04 Jul '00

04 Jul '00

Hi, I use XMLDocument the following dtml method (editUseCaseTitle): <dtml-let doc="getOwnerDocument()" title_node="doc.createElement('title')" title_text="doc.createTextNode(title)"> <dtml-call "title_node.appendChild(title_text)"> <dtml-call "getParentNode().replaceChild(title_node, this())"> </dtml-let> applied on an XML Node http://zion:8080/UseCases/cases/cases_lines/xml_db/e2914/e2964/editUseCaseTi tle where : - xml_db is my XML Document - editUseCaseTitle is in the 'cases' folder When running I have the following error : Zope Error Zope has encountered an error while publishing this resource. Unauthorized You are not authorized to access appendChild. 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/ZPublisher/Publish.py, line 165, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: editUseCaseTitle) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: editUseCaseTitle) File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: editUseCaseTitle) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: editUseCaseTitle) File /usr/local/zope/lib/python/DocumentTemplate/DT_Let.py, line 145, in render (Object: doc="getOwnerDocument()" title_node="doc.createElement('title')" title_text="doc.createTextNode(title)") File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: title_node.appendChild(title_text)) (Info: title_text) File <string>, line 0, in ? File /usr/local/zope/lib/python/DocumentTemplate/DT_Util.py, line 140, in careful_getattr Unauthorized: (see above) Current user is manager for everything...(me !) I use Zope version: Zope 2.1.6 (source release, python 1.5.2, linux2) Python version: 1.5.2 (#2, May 18 2000, 10:00:10) [GCC 2.95.2 19991024 (release)] System Platform: freebsd4 XMLDocument (XML Document 1.0a6) What is wrong ? :( Regards, Olivier.

1 0

MySQL Select Statements
by Michael Blewett 04 Jul '00

04 Jul '00

Hi Everyone, Just need someone to put me straight here. When I use Select statements in an SQL Method I cannot simply : Select Column1, Column2 etc from TableA. Instead I must use the AS statement ie Select Column1 AS Column1, Column2 AS Column2 from TableA. Is this just an oddity with the MySQLDA/Db adapters or am I overlooking something blatantly obvious here? All the examples on zope.org don't have the extra "AS Column1" additions on them and I was wondering if this is a Zope/mySQL-unique thing. I'm using Zope (2.1.6) with MySQL (3.22.32) with Zope MySQL Database Adapter (ZMySQLDA) 2.0.0a1 and MySQLdb module release: 0.2.2 . Could someone please let me know as I don't want to have to type the extra bits on all my SQL statements from here on in if I don't need to (I am the world's worst and laziest typist). If it is the case that it's a necessary evil, then I want to put a HowTo or Tip up on zope.org because it took me a while to figure out what I was doing wrong, and if I can save someone else that same wasted time then I would like to. However I wanted to get my facts straight (via all you experts) first. Thanks for any help... - Michael ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Michael Blewett Computer Support Mgr - Biological Sciences Monash University (Clayton Campus) Victoria Australia 3168 " Can I trade this job for what's behind door #2? "

6 16

Inheriting CatalogAware?
by Nils Jeppe 04 Jul '00

04 Jul '00

Hi, I have one question. I have a Class, say, BaseClass which is a subclass of CatalogAware and ObjectManager (in that order). I have a second class which is a subclass of BlaseClass. SecondClass should be fully CatalogAware, yes? Just have to know because if it is, my error lies elsewhere..... ;-) Thanks in advance, Nils

1 0

Bizarre crashes under Solaris: "nobody" vs. a real user (a fix?)
by Walter A. Aprile 04 Jul '00

04 Jul '00

Hi, in the past days I have been experiencing mysterious crashes, under heavy load conditions with Zope version: Zope 2.1.6 (binary release, python 1.5.2, solaris-2.6-sparc) Python version: 1.5.2 (#8, Nov 16 1999, 10:05:41) [GCC 2.8.1] System Platform: sunos5 Since that was the sensible choice, I was running Zope as user "nobody". Completely by chance, I run it as a 'normal' user (neither root, nor nobody). I was surprised to realize that it would not crash any more, no matter how much I pounded it with wget and similar tools. I was running it from a terminal, where every now and then interesting messages pop up: ------ 2000-06-30T22:33:44 PROBLEM(100) ZServer warning: server accept() threw EWOULDBLOCK ------ 2000-07-01T07:58:31 PROBLEM(100) ZServer Server accept() threw an exception ------ 2000-07-03T03:59:43 ERROR(200) ZServer uncaptured python exception, closing channel <zhtt p_channel connected 132.248.10.194:1073 at 70e4d8 channel#: 15840 requests:13> (socket.er ror:(9, 'Bad file number') [/usr/local/zope/ZServer/medusa/asynchat.py|initiate_send|211] [/usr/local/zope/ZServer/medusa/http_server.py|send|400] [/usr/local/zope/ZServer/medusa /asyncore.py|send|237]) ------ 2000-07-03T14:50:34 ERROR(200) ZServer Bad HTTP request: GET /Zorba/logo-solo.gif >logo-s olo.gif ------ 2000-07-03T18:43:50 ERROR(200) ZServer uncaptured python exception, closing channel <zhtt p_channel connected 200.15.155.65:3719 at 66da40 channel#: 22958 requests:1> (socket.erro r:(9, 'Bad file number') [/usr/local/zope/ZServer/medusa/asynchat.py|initiate_send|211] [ /usr/local/zope/ZServer/medusa/http_server.py|send|400] [/usr/local/zope/ZServer/medusa/a syncore.py|send|237]) Could be that, when running as nobody, Zope could not do something that it has do after an exception ? It could be something as simple as writing to /tmp or logging things with syslogd ... anyway, it could be something that Solaris prevents it from doing, which in turn causes the crashes. Now, I am still keeping my fingers crossed for tomorrow I have a demo. So, apologies if all this is old hat, and thanks for the wonderful list environment. Walter -- Vita brevis, ars longa, occasio celeris, experimentum periculosum, judicium difficile. Attention: Un train peut en cacher un autre -><- Eris aprueba este email ! -><- http://redescolar.ilce.edu.mx

1 0

RE: [Zope] How do say wiki?
by Brian Lloyd 04 Jul '00

04 Jul '00

> What would be an acceptible plural form of wiki, > wikies > wikis > what? wikii? :) -Brian

1 0

Re: [Zope] Is there a better way to code this?
by Dieter Maurer 04 Jul '00

04 Jul '00

Luke Tymowski writes: > To have Zope ignore the footer code in one place but still display footer > code on other pages, I've resorted to this: > <dtml-with history> > <dtml-with 2000> > <dtml-in "objectValues(['DTML Document'])" size=3 sort=title reverse> > <dtml-call "REQUEST.set('renderedfooter',1)"> > <dtml-var sequence-item> > <a href="/history/2000/<dtml-var id>" title="Permanent link to the > entry for <dtml-var title>">PermaLink</a> > <br> <br> > </dtml-in> > </dtml-with> > </dtml-with> > <dtml-call "REQUEST.set('renderedfooter',0)"> What about <dtml-with "_.namespace(standard_html_header='', standard_html_footer='')"> ... your code without "REQUEST" mangling ... </dtml-with> This redefines "standard_html_header/footer" inside the "with". Should work for DTML methods/documents. Dieter

2 1

Re: Confera problem
by Jon Franz 04 Jul '00

04 Jul '00

this is due to confera using a old, now non-standard package called ts_regex. Goto http://www.zope.org/Members/Coventry/Confera_fix for a fix. >I just downloaded Confera-1.2.0-nonbin.tgz, installed it, and created a >Confera topic instance. I posted a mesage to the topic, and then >posted a reply to this messge. This is what i get: > >Traceback (innermost last): > File /home/tejay/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line >214, in publish_module > File /home/tejay/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line >179, in publish > File /home/tejay/Zope-2.1.6-src/lib/python/Zope/__init__.py, line 202, >in zpublisher_exception_hook > File /home/tejay/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line >165, in publish > File /home/tejay/Zope-2.1.6-src/lib/python/ZPublisher/mapply.py, line >160, in mapply > (Object: addMessage) > File /home/tejay/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line >102, in call_object > (Object: addMessage) > File lib/python/Products/Confera/Confera.py, line 565, in addMessage > File /var/tmp/python-root/usr/lib/python1.5/regsub.py, line 38, in >gsub >AttributeError: (see above) > >Has any one had this problem? I don't really have time to go hunting >for the problem at the moment. > >I am running a Zope 2.1.6 from src on RH linux 6.2. > >terry

1 0

basic FSSession question
by Leichtman, David J 03 Jul '00

03 Jul '00

I'm probably missing something really key here, but I'm having difficulty doing multiple sessions in FSSession. I have a session and then, say, take some form data and push it to the session. If I'm on a different machine (different cookie / different SessionUID), and I get different form data and write it, it then overwrites the other data, implying that it's the same SessionUID. I thought that calling <dtml-call FSSession> from a different machine, would then create a new session with the SessionUID stored on that machine. How, then, do I get multiple sessions? There seems to be a severe lack of documentation for FSSession. ~ Astrogeek

2 1