- Zope - Zope lists

RE: [Zope] SyBaseDA and select count problem
by Rob Page 08 Jan '00

08 Jan '00

> It seems that whenever I try to use any of the following: > select count(*) from <tablename> > select count(<columnname>) from <tablename> > > it returns: > "Error, exceptions.ValueError: Empty column name, " > > Of course, the sql is tested and known to work. > > Any clues here? try SELECT COUNT(column) AS some_number FROM tablename --Rob

2 1

using zope for broadcast e-mail messages...
by chas 08 Jan '00

08 Jan '00

Zope's dtml-sendmail tag is excellent - it makes sending e-mail a breeze. It reminds me of a similar tag that Cold Fusion added and which I've noticed many sites use for sending out customized newsletters (the "Allaire ColdFusion Application Server" header being the giveaway). Now, doing the same in Zope, I can loop over the user profiles in our database to extract name, e-mail, and even customize the content of the newsletter as follows : <dtml-in ZSQL_Select_User_Profiles>  To: <dtml-var firstname> <<dtml-var email>> From: robot <robot(a)ourdomain.com> Subject: <dtml-var random_inanity> Dear <dtml-var firstname>, blah blah content (also dependent on his/her likes/preferences)  </dtml-in> Nothing groundbreaking so far. But the question then is : how is this going to work if the user database numbers 200,000+ ? It will take almost half a day to complete and this can't be done in one form-submission or page load ! At the moment, I use Python scripts to do the above using a special Reply-to address and a From field so that bounces are kept. Also, messages are delayed by just long enough (0.2 secs) so as not to overload my mailserver. But it would be nice to move this to Zope somehow. Or is it asking too much ? Yes, I know that there are mailing list software like ezmlm (for Qmail), majordomo and listserv. But I'm looking to customize the e-mail headers, and content so that it appears as personalized as possible, which those apps don't do. Perhaps I'll go off and see if mailman can be hacked to do the above, at least it's written in Python. Thoughts welcomed. chas

1 0

Cut-Copy-Paste bug in Zope2.1.2 ?
by Shalabh Chaturvedi 08 Jan '00

08 Jan '00

Hello: The copy/cut/paste functionality doesn't seem to work here. I'm on Zope 2.1.2. When I check any item and click copy, the paste button appears. When I change the folder, the paste button's gone! If in the same folder I click paste, I get "No clipboard data found". When I check any item and click cut, the item's still shows up. Paste behaves the same way as above. Traceback for error "No clipboard data found" follows: Traceback (innermost last): File N:\PROGRA~1\Zope21\lib\python\ZPublisher\Publish.py, line 214, in publish_module File N:\PROGRA~1\Zope21\lib\python\ZPublisher\Publish.py, line 179, in publish File N:\PROGRA~1\Zope21\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File N:\PROGRA~1\Zope21\lib\python\ZPublisher\Publish.py, line 165, in publish File N:\PROGRA~1\Zope21\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_pasteObjects) File N:\PROGRA~1\Zope21\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_pasteObjects) File N:\PROGRA~1\Zope21\lib\python\OFS\CopySupport.py, line 186, in manage_pasteObjects (Object: ApplicationDefaultPermissions) Copy Error: (see above) Anyone else seen this? Thanks, Shalabh

1 0

Security fix for 2.0
by Andrew M. Kuchling 08 Jan '00

08 Jan '00

Has there been any progress on producing a patch for the recent security issue for Zope 2.0? -- A.M. Kuchling http://starship.python.net/crew/amk/ I am afraid of the worst, but I am not sure what that is. -- Abraham Rotstein

2 1

Re: [Zope] SyBaseDA and select count problem
by Anthony Baxter 08 Jan '00

08 Jan '00

>>> Bill Anderson wrote > It seems that whenever I try to use any of the following: > select count(*) from <tablename> > select count(<columnname>) from <tablename> > it returns: > "Error, exceptions.ValueError: Empty column name, " > > Of course, the sql is tested and known to work. select count(*) as cnt from <tablename> Anthony -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

Re: [Zope] Testing products outside of zope (i.e., in python inte rpreter)?
by Joe Grace 07 Jan '00

07 Jan '00

Michel (& Andrey), it works! Thank you very much. Awesome. Now I see how Zope is loaded: through a package (directory and __init__). Cool. Yes, Michel, what you suggest is what I'm really looking for (and even better than I hoped). Thank you for the clear explanation. I looked back at Andrey and can understand more of what he's doing (but I'll take baby steps for now). Getting zope running on the prompt is what I needed. I'll write up the how-to and post as soon as I can (I hope this weekend...). Thanks again, = Joe = "michel(a)digicool.com" wrote: > > >> -----Original Message----- > >> From: Joe Grace [mailto:Occam@Wizards.com] > >> Sent: Thursday, January 06, 2000 6:32 PM > >> To: zope(a)zope.org > >> Cc: occam(a)serv.net > >> Subject: [Zope] Testing products outside of zope (i.e., in python > >> interpreter)? > >> > >> > >> Hi, > >> > >> is there a way to test zope products outside of zope? > > If your code is not Zope depenent, you can. If your code it, you can > use the Zope debugger (based on the Python debugger) but at that point > you are not 'outside of Zope', you are just not accessing it through the > web, but via a debugger prompt. > > >> I find that I'm > >> restarting zope just to update my product and test it, and that seems > >> painfully slow. I'd like to just run code outside of zope > >> interactively > >> in a shell. Is that possible? > > Yes. > > >> I'm trying with Boring product (super > >> simple) and tripping over the Persistence import > >> > >> Import Error: cannot import name Persistent > >> > >> I've run into this problem before and assume that Persistent is a C > >> function. > > It is an ExtensionClass written in C, yes. To get around this you need > to 'import Zope'. > > >> How do I make it available to my python interpreter? I > >> couldn't figure out where z2.py gets it, but I also am just > >> dealing with > >> the python environment for the first time. I'm using Xemacs > >> (on NT) if > >> that makes giving some tips any easier. :-) > > Yep. Open a shell buffer in your lib/python directory. In my Zope, I > have an object in the top level folder called 'Catalog', which is a > ZCatalog object. > > [michel@korak python]$ python1.5.2 > Python 1.5.2 (#1, Jul 5 1999, 14:47:37) [GCC egcs-2.91.66 > 19990314/Linux (egcs- on linux2 > Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam > Py$ import Zope, ZPublisher > Py$ root_folder = Zope.app() > Py$ root_folder.Catalog > <ZCatalog instance at 84f77c0> > Py$ root_folder.Catalog() > [] > Py$ > > -Michel

1 0

A Large Favor from the Community, PLEASE! :-)
by Hadar Pedhazur 07 Jan '00

07 Jan '00

Hi all! I would like to ask a favor of the community. Yesterday, I met with a potential customer of Digital Creations. They run a very heavily trafficked site on the net. They are interested in a very simple metric, namely number of page views from some very active Zope sites. This isn't a "benchmarking" exercise to measure how fast these pages are being served. Simply, a count of X millions of hits per day/week/month, etc. This potential customer is one of the leading sites on the net, so please keep the responses to only reasonably active sites. For example, I am interested in sites like technocrat.net, i-gift.com, byproducts.com, the wonderful Brazilian sites like IDGNow, etc. If there are secret Zope sites out there doing lots of traffic, please pipe up now :-). If you don't mind being public about your numbers, please cc the list in your response. If you want privacy, just reply to me directly. I won't reveal your name unless you specifically release me to do so, and even then, only to this potential customer. Help us help you make Zope bigger and better :-) Thanks in advance!

1 0

Re: [Zope] Need help with evaluation issues of Zope
by Martijn Faassen 07 Jan '00

07 Jan '00

Michel Pelletier wrote: > This problem only apears to happen in one specific scenario. If you are > using a browser that is running on the same machine as Zope and you are > using RedHat 5.1 or 5.2. This problem doesn't occour for us when > running both the browser and the server on RedHat 6+. We consider this > then to be a pretty minor bug. > > Can either of you reproduce it in any other situation? Yes. I mailed Jim Fulton about this too. I am running the server and the browser on RedHat 6.1. The original poster was as far as I can recall on Solaris. When I run the browser on Windows 95 (and the server on RedHat), then *that* bug does not occur, but another nasty bugs (server crashes, sometimes with error messages) do seem to happen. I mailed to Jim Fulton about this too yesterday (and I think I sent a cc to support). I don't consider it to be a minor bug, as I do a lot of restarts during product development. Zope 2.0 on the same machine restarts just fine. I can do some more testing next week if you want, but I did test quite a bit yesterday and it's definitely Not Working for me, for browsers remote or local, though the symptoms are different (each bad). Regards, Martijn

2 1

(no subject)
by Steve Froggatt 07 Jan '00

07 Jan '00

Any body know what this means, it appears after I use the web browser, and the server crashes. It seemed to work OK until I did a lot of DHTL editing File "/home/sites/site2/web/cgi-bin/Zope-2.1.1-src/z2.py", line 579, in ? pf.close() IOError: [Errno 1133] Quota exceeded

2 1

Getting started, product suggestions, advocacy
by srl 07 Jan '00

07 Jan '00

Hi all--- I'm working on getting a sample install of Zope going at my office, mostly for demo purposes. Ideally, I'd like to do a proof-of-concept for a community portal-type site, which needs the following features: -page personalization for users -RDF channel importing (for headlines) -threaded discussions -ideally, group-based scheduling/messageboards I have Zope installed on a Solaris box. the only database I have installed at the moment is MS SQL Server 7.0, which I could talk to through ODBC. -will Zope talk to SQL Server? if not, what free databases would you recommend? -What data should I be using ZODB for, and what data needs to be in a relational database? -What products should I look into for the tasks I need to do? -Ideas on a plan of attack that'll break me into using Zope relatively painlessly? Also, has anyone put together a Zope Advocacy page or FAQ that I can use with my coworkers? We're a ColdFusion web shop, and I need heavy ammo to convince people to learn another language. srl

2 1