- Zope - Zope lists

Zope -> MySQL Weirdness
by Tom Rectenwald 30 Nov '04

30 Nov '04

Hello, I am just starting to learn Zope and am having trouble getting it to communicate with mySQL. Here is what I have done thus far: - Built and compiled MySQLdb and ZMySQLDA. - Installed the 'Z MySQL Database Connection. - Entered in the 'Database Connection String' (DB, user, password) Once done, I went to the 'Test' tab and here is where things get weird: - I can run an INSERT statement with no trouble and verify that the DB is updated. - However, whenever I run any sort of SELECT query I get the following error: Error Type: TypeError Error Value: object does not support item assignment I also get this error when trying to put a SELECT in Z SQL Method. I'm very new at this stuff and come from a PHP/Perl/mySQL/postgreSQL background, so any help at all is appreciated. If desired, I can send the error_log output as well. I just don't get it. :-( Thank you for an help, suggestions, advice. I've googled this to bits to no avail. I am really enjoying Zope so far; just wish I understood it better. Regards, Tom

4 3

Installation of X3
by professorix＠gmx.de 30 Nov '04

30 Nov '04

Hi, I tried to install ZopeX3 and got the following errors by the "make test" and "make install". I installed before python 2.3.4 Can someone help me? Regards Uwe p15142475:/usr/local/ZopeX3-3.0.0 # ./configure Configuring Zope X3 installation Testing for an acceptable Python interpreter... Python version 2.3.4 found at /usr/local/bin/python The optimum Python version (2.3.4) was found at /usr/local/bin/python. Installation directory /usr/local/ZopeX3-3.0.0 already exists. Specify a directory that isn't being used, or use --force to use it anyway. p15142475:/usr/local/ZopeX3-3.0.0 # ./configure --force Configuring Zope X3 installation Testing for an acceptable Python interpreter... Python version 2.3.4 found at /usr/local/bin/python The optimum Python version (2.3.4) was found at /usr/local/bin/python. p15142475:/usr/local/ZopeX3-3.0.0 # make check /usr/local/bin/python install.py -q build /usr/local/bin/python test.py -v Running UNIT tests at level 1 Running UNIT tests from /usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3 Error in test Invalid Test (zope.app.tree.browser.tests) Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/browser/tests.py", line 24, in ? from zope.app.tree.utils import TreeStateEncoder File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/utils.py", line 18, in ? import zlib ImportError: No module named zlib Error in test Invalid Test (zope.app.tree.tests.test_adapters) Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/test_adapters.py", line 36, in ? from zope.app.tree.utils import TreeStateEncoder ImportError: cannot import name TreeStateEncoder Error in test Invalid Test (zope.app.tree.tests.test_filters) Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/test_filters.py", line 26, in ? from test_adapters import SampleContent ImportError: cannot import name SampleContent Error in test Invalid Test (zope.app.tree.tests.test_node) Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/test_node.py", line 19, in ? from basetest import BaseTestCase File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/basetest.py", line 26, in ? from zope.app.tree.utils import TreeStateEncoder ImportError: cannot import name TreeStateEncoder ............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... Failure in test testUmask (zdaemon.tests.testzdrun.ZDaemonTests) Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zdaemon/tests/testzdrun.py", line 244, in testUmask self.assert_(not os.access(path, os.W_OK)) File "/usr/local/lib/python2.3/unittest.py", line 278, in failUnless if not expr: raise self.failureException, msg AssertionError ................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... ====================================================================== ERROR: Invalid Test (zope.app.tree.browser.tests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/browser/tests.py", line 24, in ? from zope.app.tree.utils import TreeStateEncoder File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/utils.py", line 18, in ? import zlib ImportError: No module named zlib ====================================================================== ERROR: Invalid Test (zope.app.tree.tests.test_adapters) ---------------------------------------------------------------------- Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/test_adapters.py", line 36, in ? from zope.app.tree.utils import TreeStateEncoder ImportError: cannot import name TreeStateEncoder ====================================================================== ERROR: Invalid Test (zope.app.tree.tests.test_filters) ---------------------------------------------------------------------- Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/test_filters.py", line 26, in ? from test_adapters import SampleContent ImportError: cannot import name SampleContent ====================================================================== ERROR: Invalid Test (zope.app.tree.tests.test_node) ---------------------------------------------------------------------- Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 624, in get_suite mod = package_import(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tests/test.py", line 600, in package_import __import__(modname) File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/test_node.py", line 19, in ? from basetest import BaseTestCase File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zope/app/tree/tests/basetest.py", line 26, in ? from zope.app.tree.utils import TreeStateEncoder ImportError: cannot import name TreeStateEncoder ====================================================================== FAIL: testUmask (zdaemon.tests.testzdrun.ZDaemonTests) ---------------------------------------------------------------------- Traceback (most recent call last): File "/usr/local/ZopeX3-3.0.0/build/lib.linux-i686-2.3/zdaemon/tests/testzdrun.py", line 244, in testUmask self.assert_(not os.access(path, os.W_OK)) File "/usr/local/lib/python2.3/unittest.py", line 278, in failUnless if not expr: raise self.failureException, msg AssertionError ---------------------------------------------------------------------- ---------------------------------------------------------------------- Ran 3955 tests in 566.296s FAILED (failures=1, errors=4) make: *** [check] Error 1 p15142475:/usr/local/ZopeX3-3.0.0 # make install /usr/local/bin/python install.py -q build /usr/local/bin/python install.py -q install --skip-build --home "/usr/local/ZopeX3-3.0.0" Traceback (most recent call last): File "/tmp/tmpSy5BEd.py", line 1, in ? from distutils.util import byte_compile File "/usr/local/lib/python2.3/distutils/util.py", line 9, in ? import sys, os, string, re ImportError: /tmp/re.so: undefined symbol: PL_dowarn error: command '/usr/local/bin/python' failed with exit status 1 make: *** [install] Error 1 p15142475:/usr/local/ZopeX3-3.0.0 # -- Geschenkt: 3 Monate GMX ProMail + 3 Top-Spielfilme auf DVD ++ Jetzt kostenlos testen http://www.gmx.net/de/go/mail ++

