Can't use selectqueries against a mysql db

[Marco Wesselgren]

Hi!

I have some problems with my connection from zope through ZMySQLDA. Some queries work , for example
desc <tablename> , but all select queries fails.

I have the following setup:

Zope: 2.4.1 (source release, python 2.1, linux2), python 2.1.1, openbsd3
Python: 2.1.1 (#1, Dec 17 2001, 17:51:53) [GCC 2.95.3 20010125 (prerelease)]

MySQL: 3.23.42

ZMySQLDA: 2.0.8

The output that i get when using select queries:

The query : select * from <tablename>;

Traceback (innermost last):
  File /usr/ports/www/zope/w-zope-2.4.1.1/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line 223, in publish_module
  File /usr/ports/www/zope/w-zope-2.4.1.1/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line 187, in publish
  File /usr/ports/www/zope/w-zope-2.4.1.1/Zope-2.4.1-src/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook
    (Object: RoleManager)
  File /usr/ports/www/zope/w-zope-2.4.1.1/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line 171, in publish
  File /usr/ports/www/zope/w-zope-2.4.1.1/Zope-2.4.1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: manage_test)
  File /usr/ports/www/zope/w-zope-2.4.1.1/Zope-2.4.1-src/lib/python/ZPublisher/Publish.py, line 112, in call_object
    (Object: manage_test)
  File /usr/ports/www/zope/w-zope-2.4.1.1/Zope-2.4.1-src/lib/python/Shared/DC/ZRDB/Connection.py, line 179, in manage_test
    (Object: RoleManager)
  File /usr/local/lib/zope/lib/python/Products/ZMySQLDA/db.py, line 284, in query
ProgrammingError: (see above)

Regards

[Andy Dustman]

You left off the exception.