what does (2014, "Commands out of sync; You can't run this command now") mean??
Hi there, we are using a MySQLdb adapter, and get sometimes a (2014, "Commands out of sync; You can't run this command now") error. Most of the time things are working fine. But up a sudden we get a traceback like the following: Thanks for any hints Robert Traceback (innermost last): Module ZPublisher.Publish, line 101, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Products.CMFCore.FSPythonScript, line 104, in __call__ Module Shared.DC.Scripts.Bindings, line 306, in __call__ Module Shared.DC.Scripts.Bindings, line 343, in _bindAndExec Module Products.CMFCore.FSPythonScript, line 160, in _exec Module None, line 2, in zr_edit_setFieldValues - <FSPythonScript at /intranet/zehnder/zr_edit_setFieldValues used for /intranet/zehnder/servicetickets/ticket.2005-01-28.8948828769> - Line 2 Module Products.CMFCore.CMFCatalogAware, line 69, in reindexObject Module Products.RedNotify.RedNotifyCatalogTool, line 135, in reindexObject Module Products.CMFCore.CatalogTool, line 262, in reindexObject Module Products.CMFCore.CatalogTool, line 235, in catalog_object Module Products.ZCatalog.ZCatalog, line 528, in catalog_object Module Products.ZCatalog.Catalog, line 381, in catalogObject Module Products.PluginIndexes.TextIndex.TextIndex, line 287, in index_object Module Products.ZehnderRequest.ZehnderRequest.ZehnderTicketBase, line 60, in SearchableText Module Products.ZehnderRequest.ZehnderRequest.ZehnderDb, line 1135, in getAllDbTextForTicket Module Products.ZehnderRequest.ZehnderRequest.ZehnderDb, line 239, in sql_query_first Module MySQLdb.cursors, line 95, in execute Module MySQLdb.cursors, line 114, in _execute Module MySQLdb.connections, line 33, in defaulterrorhandler ProgrammingError: (2014, "Commands out of sync; You can't run this command now")
robert wrote at 2005-2-3 16:30 +0100:
we are using a MySQLdb adapter, and get sometimes a (2014, "Commands out of sync; You can't run this command now") error. ... Module MySQLdb.connections, line 33, in defaulterrorhandler ProgrammingError: (2014, "Commands out of sync; You can't run this command now")
Obviously a message from the MySQL database. Its documentation should tell you what this error means. -- Dieter
On Thu, 03 Feb 2005 16:30:50 +0100, robert <robert@redcor.ch> wrote:
Hi there, we are using a MySQLdb adapter, and get sometimes a (2014, "Commands out of sync; You can't run this command now") error.
It means two things: 1) You are using MySQLdb directly, and not ZMySQLDA, so it is not a Zope issue. 2) You are using SSCursor, and you failed to fetch all the rows before issuing another query. https://sourceforge.net/forum/forum.php?forum_id=70461 is the right place to ask your question, but that is basically your answer above. -- Computer interfaces should never be made of meat. Using GMail? Setting Reply-to address to <> disables this annoying feature.
Andy Dustman wrote:
On Thu, 03 Feb 2005 16:30:50 +0100, robert <robert@redcor.ch> wrote:
Hi there, we are using a MySQLdb adapter, and get sometimes a (2014, "Commands out of sync; You can't run this command now") error.
It means two things:
1) You are using MySQLdb directly, and not ZMySQLDA, so it is not a Zope issue.
2) You are using SSCursor, and you failed to fetch all the rows before issuing another query.
https://sourceforge.net/forum/forum.php?forum_id=70461
is the right place to ask your question, but that is basically your answer above.
Andy thanks a lot. Robert
participants (3)
-
Andy Dustman -
Dieter Maurer -
robert