TypeError in sqlite_backend.py after installation

[sgtrc-turtle.testudo12@…]

Hello, I just installed TrashTalkPlugin version 0.11 from revision 3513 and received the following error after upgrading my trac environment:

Traceback (most recent call last):
  File "/Library/Python/2.3/site-packages/Trac-0.11stable_r7581-py2.3.egg/trac/web/api.py", line 367, in send_error
    'text/html')
  File "/Library/Python/2.3/site-packages/Trac-0.11stable_r7581-py2.3.egg/trac/web/chrome.py", line 690, in render_template
    stream |= self._filter_stream(req, method, filename, stream, data)
  File "build/bdist.darwin-8.10.0-Power_Macintosh/egg/genshi/core.py", line 128, in __or__
  File "/Library/Python/2.3/site-packages/Trac-0.11stable_r7581-py2.3.egg/trac/web/chrome.py", line 777, in inner
    data)
  File "build/bdist.darwin-8.10.0-Power_Macintosh/egg/trashtalk/trashtalk.py", line 102, in filter_stream
  File "build/bdist.darwin-8.10.0-Power_Macintosh/egg/trashtalk/trashtalk.py", line 203, in _get_incoming_links_for_ticket
  File "/Library/Python/2.3/site-packages/Trac-0.11stable_r7581-py2.3.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/Library/Python/2.3/site-packages/Trac-0.11stable_r7581-py2.3.egg/trac/db/sqlite_backend.py", line 56, in execute
    sql = sql % (('?',) * len(args))
TypeError: not all arguments converted during string formatting

The error occurred when I go to view any ticket.

Workaround

The only way that I could view my tickets was to uninstall the TrashTalkPlugin

Setup

• I had installed TrashTalkPlugin version 0.11 from revision 3513 with the following command:

  easy_install 'http://trac-hacks.org/svn/trashtalkplugin/0.11'
  

Environment

Here are some details on my environment, if it helps the developers

• OS: Mac OS X, Darwin 8.10.0
• Trac: Trac 0.11stable-r7581
• DB: sqlite

Here's the contents of my easy-install.pth file, which lists all of my installed plugins:

import sys; sys.__plen = len(sys.path)
./setuptools-0.6c7-py2.3.egg
./Genshi-0.5.1-py2.3-macosx-10.4-ppc.egg
./Trac-0.11stable_r7581-py2.3.egg
./TracFullBlogPlugin-0.1-py2.3.egg
./TracTags-0.6-py2.3.egg
./TracNewsFlash-1.0.1-py2.3.egg
./TracMacroPost-0.2-py2.3.egg
./TracAddCommentMacro-0.3-py2.3.egg
./TracTocMacro-11.0.0.3-py2.3.egg
./timingandestimationplugin-0.7.3-py2.3.egg
./TracTimeVisualizerPlugin-0.6-py2.3.egg
./TracWikiNotification-0.2.0-py2.3.egg
./TracBurndown-01.08.10-py2.3.egg
./TrashTalk-0.1-py2.3.egg
import sys; new=sys.path[sys.__plen:]; del sys.path[sys.__plen:]; p=getattr(sys,
'__egginsert',0); sys.path[p:p]=new; sys.__egginsert = p+len(new)

[Tim Coulter]

Hmm... At the time TrashTalk was written, it required Genshi trunk because of a Transformer class (or something very similar) that would help display the data on screen. This was before Trac 0.11 final, and at the time, the right version of Genshi was not distributed with Trac releases. Can you try installing Genshi trunk? Run the following command below:

easy_install ​http://svn.edgewall.org/repos/genshi/trunk/

Try that, and let me know what happens. Tim

[sgtrc-turtle.testudo12@…]

When I've got a chance for some downtime, I'll give that a shot and let you know if that does the trick.

In the meantime, I realized that I hadn't given my version of Python... we're using v. 2.3.5.