- Zope - Zope lists

something wrong with ZSQL
by Samuele Giovanni Tonon 27 Apr '04

27 Apr '04

hi to all, supposes you have a ZSQL method of this kind select table1.name, table1.lastname, table2.name, table2.lastname from table1, table2 where table1.cod = table2.cod with ZPT to see them on a table i'll use something like this: <span tal:define="l_ppl python:container.SQLquery()"> <span tal:condition="python:len(l_ppl) > 0"> <table class=modifica> <tr tal:repeat="num python:range(0,len(l_ppl.names()))"> <td span=1 tal:content="python:l_ppl.names()[num]"> Name </td> <td> <input type=text tal:attributes="name python:l_ppl.names()[num]; value python:l_ppl[0][num]" > </td> </tr> </table> </span> </span> however this gives an error : An error was encountered while publishing this resource. Error Type: ValueError Error Value: Duplicate column name, name Am i wrong or this is a big problem of ZPT ? Is there a way to force to user absolute name, instead of relatives ? thanks Samuele

4 5

Re: [Zope] Re: Problem with underscore in metatag for ftp
by Jaroslav Lukesh 27 Apr '04

27 Apr '04

Marie Robichon wrote: > At 09:45 27/04/2004 +0200, Jaroslav Lukesh wrote: >> 2. use webdrive at windows and access to your zope data as in network >> drive. >> > > Following your advice, I have installed webdrive and find its great (and > works for Plone2!!!). However it **still** doesn't cure my underscore > problem when uploading Document types. Could it be due to a problem in > the way metatags are recognised in Plones Document.py (naive newbie > question here). This problem is really blocking me from getting my > content into Plone without losing my original data. Did you try to create document named Effective_date via ZMI? If you have created this document, you should update that document via FTP without problems, even in case when creating of that name via FTP is not possible due any reason. Regards, -- Jaroslav Luke -- Tento e-mail nemu*e obsahovat VIRY jeliko nepocházi z virózního systému M$ Windows!

2 1

Please help me ! Postgre DA Field Types
by fowlertrainer＠anonym.hu 27 Apr '04

27 Apr '04

Hello ! I want to continue the my project. http://www.zope.org/Members/fowlertrainer I need to get all of the base field types with postgresql da. http://www.zope.org/Members/spinwing/ZSQL_Results rec = context.retrieve_fields_from_test_table() print "-" * 80 print "Table field names" print "-" * 80 for name in rec.names(): print name print "-" * 80 print "Fields definitions" print "-" * 80 dict = rec.data_dictionary() for key in dict.keys(): print dict[key] Base field types: - char - varchar - int - smallint - bigint - float - decimal - boolean - blob - memo - double prec. - text - date - time - timestamp The fields must be named f*, where * is the type of field. Example: fint, fchar, fmemo. Because I have not postgresql server (windows :-( ), anybody help me to I get the field types ? Example - The MySQL field types: {'name': 'fbool', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fbit', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fdate', 'type': 'd', 'null': 1, 'width': 0} {'name': 'ftime', 'type': 't', 'null': 1, 'width': 0} {'name': 'fdouble', 'type': 'n', 'null': 1, 'width': 0} {'name': 'fyear', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fdatetime', 'type': 'd', 'null': 1, 'width': 0} {'name': 'finteger', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fchar', 'type': 't', 'null': 1, 'width': 0} {'name': 'ftext', 'type': 't', 'null': 1, 'width': 0} {'name': 'fvarchar', 'type': 't', 'null': 1, 'width': 0} {'name': 'fts', 'type': 'd', 'null': 0, 'width': 0} {'name': 'ftinyint', 'type': 'i', 'null': 1, 'width': 0} {'name': 'id', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fblob', 'type': 't', 'null': 1, 'width': 0} {'name': 'fmediumint', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fsmallint', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fnumeric', 'type': 'n', 'null': 1, 'width': 0} {'name': 'fint', 'type': 'i', 'null': 1, 'width': 0} {'name': 'fdecimal', 'type': 'n', 'null': 1, 'width': 0} {'name': 'fbigint', 'type': 'l', 'null': 1, 'width': 0} {'name': 'ffloat', 'type': 'n', 'null': 1, 'width': 0} {'name': 'freal', 'type': 'n', 'null': 1, 'width': 0} Can anybody help me ? Thanx for it. -- Üdv/Kind of Regards: fowlertrainer(a)anonym.hu mailto:fowlertrainer@anonym.hu

1 0

tracing permission settings
by Roy Mathew 27 Apr '04

27 Apr '04

Folks, When configuring a site with various roles and permissions, I often run into the following scenario: I have a user logged in with a somewhat restricted role (eg: Authenticated) that is not allowed access to certain resources, and he gets a login box popup. What I would like is for a way to tell exactly which resource needs the elevated permission, so I can simply go fix it. What techniques are possible here? Is there a debug setting/logging for a "permission denied" resource? Thanks, Roy.

3 4

Zope Web Developer Needed in Pleasanton, CA area
by Chris Bruce 27 Apr '04

27 Apr '04

