I was getting the following error when attempting to call a stored procedure via a Z SQL Method: _mysql_exceptions.OperationalError: (1312, etc So I made the following change to /usr/lib/zope/lib/python/Products/ZMySQLDA/db.py: def _parse_connection_string(self, connection): kwargs = {'conv': self.conv, 'client_flag': 65536 #inserted by CSB } I then restarted Zope. I can now successfully call stored procedures. There may be a better way to do it. Feel free to advise if so. Apologies if this information has already been posted. Cameron
Yeah, I put up a patch on the MySQLDb Sourceforge page a long time ago for that. Doing almost the same thing. Only I made it so you specify the client flag in the Zope connection object. Doesnt do any good for windows though, they still have a problem with the mysql lib. (I think I posted a bug on that too) Greg On 1/16/06, Cameron Beattie <kjcsb@orcon.net.nz> wrote:
I was getting the following error when attempting to call a stored procedure via a Z SQL Method: _mysql_exceptions.OperationalError: (1312, etc
So I made the following change to /usr/lib/zope/lib/python/Products/ZMySQLDA/db.py: def _parse_connection_string(self, connection): kwargs = {'conv': self.conv, 'client_flag': 65536 #inserted by CSB }
I then restarted Zope. I can now successfully call stored procedures. There may be a better way to do it. Feel free to advise if so.
Apologies if this information has already been posted.
Cameron
_______________________________________________ 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 )
-- Greg Fischer 1st Byte Solutions http://www.1stbyte.com
Cameron Beattie wrote at 2006-1-17 17:37 +1300:
I was getting the following error when attempting to call a stored procedure via a Z SQL Method: _mysql_exceptions.OperationalError: (1312, etc
You consult your MySQL documentation to find out what the error code "1312" means... -- Dieter
participants (3)
-
Cameron Beattie -
Dieter Maurer -
Greg Fischer