3 2

Illegal Characters List
by Robert Hill 30 Nov '04

30 Nov '04

Is there a list out there of characters considered illegal for use in IDs by Zope? Some that I am aware of are ?, &, <space>. Thanks, Rob

3 2

CMF Photo Album + "Raw" Image Formats
by Tom Purl 30 Nov '04

30 Nov '04

I'm a newb when it comes to archiving images, so any help you can give me would be greatly appreciated. I want to use Plone as a content management system (CMS) my images, which are currently stored on my hard drive as PNM files. These files are scanned copies of 4x6 images, and are usually ~6 MB in size. I am using Plone 2.0.4 with CMF Photo Album/Photo 0.5.0 and pil 1.1.4. I use the PNM file format for my pictures because it's the "rawest" format that I can use with xsane (I also use Gentoo Linux). When I upload my pictures in the PNM format to Plone, I'm not able to see them. I then tried converting the image (using convert) to a tiff file (since that's also pretty "raw", right?) and uploading it. However, I'm still not able to see the image in my cmf photo album. I ended up converting it to a bitmap, and I'm able to see that in my album. Is the bmp file format considered a "raw" format? I would like to keep it as raw as possible so that I can use (or at least convert) my images 50 years from now. Is there a better format to use? I'm using plone as my CMS because I want to attach metadata to my images. Is anyone else using a different free program that works better than this solution? Thanks in advance! Tom Purl

2 2

Problem sending mail
by John Poltorak 29 Nov '04

29 Nov '04

I get an error sending out mail from within a Plone app:- This site encountered an error trying to fulfill your request. The errors were: Error Type Mail couldn`t be sent (Script send_a_mail.py) This is the relevant script:- #Try if a Mailhost is specified try: mailhost=getattr(context, context.portal_url.superValues('Mail Host')[0].id) except: raise "There is no Mailhost specified (Script send_a_mail.py)" #send try: mailhost.send(mMsg,mTo,mFrom,mSubj) except: raise "Mail couldn`t be sent (Script send_a_mail.py)" How do I tell what the problem is? Should I expect to see anything in the local sendmail log? -- John