I hope this is ok for me to post this to this group.... Zope Web Developer Needed in Pleasanton, CA area. Approximately ½ time (will vary) Contract or Employee Some telecommuting allowed Summary: The Sleeter Group is a nationally recognized QuickBooks accounting software seminar provider, specializing in QuickBooks. We are looking to develop a long-term consulting relationship with a professional, energetic, self-motivated Web Technology expert. We are a busy, dynamic and growing company - but we still remember how to have fun while working. The successful candidate will have a positive, professional demeanor, excellent interpersonal skills and will be able to work as a team player. The nature of the work will require that the candidate demonstrate initiative and responsibility and be flexible/adaptive to a fast-paced and fluid business environment. Experience managing multiple projects at once, demonstrating a sense of urgency, and appropriately prioritizing projects are a big plus. Job Description: You will be responsible for the maintenance and development of our Zope 2.7 based Web site. You will also provide various system admin and desktop support functions as needed. The Web site is already built and includes a combination of DTML, ZClass, Python based Zope products and MySql data storage. Ideal candidate will be a problem solver with the drive to implement new ideas and improvements to our Web site as our business dictates. You'll work with the company founders and our technical marketing group to build and implement new projects as well as maintain the existing site. Skills/Requirements: Detail oriented, flexible individual who enjoys working independently while communicating regularly and efficiently with the team. Must have strong organizational and communication skills. 1+ year Zope experience 1+ year Python experience 3+ years web development experience 3+ years SQL database experience MS Office applications Preferred: Microsoft Windows server 2003 Exchange Server Network Router setup and maintenance QuickBooks FileMaker Database Experience managing online forums, shared files, and community building Ecommerce Experience - Yahoo Store or other Email resume to jobs(a)sleeter.com (PLEASE NOTE - NO Email attachments) NO Calls regarding this position will be accepted.

1 0

Conversing With zope - he do not want to talk
by kbond 26 Apr '04

26 Apr '04

Hello, I am trying had to get zope talking thanks to the "zopectl debug" mode but unfortunatly I get the following error message: +++++++++++++++++++++++++++++++++++++++++++ zopectl> debug Starting debugger (the name "app" is bound to the top-level Zope object) /usr/lib/zope/lib/python/Products/CMFWiki/CMFWikiPage.py:28: DeprecationWarning: Non-ASCII character '\xc0' in file /usr/lib/zope/lib/python/Products/CMFWiki/ZWikiRegexes.py on line 5, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from ZWikiRegexes import urlchars, url, urlexp, bracketedexpr,\ Traceback (most recent call last): File "<string>", line 1, in ? File "/usr/lib/python2.3/site-packages/PIL/__init__.py", line 50, in app File "/usr/lib/python2.3/site-packages/PIL/__init__.py", line 46, in startup File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/Zope/App/startup.py", line 54, in startup File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/DBTab/DBTab.py", line 96, in getDatabase File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/DBTab/DBTab.py", line 113, in _createDatabase File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/Zope/Startup/datatypes.py", line 172, in open File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/Zope/Startup/datatypes.py", line 169, in createDB File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/ZODB/config.py", line 97, in open File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/ZODB/config.py", line 128, in open File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/ZODB/FileStorage.py", line 232, in __init__ File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/ZODB/lock_file.py", line 62, in __init__ File "/usr/lib/zope/./build/build-base/python-2.3/build-lib/ZODB/lock_file.py", line 42, in lock_file IOError: [Errno 11] Resource temporarily unavailable +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Does somebody know what could solve this problem? I have already corrected the following pb : http://mail.zope.org/pipermail/zope/2004-February/147022.html I am running a mandrake 10 with the standard RPM for zope (2.7.0rc2-2mdk) and cmf (1.4.2-1mdk) I am quite new to this mailling list please let me know if I am doing something wrong or if you are missing information. Thank for your help

2 1

Question about creating Zope products with database connections.
by Alec Munro 26 Apr '04

26 Apr '04

Hi List, I need to create a zope product that makes use of connections to a MySQL db. I am a rank novice when it comes to the creation of Zope products, so I have no idea what the preferred method is to connect to a database. Are there tutorials about this subject? Or any general advice? Thanks, Alec Munro -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

3 2

sparc64 problems
by Adam 26 Apr '04

26 Apr '04

Is anyone running zope 2.7.0 on a sparc64 machine? I just recently started playing with zope, and on my openbsd 3.5 sparc64 machine I have lots of problems with zope crashing. I'm just wondering if zope is tested on platforms other than x86 at all? Thanks Adam

2 1

RE: [Zope] ZServer stops responding !? Help !?
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 26 Apr '04

26 Apr '04

