- Zope - Zope lists

Add File much slower than FTP, by at least 20 times
by David Elfstrom 20 Aug '02

20 Aug '02

Hi, I did some timing of a 1.5MB PDF file to two installs of Zope, one on a local desktop and one on a remote site over a network. Situation A: Zope 2.5.1/Windows on Windows 2000, locally Browsers: Mozilla & IE6 on Windows Situation B: Zope 2.5.1/Solaris on a remote Solaris 2.6 box over a 10Mbit connection Browsers: Mozilla & IE6 on Windows If I FTP to the zope server on port 8021, I can put the 1.5MB file in Zope very quickly. Situation A: 0.8 seconds (approx) Situation B: 1.5 seconds But if I use the "Add" button from the management interface, using either Mozilla or IE6, it takes the following times: Situation A: 35 seconds Situation B: 2 minutes 30 seconds. Remember, this is only a 1.5MB file, transferred locally! How could we speed up uploads when initiated through the web? Where is the bottleneck occurring -- is it in the HTTP transfer? David --- David Elfstrom, P.Eng elfstrom(a)sten.sunnybrook.utoronto.ca Systems Engineer, Research Computing Sunnybrook & Women's College Health Sciences Centre Rm#S6-20, 2075 Bayview Avenue, Toronto, Canada M4N 3M5 phone: 416-480-6100 x3416 fax: 416-480-5714 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002

2 1

Apache/Zope File Upload Problems
by Chris A. Bruce 20 Aug '02

20 Aug '02

I am hoping that someone knows how to fix this, but I have Apache redirecting to Zope. On large html file uploads, the upload seems to fail. It responds with document not found. I am assuming there is some kind of timeout happening. Does anyone have a suggestion on how to fix this or if there are any specific settings in Apache or Zope that I should have a look at? Thanks, Chris

1 0

Updating Multiple Database Records
by Michael 20 Aug '02

20 Aug '02

Is there a resource that explains how to update multiple ZODB records without have to edit each one individually? I've looked through the how-to's and did a search on Google, but can't seem to turn anything up. Michael

3 3

multiple mysql tables
by Jacob Behm 20 Aug '02

20 Aug '02

Hi, This may be more of a MySQL question than a Zope one. Is there an easy way to create multiple MySQL tables all in one shot without calling an outside shell script or something. >From what I've seen, MySQL can only accept one CREATE statement at a time. But I'd really like to put them all in one file. Thanks, Jacob

3 3

Sharing content between zope instances
by Mark Gibson 20 Aug '02

20 Aug '02

Is there an easy or suggested way of sharing specific content between zope instances? Thanks, Mark

3 2

Discussion Item
by Ashish Gautam 20 Aug '02

20 Aug '02

Hi all, When i have enabled discussion on any content type, then by default all the replies(Discussion Item) are visible to all the users. The replies dont go through a workflow. I want to apply workflow to these replies(discussion items). Any suggestion is most welcome, Ashish.

2 1

Date Time Problem
by zope 20 Aug '02

20 Aug '02

Hi I have been working using Pagetemplates,XML,python script and Postgres sql At times when I use a select statement to select values from a table in zope I get an error on the time variable. The error is : Error, Invalid Date-Time String: 2002-06-08 00:00:00+05 SQL used: select * from calendar order by cuser Traceback (innermost last): File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 114, in publish File /home/zope/Zope-2.5.1/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 98, in publish File /home/zope/Zope-2.5.1/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_test) File /home/zope/Zope-2.5.1/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_test) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 328, in manage_test (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 306, in manage_test (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Shared/DC/ZRDB/DA.py, line 421, in __call__ (Object: zsqll_event) File /home/zope/Zope-2.5.1/lib/python/Products/ZPsycopgDA/db.py, line 205, in query File /home/zope/Zope-2.5.1/lib/python/Products/ZPsycopgDA/DA.py, line 120, in cast_DateTime File /home/zope/Zope-2.5.1/lib/python/DateTime/DateTime.py, line 651, in __init__ File /home/zope/Zope-2.5.1/lib/python/DateTime/DateTime.py, line 1022, in _parse Invalid Date-Time String: (see above) But at other times there is no error thrown .I rectify the error usually by checking the properties of the Database connection and saving the settings again.The error does nopt appear always only at times Couls you please tell me how I can avoid this error from creeping up.Because I have found that at some time or the other this error comes up and so far I have not been able to find a solution. Best Regards John Kunchandy

2 1

RE: [Zope] Uploading a file to a SQL DB
by Stuart Foster 20 Aug '02

20 Aug '02

Here is an example using ASP http://www.aspfree.com/aspnet/uploadimage.aspx Here is an article talking using PHP, http://www.phpbuilder.com/columns/william19990908.php3 I have used this one before. .NET also has a method to do this that works well. -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Tuesday, August 20, 2002 9:31 AM To: Stuart Foster Cc: zope(a)zope.org Subject: Re: [Zope] Uploading a file to a SQL DB How would you do ti with other scripting languages? Chris Stuart Foster wrote: > I am trying to upload a file to a database and store it in an image field. > I am using MS SQL as the server and am able to do it with other scripting > languages but have not been able to figure out how to do it with Zope. > > Does anyone have an example of how to do this? > > TIA > Stuart > > > _______________________________________________ > 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 ) > >

1 0

Uploading a file to a SQL DB
by Stuart Foster 20 Aug '02

20 Aug '02

I am trying to upload a file to a database and store it in an image field. I am using MS SQL as the server and am able to do it with other scripting languages but have not been able to figure out how to do it with Zope. Does anyone have an example of how to do this? TIA Stuart

2 1

Dynamic content in ZPT
by Chetan Kumar 20 Aug '02

20 Aug '02

Hi all I have a form in ZPT which calls a python script which looks up a database to generate some data. Now, the data needs to appear in the same page in a table if the submit button is used. The problem here is to generate the <form method="post" action="GetProjectWiseDataPython"> further down the selection is made as <select name="ProjectName"> <option tal:repeat="options here/GetProjectsPython" tal:content="options/ProjectName">name</option> </select> </form> This is passed to GetProjectWiseDataPython. At the end of the page I need to put a condition "if data obtained from script" show the data obtained from GetProjectWiseDataPython Now, As I understand I need to tal:define="GotData here/GetProjectWiseDataPython" and later tal:content="GotData/Somedata" This is the error message I get while loading the page. *Error Type: TALESError * *Error Value: exceptions.AttributeError on ProjectName in "standard:'here/GetProjectWiseDataPython'", at line 52, column 1* This is not seen when I do not attempt to display the data. What is the way out ? TIA Chetan

4 5