ValueError: A string literal cannot contain NUL (0x00) characters.

[Jun Omae]

How to Reproduce

While doing a POST operation on /admin/spamfilter/monitor, Trac issued an internal error.

The error is raised when I use Delete selected as Spam button for an entry which PDF file is attached on monitoring page.

Request parameters:

{u'__FORM_TOKEN': u'bc9cff57f6e01ca69f544ab2',
 'cat_id': u'spamfilter',
 u'markspamdel': u'Delete selected as Spam',
 u'num': u'50',
 u'page': u'1',
 'panel_id': u'monitor',
 'path_info': None,
 u'sel': [u'232845', u'232844', u'232843'],
 u'toggle_group': u'on'}

User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:70.0) Gecko/20100101 Firefox/70.0

System Information

Trac	1.4
Babel	2.7.0
dnspython	1.15.0
Docutils	0.14
Genshi	0.7.1 (with speedups)
GIT	2.11.0
Jinja2	2.10.1
Mercurial	4.8.2
mod_wsgi	4.5.13 (WSGIProcessGroup trac WSGIApplicationGroup %{GLOBAL})
Pillow	6.1.0
PostgreSQL	server: 9.6.15, client: 9.6.15
psycopg2	2.8.3
Pygments	2.3.1
Python	2.7.13 (default, Sep 26 2018, 18:42:22) [GCC 6.3.0 20170516]
pytz	2018.9
setuptools	41.0.1
SpamBayes	1.1b3
Subversion	1.9.5 (r1770682)
jQuery	1.12.4
jQuery UI	1.12.1
jQuery Timepicker	1.6.3

Enabled Plugins

conditional-clear-milestone-operation	N/A
help-guide-version-notice	N/A
milestone-to-version	r15098
StatusFixer	r6326
trac-releases	N/A
TracMercurial	1.0.0.9.dev0
TracSpamFilter	1.3.0.dev0
TracVote	0.7.0.dev0
TracWikiExtras	1.3.1.dev0
TranslatedPages	1.1.0

Interface Customization

shared-htdocs
shared-templates
site-htdocs
site-templates	site.html, site_footer.html, site_head.html, site_header.html, site_leftbox.html

Python Traceback

Traceback (most recent call last):
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/trac/web/main.py", line 639, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/trac/web/main.py", line 250, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/trac/admin/web_ui.py", line 103, in process_request
    resp = provider.render_admin_panel(req, cat_id, panel_id, path_info)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/tracspamfilter/admin.py", line 87, in render_admin_panel
    if self._process_monitoring_panel(req):
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/tracspamfilter/admin.py", line 288, in _process_monitoring_panel
    filtersys.train(req, entries, spam=spam, delete=delete)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/tracspamfilter/filtersystem.py", line 393, in train
    spam=spam)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/tracspamfilter/filters/bayes.py", line 90, in train
    hammie.train(testcontent.encode('utf-8', 'ignore'), spam)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/spambayes/hammie.py", line 164, in train
    self.bayes.learn(tokenize(msg), is_spam)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/spambayes/classifier.py", line 252, in learn
    self._add_msg(wordstream, is_spam)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/spambayes/classifier.py", line 354, in _add_msg
    record = self._wordinfoget(word)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/tracspamfilter/filters/bayes.py", line 211, in _wordinfoget
    row = self._get_row(word)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/tracspamfilter/filters/bayes.py", line 168, in _get_row
    """, (word,)):
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/trac/db/api.py", line 50, in execute
    return db.execute(query, params)
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/trac/db/util.py", line 129, in execute
    cursor.execute(query, params if params is not None else [])
  File "/usr/local/virtualenv/1.3dev/lib/python2.7/site-packages/trac/db/util.py", line 73, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ValueError: A string literal cannot contain NUL (0x00) characters.

[Jun Omae]

A duplicate of #13200.