Chris, Thanks for tips. Here's what I've tried: When the sites looks like it's no longer responding, I connect with the monitor. Running Zope.app() is very slow, sometimes so slow I give up and try again. Once I get that setup, I run: app.Control_Panel.DebugInfo.dbconnections() >From what I gather, not all connections are taken up. I have at least 2 that are free: [{'info': ' (1391)', 'version': '', 'opened': 'Sat Apr 24 15:38:59 2004 (31.63s)'}, {'info': ' (7290)', 'version': '', 'opened': 'Sat Apr 24 15:30:36 2004 (534.16s)'}, {'info': "({'HTTP_ACCEPT': ... I try again a couplle of minutes later and I see: [{'info': ' (1391)', 'version': '', 'opened': 'Sat Apr 24 15:38:59 2004 (181.71s)'}, {'info': ' (7290)', 'version': '', 'opened': 'Sat Apr 24 15:30:36 2004 (684.24s)'}, {'info': "({'HTTP_ACCEPT': ... The 4 other requests (I have 6 threads) are the same, they haven't changed. So I think we can exclude running out of threads/db connections as a source of the problem. The other 4 requests are for various content types. the content types themselves work fine, so I'm going ot take note of which ones they are and see if one keeps recurring or something. Actually 2 of those do backend http calls, could there be some socket/timeout issue ? The call is to a CGI on the very same server though, so I'm confident it's running fine. At this point the monitor stops responding, in the middle of outputting that second list. I hit enter and I get: error: uncaptured python exception, closing channel <__main__.monitor_client connected at 0x400d5c0c> (socket.error:(9, 'Bad file descriptor') [/usr/local/lib/python2.3/asynchat.py|initiate_send|218] [/usr/local/lib/python2.3/asyncore.py|send|337]) I go look at my trace log, and stuff is still appearing in there ... Though nothing gets returned. CPU usage right now is not particularely big ... [zope@tincup log]$ ps auxw | grep Zope zope 31498 0.0 0.2 6484 4576 ? S 15:26 0:00 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/zdaemon/ zope 31499 0.9 8.5 192848 176496 ? S 15:26 0:13 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta zope 31500 0.0 8.5 192848 176496 ? S 15:26 0:00 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta zope 31501 7.0 8.5 192848 176496 ? S 15:26 1:37 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta zope 31502 5.8 8.5 192848 176496 ? S 15:26 1:21 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta zope 31503 4.2 8.5 192848 176496 ? S 15:26 0:58 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta zope 31504 0.5 8.5 192848 176496 ? S 15:26 0:07 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta zope 31505 5.1 8.5 192848 176496 ? S 15:26 1:11 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta zope 31506 1.6 8.5 192848 176496 ? S 15:26 0:22 /usr/local/bin/python2.3 /usr/local/Zope-2.7-Core/lib/python/Zope/Sta I'm going ot go do a requestprofiler now see what comes out ... Thanks again, J.F. -----Original Message----- From: Chris McDonough [mailto:chrism@plope.com] Sent: April 24, 2004 2:15 PM To: Jean-Francois.Doyon(a)CCRS.NRCan.gc.ca Cc: zope(a)zope.org Subject: Re: [Zope] ZServer stops responding !? Help !? On Sat, 2004-04-24 at 13:53, Jean-Francois.Doyon(a)CCRS.NRCan.gc.ca wrote: > G'day, > > I've got a rather bizarre but catastrophic problem. > > ZServer seems to stop responding. Sometimes it does so after days of > running, sometimes after a few seconds or minutes of uptime. > > I know it's ZServer because I can talk to the monitoring port without > problem. That may be a bit of flawed logic, because ZServer also runs the monitor port. > Also, the apache processes just pile up up to the limit allowed, > suggesting the proxying is not getting replies from the downstream > server. > > The strange thing is the cause seems to be occacional, or vary. For > hours on end I can sit there and restart it, and within minutes it stops > responding ... Then suddenly the problem "disappears", I restart it, and > I wait .... and nothing happens, it just keeps running. Nothing else > abnormal is going on the server so far as I can tell, there is very > little memory swapped, and the CPU usage is not abnormally high. It sounds as if Zope is doing something which blocks, consuming all database threads. > I used to have this problem very very rarely in the past, but since I > upgraded to Zope 2.7, it seems to have gotten much worse :( > > I tried accesing the DebugPanel from the monitor, but can't seem to get > it to do anything useful ... I don't know where else to look to find the > cause of this. > > This causes serious uptime problem on our main, high traffic site, which > is Very Bad. > > I'm on RedHat 7.3 (fully patched) > Python 2.3.3 (custom compiled) > Zope 2.7 > CMF 1.4.x (I forget ... the latest!) > Psycopg (Latest also) > And a variety of other products. I'd suggest using the "big M" or "trace" logging features along with the requestprofiler script to find out where the problem might be. - C

3 2

Installing on Apache ISP without server process
by Ian Brockbank 26 Apr '04

26 Apr '04

Hi, I am planning to move to a CMS, and Zope/Plone look like exactly what I am wanting. However, I have hit a snag. All the documentation I can find seems to assume ZServer is running, and that CGI is deprecated. However, my ISP does not allow long-running background processes, so this is not an option for me. Can I still run Zope without a server process? If so, where would I find documentation on how to go about it? (If not, I will have to regretfully say goodbye to Zope and look at other CMSs instead.) My web site only serves of the order of hundreds of pages per day, so performance is not a critical issue. Is there anything I can point my ISP at which would help _them_ install Zope and provide the server process? Thanks in advance, Ian Brockbank ian(a)scottishdance.net webmaster, http://www.scottishdance.net/ and http://www.rscds.org/

4 4