September 1999 - Zope

ZOPE 2.0.0 rpms: non-RH linux systems
by Andreas Kostyrka 02 Sep '99

02 Sep '99

Hi! On a second thought, the rpms at http://www.zope.at/mze/ should work with any glibc2.0 or glibc2.1 based linux distribution that uses rpm. So could the non-RH users interested in RPMs try them out and tell me, so that I can add correspondence links? Andreas -- Andreas Kostyrka | andreas(a)mtg.co.at phone: +43/1/7070750 | phone: +43/676/4091256 MTG Handelsges.m.b.H. | fax: +43/1/7065299 Raiffeisenstr. 16/9 | 2320 Zwoelfaxing AUSTRIA

1 0

RFI: How-to on making zope an NT service?
by Joe Grace 02 Sep '99

02 Sep '99

Heck, I'd settle for a pointer even! :-) I know I've seen the info before but haven't been able to find it (tried the search on the beta site). Any pointers? Thanks, = Joe =

1 0

ZOPE 2.0.0 RH5.2/RH6.0 RPMs
by Andreas Kostyrka 02 Sep '99

02 Sep '99

Hi! I've packaged ZOPE 2.0 for RH5.2 and RH6.0. As usual, the rpms are available at http://www.zope.at/mze/ I'd appreciate, if someone with a working RH5.2 system could check test if the RH5.2 rpms are working. Andreas -- Andreas Kostyrka | andreas(a)mtg.co.at phone: +43/1/7070750 | phone: +43/676/4091256 MTG Handelsges.m.b.H. | fax: +43/1/7065299 Raiffeisenstr. 16/9 | 2320 Zwoelfaxing AUSTRIA

1 0

Re: [Zope] ZSQL error using MySQLDA
by Anthony Baxter 02 Sep '99

02 Sep '99

>>> Rick Ree wrote > I have a MySQL query as follows: > > select foo.id, bar.name, count(*) > from foo, bar > where (foo.id = bar.id) > group by foo.id > Error, exceptions.KeyError: unhandled > > Why might this be? If I omit count(*) from the query it runs fine, or if > I use count(*) in a query involving only a single table, it also works. try this: select foo.id, bar.name, count(*) as cnt from foo, bar where (foo.id = bar.id) group by foo.id The returned columns from an SQL query have to be named something that Zope can deal with (and have to be uniquely named). Anthony

2 1

RE: [Zope] equivalent of eval in dtml ?
by happyrhino＠usa.net 02 Sep '99

02 Sep '99

Answering my own question. I've realised that I was trying to do too much within DTML by trying to import Python modules. I thought wrongly that you could embed Python code within DTML (other than the basic string and math services in _) The solution seems to be to use external methods instead. Using the same example = >How to set a variable 'mytime' to the current time ? > ><dtml-call "REQUEST.set('mytime', 'ZopeTime fmt=%H:%M')"> > >sets it to the string 'ZopeTime fmt=%H:%M' > >Is there no equivalent of eval() ? The solution was simply to create an external method called 'timenow' to return the time. Then use <dtml-call "REQUEST.set('mytime', timenow)"> In fact, external methods look like the way to go for a lot of data massaging. For example, in my CGI programs I currently take the results from a SQL query and run some of the fields through customised Python functions to further format them. It seems that the best way to do this with Zope is to write an external method for each function. However, this does mean that I'm going to have dozens if not hundreds of external methods; but at least they're easier to read than dtml. Henry ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1

1 0

Re: [Zope] Sql problem in 2.0.0
by Anthony Baxter 02 Sep '99

02 Sep '99

>>> "Jim Sanford" wrote > Trying to run zsql method I get following error. (see traceback below) > Have reconfigured ODBC. Have deleted and recreated method. > 1.10.3 ran fine on this machine when not run as part of IIS. Looks to me like the SQL Database adaptor you're using hasn't been updated to use the new Zope2 transaction machinery. There's a database adaptor status page that Chris Petrilli is maintaining on the Zope site - check it there. Anthony > > > Traceback (innermost last): > File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 214, in > publish_module > File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 179, in > publish > File C:\PROGRA~1\ATIANY~1\lib\python\Zope\__init__.py, line 179, in > zpublisher_exception_hook > (Object: UserSettings) > File C:\PROGRA~1\ATIANY~1\lib\python\ZODB\Transaction.py, line 180, in begi n > File C:\PROGRA~1\ATIANY~1\lib\python\ZODB\Transaction.py, line 155, in abor t > AttributeError: abort > > -->__________________________________________________________________ > > Jim Sanford > ^ Database Engineer > ^ ^ ^ Accelerated Technology, Inc. > ^ ^ 720 Oak Circle Drive East > ^ ^ ^ Mobile, AL 36609 > ^ ^ ^ Voice: 334-661-5770 fax: 334-661-5788 > ^ ^ E-Mail: Jsanford(a)atinucleus.com > Web: http://www.atinucleus.com > > Source Code, No Royalties, Any CPU...It just make sense ! > __________________________________________________________________ > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

