MySQL db connect after upgrade to Zope 2.7.0 ...

[Hye-Shik Chang]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-python/attachments/20040601/cd74fece/attachment.bin