Error trying to use new search page @3763

[trac@…]

How to Reproduce

While doing a POST operation on /peerReviewSearch, Trac issued an internal error.

I just visited the search page and hit search without changing/setting any values.

Request parameters:

{ Author : u Select... ,
  CodeReviewName : u  ,
  DateDay : u 0 ,
  DateDay1 : u 0 ,
  DateMonth : u 0 ,
  DateYear : u 0 ,
  Status : u Select... ,
  __FORM_TOKEN : u 3afa1c986e7def43b3105137 ,
  doSearch : u yes }

User Agent was: Mozilla/5.0 Windows; U; Windows NT 5.2; en-US; rv:1.9 Gecko/2008051206 Firefox/3.0

System Information

Trac	0.11dev-r6750
Python	2.5.1 r251:54863, Apr 18 2007, 08:51:08 MSC v.1310 32 bit Intel
setuptools	0.6c7
SQLite	3.5.2
pysqlite	2.4.0
Genshi	0.5dev-r809
mod_python	3.3.1
Pygments	0.9
Subversion	1.4.6 r28521
jQuery:	1.2.3

Python Traceback

Traceback  most recent call last :
  File  c: python25 lib site-packages trac-0.11dev_r6750-py2.5.egg trac web main.py , line 417, in _dispatch_request
    dispatcher.dispatch req 
  File  c: python25 lib site-packages trac-0.11dev_r6750-py2.5.egg trac web main.py , line 197, in dispatch
    resp   chosen_handler.process_request req 
  File  build bdist.win32 egg codereview peerReviewSearch.py , line 48, in process_request
    results   self.performSearch req ;
  File  build bdist.win32 egg codereview peerReviewSearch.py , line 163, in performSearch
    results   dbBack.searchCodeReviews crStruct 
  File  build bdist.win32 egg codereview dbBackend.py , line 85, in searchCodeReviews
    query   query    Author LIKE  %%s%  AND Status LIKE  %%s%  AND DateCreate >   %s   %  crStruct.Author, crStruct.Status, crStruct.DateCreate 
ValueError: unsupported format character      0x27  at index 17

[Sebastian Marek]

That's been fixed in 2.1-toddler. I've now merged those changes to 0.11 branch and trunk

[anonymous]

are you sure? I'll double check again tonight but I was still able to repro on the latest 2.1-toddler

[anonymous]

I've just re-installed plugin straight from svn (2.1-toddler) and it seems to work fine. Can you give me the full backtrace please?

[anonymous]

I must have not restarted the web server - sorry about that. It does seem to be working fine today.