Larry McDonnell wrote:
Hi,
I'm test 2.7.3 out and I cannot create a connection to my database. I am using the new adapter ZMySQLDA-2.0.9b2 <http://sourceforge.net/projects/mysql-python/> .and I loaded MySQL-python.exe-0.9.2.win32-py2.3.exe pointing it to the bin directory of my zope installation. It added it to my product list but when I try to make a connection I see the following:
Traceback (innermost last):
* Module ZPublisher.Publish, line 175, in publish_module_standard * Module ZPublisher.Publish, line 132, in publish * Module Zope.App.startup, line 204, in zpublisher_exception_hook * Module ZPublisher.Publish, line 101, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Products.ZMySQLDA.DA, line 106, in manage_addZMySQLConnection * Module Shared.DC.ZRDB.Connection, line 64, in __init__ * Module Shared.DC.ZRDB.Connection, line 97, in edit * Module Products.ZMySQLDA.DA, line 126, in connect * Module Products.ZMySQLDA.db, line 183, in __init__
AttributeError: server_capabilities (Also, an error occurred while attempting to render the standard error message.)
I also tried a password option but still no connection. I know I could do the above in 2.6.1.
Thanks, Larry
------------------------------------------------------------------------
_______________________________________________ Zope maillist - Zope@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 )
I know the problem but have no Zope with MySQL access handy. There is a facility to limit the number of rows that are returned that does not work anymore (why I never bothered to find out). You just have to switch it of (I think by setting it to 0). You find it in one of the ZMySQLDB or ZSQL tabs. If you need further help, tell me. Robert