Install problem solved... but 2.0 squishdot problems..
by Nicolas Pottier 01 Sep '99

01 Sep '99

Ok, I figured out the problem.. Zope is smarter than I was and decided that I shouldn't be using root as the account to run under, so started as nobody.. Unfortunatly, nobody didn't have the rights it needed. Creating a zope account and running it under that made things work much better. Now.. of course, the day I go out of my way to install zope, version 2.0 comes out.. so I decide I should upgrade now before I get comfortable with my current version.. So zope 2.0 installs fine, but when trying to create a new squishdot site, I get the following error: Traceback (innermost last): File /home/nicp/zope2/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home/nicp/zope2/lib/python/ZPublisher/Publish.py, line 179, in publish File /home/nicp/zope2/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home/nicp/zope2/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/nicp/zope2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addSquishdot) File /home/nicp/zope2/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_addSquishdot) File /home/nicp/zope2/lib/python/Products/Squishdot/Squishdot.py, line 1487, in manage_addSquishdot (Object: ElementWithAttributes) File /home/nicp/zope2/lib/python/Products/Squishdot/Squishdot.py, line 480, in __init__ (Object: ElementWithAttributes) File /home/nicp/zope2/lib/python/Products/Squishdot/Squishdot.py, line 230, in addArt (Object: ElementWithAttributes) File /home/nicp/zope2/lib/python/Products/Squishdot/Squishdot.py, line 796, in addPosting (Object: ElementWithAttributes) File /home/nicp/zope2/lib/python1.5/regsub.py, line 38, in gsub AttributeError: (see above) I've read about the fix needed to TinyTable in order to make Squishdot work with the new Zope's, and I edited the file as needed, but I still get the error. I suspect I need to recompile the TinyTable.py file (into a .pyc?), but I've never worked with Python before, so I don't know how.. Can anybody give me a quick hand again? BTW.. The initial impressions once I got Squishdot going on the older version of Zope are very good.. I'm really impressed with it! Kudos to all that have contributed to it. -Nic

2 2

Sql problem in 2.0.0
by Jim Sanford 01 Sep '99

01 Sep '99

Just downloaded and installed Zope 2.0.0 on Windows NT machine running as a service. Converted 1.10.3 data.bbb to data.fs Everything looked ok. Trying to run zsql method I get following error. (see traceback below) Have reconfigured ODBC. Have deleted and recreated method. 1.10.3 ran fine on this machine when not run as part of IIS. Any clues? Traceback (innermost last): File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 214, in publish_module File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 179, in publish File C:\PROGRA~1\ATIANY~1\lib\python\Zope\__init__.py, line 179, in zpublisher_exception_hook (Object: UserSettings) File C:\PROGRA~1\ATIANY~1\lib\python\ZODB\Transaction.py, line 180, in begin File C:\PROGRA~1\ATIANY~1\lib\python\ZODB\Transaction.py, line 155, in abort AttributeError: abort -->__________________________________________________________________ Jim Sanford ^ Database Engineer ^ ^ ^ Accelerated Technology, Inc. ^ ^ 720 Oak Circle Drive East ^ ^ ^ Mobile, AL 36609 ^ ^ ^ Voice: 334-661-5770 fax: 334-661-5788 ^ ^ E-Mail: Jsanford(a)atinucleus.com Web: http://www.atinucleus.com Source Code, No Royalties, Any CPU...It just make sense ! __________________________________________________________________

1 0

Re: [Zope] ZODB size?
by Doug McNaught 01 Sep '99

01 Sep '99

Michel Pelletier <michel(a)digicool.com> writes: > ZODB3 is limited to 18,446,744,073,709,551,616 objects. This should be > adequate. [...] > You will run into the 2GB ext2 file size limit long before you have any > other problems. So if I'm planning to serve out large data items (which, stored together, would push the ZODB over the 2GB limit) for download, I should create a mechanism to keep the actual data in the filesystem? Has anyone done this? -Doug -- Doug McNaught doug(a)mcnaught.org http://www.mcnaught.org/~doug

3 2

bug in mkproduct
by Sebastian Luehnsdorf 01 Sep '99

01 Sep '99

hi everyone! unfortunately, just before release, a silly bug slipped into both the tarball and zip distributions of mkproduct. the error is on lin # 136 of the file lib/python/Products/mkproduct you can fix it by commenting out that line or by downloading the fixed version which will be online later today or tomorrow at www.zope.de/software/mkproduct sorry for any inconveniences... ciao, basti --------------------------------------------------------------------- sebastian f. luehnsdorf beehive elektronische medien gmbh --------------------------------------------------------------------- http://basti.beehive.de http://www.beehive.de mailto:basti@beehive.de mailto:service@beehive.de fon: (+49 30) 84 78 20 fax: (+49 30) 84 78 22 99

2 2