[Zope] New ZMysql adapter connection problem

[robert]

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 at 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