SPAM Was: OperationalError: (1093, "You can't specify target table 'session_attribute' for update in FROM clause")

[bloguseer@…]

How to Reproduce

While doing a POST operation on /ticket/643, Trac issued an internal error.  replica handbags (please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'56be00faa68ecd3e12865e52',
 'action': u'leave',
 'author': u'zaldaer@yahoo.com',
 '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")