#751: OperationalError: (1093, "You can't specify target table 'session_attribute' for update in FROM clause") ---------------------------------+------------------------------------------ Reporter: bloguseer@… | Type: task Status: new | Priority: major Milestone: | Component: Architecture Keywords: | Who will test this: And ---------------------------------+------------------------------------------ ==== How to Reproduce ====
While doing a POST operation on `/ticket/643`, Trac issued an internal error. [http://www.bestreplicawatches.co/ replica handbags] ''(please provide additional details here)'' Request parameters: {{{ {'__FORM_TOKEN': u'56be00faa68ecd3e12865e52', 'action': u'leave', 'author': u'[email protected]', 'cnum': u'12', 'comment': u'Our replica watches are exact copies of the original products. The high quality replica watches can make a statement on you wherever you go. Most of them come with stainless steel cases and sapphire crystal mineral glass.[http://www.bestreplicawatches.co/ replica handbags],\r\n[http://www.bestreplicawatches.co/replica-watches- omega-c-9_13.html omega replica watches],\r\n[http://www.bestreplicawatches.co/replica-watches- breitling-c-9_42.html Breitling replica].', 'id': u'643', 'replyto': u'', 'submit': u'Submit changes', 'ts': u'2012-02-02 04:49:28.594668+00:00'} }}} User agent: `Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.9.2.28) Gecko/20120306 Firefox/3.6.28 GTB7.1` ==== System Information ==== ''System information not available'' ==== Enabled Plugins ==== ''Plugin information not available'' ==== Python Traceback ==== {{{ Traceback (most recent call last): File "/usr/local/lib/python2.6/dist- packages/Trac-0.12-py2.6.egg/trac/web/main.py", line 513, in _dispatch_request dispatcher.dispatch(req) File "/usr/local/lib/python2.6/dist- packages/Trac-0.12-py2.6.egg/trac/web/main.py", line 235, in dispatch resp = chosen_handler.process_request(req) File "/usr/local/lib/python2.6/dist- packages/Trac-0.12-py2.6.egg/trac/ticket/web_ui.py", line 169, in process_request return self._process_ticket_request(req) File "/usr/local/lib/python2.6/dist- packages/Trac-0.12-py2.6.egg/trac/ticket/web_ui.py", line 534, in _process_ticket_request valid = self._validate_ticket(req, ticket, not valid) and valid File "/usr/local/lib/python2.6/dist- packages/Trac-0.12-py2.6.egg/trac/ticket/web_ui.py", line 1179, in _validate_ticket for field, message in manipulator.validate_ticket(req, ticket): File "build/bdist.linux-x86_64/egg/tracspamfilter/adapters.py", line 77, in validate_ticket FilterSystem(self.env).test(req, author, changes, ip) File "build/bdist.linux-x86_64/egg/tracspamfilter/api.py", line 192, in test 'potential spam %s' % msg) File "build/bdist.linux-x86_64/egg/tracspamfilter/captcha/api.py", line 75, in reject_content self._cleanup() File "build/bdist.linux-x86_64/egg/tracspamfilter/captcha/api.py", line 202, in _cleanup db.cast('value', 'int')), (tc,t)) File "/usr/local/lib/python2.6/dist- packages/Trac-0.12-py2.6.egg/trac/db/util.py", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute self.errorhandler(self, exc, value) File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue OperationalError: (1093, "You can't specify target table 'session_attribute' for update in FROM clause") }}} -- Ticket URL: <http://plumi.tv/ticket/751> Plumi <http://plumi.org/> Plumi - FOSS Video Sharing Platform _______________________________________________ Discuss mailing list [email protected] http://lists.plumi.org/listinfo/discuss