3 3

Color names
by John Poltorak 29 Nov '04

29 Nov '04

Where do I find a list of color names which Zope recognises? I tried RGB.TXT from XFree86 but that was not definitive. I don't suppose there is a color wheel hidden away in ZMI anywhere is there... -- John

9 10

Product installation
by John Poltorak 29 Nov '04

29 Nov '04

As I understand it, all that is required to install a product in Zope is to extract the archive to the Products directory and restart Zope. This is what I have done in the past and then the product shows up under /Control_Panel/Products. For some reason this does not happen with PloneGuestbook on my installation of Zope 2.7.3 on Linux Redhat v7.3. Can anyone suggest why? Or where should I look to see any signs of problems? No relevant msgs are to be found in the logs. -- John

2 2

ZCatalog dynamic indexing
by Garito 29 Nov '04

29 Nov '04

Hi Is there any kind of index of ZCatalog to make dynamic indexing? I would like to find objects with some values on a list index but index is dynamic I the propertyA I have a list, for example: Object1 propertyA Value1 Value2 Value3 I would like to search for propertyA, index 1 for all object that have Value2 in this index Can I make these kind of searches? TIA

3 5

Proxy Support for External Editor
by Stefan Götz 29 Nov '04

29 Nov '04

Hi! People forced to use an HTTP proxy may find a slightly patched version of the External Editor helper app useful that supports proxies: http://ps.ri.uni-tuebingen.de/Members/goetzs/zopeedit.py/file_view The proxy name and port can be configured via an environment variable or configuration file option of the form "http_proxy = proxy.mydomain.com:3128" Cheers, Stefan

1 0

Re: Re: [Zope] Zope -> MySQL Weirdness
by Tom Rectenwald 28 Nov '04

28 Nov '04

> > From: Cliff Ford <Cliff.Ford(a)ed.ac.uk> > Date: 2004/11/27 Sat AM 09:50:03 GMT > To: Tom Rectenwald <seldan(a)verizon.net> > CC: zope(a)zope.org > Subject: Re: [Zope] Zope -> MySQL Weirdness > > What happens when you run a Select query from the Test tab of the > Database Connection object (select * from <tablename>)? That sometimes > gives a more explicit error message from the database. > > Cliff > > Tom Rectenwald wrote: > > Hello, > > > > I am just starting to learn Zope and am having trouble getting it > > to communicate with mySQL. > > > > Here is what I have done thus far: > > > > - Built and compiled MySQLdb and ZMySQLDA. > > - Installed the 'Z MySQL Database Connection. > > - Entered in the 'Database Connection String' (DB, user, password) > > > > Once done, I went to the 'Test' tab and here is where things get > > weird: > > > > - I can run an INSERT statement with no trouble and verify that > > the DB is updated. > > - However, whenever I run any sort of SELECT query I get the > > following error: > > > > Error Type: TypeError > > Error Value: object does not support item assignment > > > > > > I also get this error when trying to put a SELECT in Z SQL Method. > > I'm very new at this stuff and come from a PHP/Perl/mySQL/postgreSQL > > background, so any help at all is appreciated. If desired, I can > > send the error_log output as well. I just don't get it. :-( > > > > Thank you for an help, suggestions, advice. I've googled this to > > bits to no avail. I am really enjoying Zope so far; just wish I understood it better. > > > > Regards, > > Tom > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://mail.zope.org/mailman/listinfo/zope > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://mail.zope.org/mailman/listinfo/zope-announce > > http://mail.zope.org/mailman/listinfo/zope-dev ) > Hello, My apologies for the late response. I was getting the same error when running from the test tab. As it turns out, I was running Zope 2.8.01a. Perhaps it was just a compatibility issue. I removed that and compiled Zope 2.7.3 and everything is working wonderfully now. Thanks all for the help. Tom

2 1