MySQL db connect after upgrade to Zope 2.7.0 ...

[Marc G. Fournier]

that did it ... something that maybe should be added to the port itself?



On Tue, 1 Jun 2004, Hye-Shik Chang wrote:

> On Mon, May 31, 2004 at 07:10:54PM -0300, Marc G. Fournier wrote:
>>
>> Can't seem to find any *answers* on Google, but a few ppl asking about it
>> ...
>>
>> Just upgraded, and am getting:
>>
>> 2004-05-31T22:03:54 ERROR(200) Shared.DC.ZRDB.Connection Error connecting
>> to relational database.
>> Traceback (most recent call last):
>>   File "/usr/local/www/Zope/lib/python/Shared/DC/ZRDB/Connection.py", line
>>   69, in __setstate__
>>     try: self.connect(self.connection_string)
>>   File
>>   "/home/ports/usr/ports/www/zope-zmysqlda/work/lib/python/Products/ZMySQLDA/DA.py", line 126, in connect
>>   File
>>   "/home/ports/usr/ports/www/zope-zmysqlda/work/lib/python/Products/ZMySQLDA/db.py", line 183, in __init__
>> AttributeError: server_capabilities
>>
>> How do I fix? :(  Or even debug?
>>
>> Thanks ...
>>
>
> According to:
> http://www.google.com/search?q=cache:Oti-fgNOtvoJ:www.dzug.org/mailinglisten/zope/archive/2004/2004-04/1082980237427+AttributeError:+server_capabilities&hl=ko
> http://www.google.com/search?q=cache:Eoq-GsF17nUJ:mooya.ath.cx/CubeDeZope/1068486456/index_html+AttributeError:+server_capabilities&hl=ko
>
> This may be working fix.
>
> --- ZMySQLDA/db.py.orig	Tue Jun  1 07:29:02 2004
> +++ ZMySQLDA/db.py	Tue Jun  1 07:29:32 2004
> @@ -180,7 +180,7 @@
>         self.connection=connection
>         self.kwargs = kwargs = self._parse_connection_string(connection)
>         self.db=apply(self.Database_Connection, (), kwargs)
> -	self.transactions = self.db.server_capabilities & CLIENT.TRANSACTIONS
> +	self.transactions = 1
>         if self._try_transactions == '-':
>             self.transactions = 0
>         elif not self.transactions and self._try_transactions == '+':
>
> Hye-Shik
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664