[Erp5-report] r15150 - /erp5/trunk/products/ZMySQLDDA/db.py

[nobody at svn.erp5.org]

Author: vincent
Date: Thu Jul  5 11:09:19 2007
New Revision: 15150

URL: http://svn.erp5.org?rev=15150&view=rev
Log:
When MySQL reports a snyntax error in a query, put the query in the log to ease debugging.

Modified:
    erp5/trunk/products/ZMySQLDDA/db.py

Modified: erp5/trunk/products/ZMySQLDDA/db.py
URL: http://svn.erp5.org/erp5/trunk/products/ZMySQLDDA/db.py?rev=15150&r1=15149&r2=15150&view=diff
==============================================================================
--- erp5/trunk/products/ZMySQLDDA/db.py (original)
+++ erp5/trunk/products/ZMySQLDDA/db.py Thu Jul  5 11:09:19 2007
@@ -383,6 +383,8 @@
       try:
         self.db.query(query)
       except OperationalError, m:
+        if m[0] == 1054: # Query syntax error: display query.
+          raise OperationalError(m[0], '%s: %s' % (m[1], query))
         if ((not force_reconnect) and \
             (self._mysql_lock or self._transactions)) or \
            m[0] not in hosed_connection: