[Erp5-report] r15149 - /erp5/trunk/products/ZMySQLDA/db.py

[nobody at svn.erp5.org]

Author: vincent
Date: Thu Jul  5 11:08:49 2007
New Revision: 15149

URL: http://svn.erp5.org?rev=15149&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/ZMySQLDA/db.py

Modified: erp5/trunk/products/ZMySQLDA/db.py
URL: http://svn.erp5.org/erp5/trunk/products/ZMySQLDA/db.py?rev=15149&r1=15148&r2=15149&view=diff
==============================================================================
--- erp5/trunk/products/ZMySQLDA/db.py (original)
+++ erp5/trunk/products/ZMySQLDA/db.py Thu Jul  5 11:08:49 2007
@@ -378,6 +378,8 @@
         try:
             self.db.query(query)
         except OperationalError, m:
+            if m[0] == 1054: # Query syntax error
+              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: