Replaced "Quest" with "Pest". See the timeline for modified pages.


  Oops…

*Trac detected an internal error:*

ProgrammingError: syntax error at or near "glob"
LINE 1: ... w2.max_version AND w1.name = w2.name AND w1.name glob E'Sha...
                                                             ^

This is probably a local installation issue.


...

    Python Traceback

Most recent call last:

  * File "build/bdist.linux-x86_64/egg/trac/web/main.py", line *522*, in
    _dispatch_request <#frame0>


          Code fragment:

    Line	
    517	try:
    518	if not env and env_error:
    519	raise HTTPInternalError(env_error)
    520	try:
    521	dispatcher = RequestDispatcher(env)
    522	dispatcher.dispatch(req)
    523	except RequestDone:
    524	pass
    525	resp = req._response or []
    526	 
    527	except HTTPException, e:


          Local variables:

    Name	Value
    dispatcher 	|<trac.web.main.RequestDispatcher object at
    0x2aaaabce8b90>|
    e 	|ProgrammingError('syntax error at or near "glob"\nLINE 1: ... ...|
    env 	|<trac.env.Environment object at 0x2aba3052dd90>|
    env_error 	|None|
    req 	|<Request "POST '/admin/general/wikireplace'">|
    resp 	|[]|

  * File "build/bdist.linux-x86_64/egg/trac/web/main.py", line *243*, in
    dispatch <#frame1>


          Code fragment:

    Line	
    238	msg = _('Do you have cookies enabled?')
    239	raise HTTPBadRequest(_('Missing or invalid form token.'
    240	' %(msg)s', msg=msg))
    241	 
    242	# Process the request and render the template
    243	resp = chosen_handler.process_request(req)
    244	if resp:
    245	if len(resp) == 2: # Clearsilver
    246	chrome.populate_hdf(req)
    247	template, content_type = \
    248	self._post_process_request(req, *resp)


          Local variables:

    Name	Value
    chosen_handler 	|<trac.admin.web_ui.AdminModule object at
    0x2aaaabce8b50>|
    chrome 	|<trac.web.chrome.Chrome object at 0x2aaaabce8310>|
    ctype 	|'application/x-www-form-urlencoded'|
    err 	|(<class 'psycopg2.ProgrammingError'>, ProgrammingError('syntax
    error at or ...|
    handler 	|<trac.admin.web_ui.AdminModule object at 0x2aaaabce8b50>|
    options 	|{}|
    req 	|<Request "POST '/admin/general/wikireplace'">|
    self 	|<trac.web.main.RequestDispatcher object at 0x2aaaabce8b90>|

  * File "build/bdist.linux-x86_64/egg/trac/admin/web_ui.py", line
    *117*, in process_request <#frame2>


          Code fragment:

    Line	
    112	if not provider:
    113	raise HTTPNotFound(_('Unknown administration panel'))
    114	 
    115	if hasattr(provider, 'render_admin_panel'):
    116	template, data = provider.render_admin_panel(req, cat_id, panel_id,
    117	path_info)
    118	 
    119	else: # support for legacy WebAdmin panels
    120	data = {}
    121	cstmpl, ct = provider.process_admin_request(req, cat_id, panel_id,
    122	path_info)


          Local variables:

    Name	Value
    _panel_order 	|<function _panel_order at 0x2aaaafe11c08>|
    cat_id 	|u'general'|
    panel_id 	|u'wikireplace'|
    panels 	|[('general', 'General', 'basics', 'Basic Settings'),
    ('general', ...|
    path_info 	|None|
    provider 	|<wikireplace.web_ui.WikiReplaceModule object at
    0x2aaaabcf5050>|
    providers 	|{('ticket', 'customfields'): ...|
    req 	|<Request "POST '/admin/general/wikireplace'">|
    self 	|<trac.admin.web_ui.AdminModule object at 0x2aaaabce8b50>|

  * File "build/bdist.linux-x86_64/egg/wikireplace/web_ui.py", line
    *61*, in render_admin_panel <#frame3>


          Code fragment:

    Line	
    56	# Replace the text if the find and wikipages fields have been input.
    57	if data['find'] and data['wikipages'] and data['wikipages'][0]:
    58	add_notice(req, 'Replaced "%s" with "%s". See the timeline for
    modified pages.'
    59	% (data['find'], data['replace']))
    60	wiki_text_replace(self.env, data['find'], data['replace'],
    data['wikipages'],
    61	req.authname, req.remote_addr, debug=self.log.debug)
    62	
    63	# Reset for the next display
    64	data['find'] = ''
    65	data['replace'] = ''
    66	data['wikipages'] = ''


          Local variables:

    Name	Value
    cat 	|u'general'|
    data 	|{'redir': False, 'wikipages': [u'Shareplex'], 'find':
    u'Quest', 'replace': ...|
    page 	|u'wikireplace'|
    parts 	|[u'Shareplex']|
    path_info 	|None|
    req 	|<Request "POST '/admin/general/wikireplace'">|
    self 	|<wikireplace.web_ui.WikiReplaceModule object at 0x2aaaabcf5050>|
    wikipages 	|u'Shareplex'|

  * File "build/bdist.linux-x86_64/egg/wikireplace/util.py", line *69*,
    in wiki_text_replace <#frame4>


          Code fragment:

    Line	
    64	
    65	for wikipage in wikipages:
    66	sql = 'SELECT w1.version,w1.name,w1.text' + sqlbase + 'AND
    w1.name glob %s AND w1.text like %s'
    67	debug('Running query %r', sql)
    68	 
    69	cursor.execute(sql, (wikipage, '%'+oldtext+'%'))
    70	 
    71	for row in list(cursor):
    72	debug("Found a page with searched text in it: %s (v%s)", row[1],
    row[0])
    73	newcontent = re.sub(oldtext,newtext,row[2])
    74	 


          Local variables:

    Name	Value
    cursor 	|<trac.db.util.IterableCursor object at 0x2aaaaebf4d90>|
    db 	|<trac.db.pool.PooledConnection object at 0x2aaaaef0e3c0>|
    debug 	|<function out at 0x2aaaafe11d70>|
    env 	|<trac.env.Environment object at 0x2aba3052dd90>|
    handle_commit 	|True|
    ip 	|'127.0.0.1'|
    newtext 	|u'Pest'|
    oldtext 	|u'Quest'|
    sql 	|'SELECT w1.version,w1.name,w1.text FROM wiki w1, (SELECT name,
    ...|
    sqlbase 	|' FROM wiki w1, (SELECT name, MAX(version) AS max_version
    FROM wiki GROUP ...|
    user 	|u'hoff022'|
    wikipage 	|u'Shareplex'|
    wikipages 	|[u'Shareplex']|

  * File "build/bdist.linux-x86_64/egg/trac/db/util.py", line *65*, in
    execute <#frame5>


          Code fragment:

    Line	
    60	return r
    61	except Exception, e:
    62	self.log.debug('execute exception: %r', e)
    63	raise
    64	if args:
    65	return self.cursor.execute(sql_escape_percent(sql), args)
    66	return self.cursor.execute(sql)
    67	 
    68	def executemany(self, sql, args):
    69	if self.log:
    70	self.log.debug('SQL: %r', sql)


          Local variables:

    Name	Value
    args 	|(u'Shareplex', u'%Quest%')|
    self 	|<trac.db.util.IterableCursor object at 0x2aaaaebf4d90>|
    sql 	|'SELECT w1.version,w1.name,w1.text FROM wiki w1, (SELECT name,
    ...|

File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 522, in _dispatch_request
  dispatcher.dispatch(req)
File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 243, in dispatch
  resp = chosen_handler.process_request(req)
File "build/bdist.linux-x86_64/egg/trac/admin/web_ui.py", line 117, in process_request
  path_info)
File "build/bdist.linux-x86_64/egg/wikireplace/web_ui.py", line 61, in render_admin_panel
  req.authname, req.remote_addr, debug=self.log.debug)
File "build/bdist.linux-x86_64/egg/wikireplace/util.py", line 69, in wiki_text_replace
  cursor.execute(sql, (wikipage, '%'+oldtext+'%'))
File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 65, in execute
  return self.cursor.execute(sql_escape_percent(sql), args)


    System Information:

Trac 	0.12.3
Genshi 	0.6
psycopg2 	2.0.8
Pygments 	0.11.1
Python 	2.5.2 (r252:60911, Oct 23 2008, 08:46:37) [GCC 4.1.2 20070115
(SUSE Linux)]
setuptools 	0.6c9
Subversion 	1.6.6 (r40053)


    Enabled Plugins:

BackLinks 	N/A 	/PDIS/users/ggXXXsvn/trac_root/doc/plugins/BackLinks.pyc
BreadCrumbsNavPlugin
<http://trac-hacks.org/wiki/BreadCrumbsNavPlugin> 	0.1
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/BreadCrumbsNavPlugin-0.1-py2.5.egg

cctoolslink 	N/A 	/PDIS/users/ggXXXsvn/trac_base/plugins/cctoolslink.pyc
graphviz <http://trac-hacks.org/wiki/GraphvizPlugin> 	0.7.6t8dev
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/graphviz-0.7.6t8dev-py2.5.egg

IncludeSource 	N/A
/PDIS/users/ggXXXsvn/trac_root/fiasng/plugins/IncludeSource.pyc
msdoc 	N/A 	/PDIS/users/ggXXXsvn/trac_root/doc/plugins/msdoc.pyc
PageToDoc <mailto:lucas.eisenzimmer@t-systems-mms.com> 	0.2e
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/PageToDoc-0.2e-py2.5.egg

techdocs 	N/A 	/PDIS/users/ggXXXsvn/trac_base/plugins/techdocs.pyc
TracAccountManager <http://trac-hacks.org/wiki/AccountManagerPlugin>
0.2.1dev-r4698
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracAccountManager-0.2.1dev_r4698-py2.5.egg

TracCodeReview <http://trac-hacks.org/wiki/PeerReviewPlugin>
2.2-devdev-r3854
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracCodeReview-2.2_devdev_r3854-py2.5.egg

TracCustomFieldAdmin
<http://trac-hacks.org/wiki/CustomFieldAdminPlugin> 	0.2
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracCustomFieldAdmin-0.2-py2.5.egg

TracExcelViewer <http://trac-hacks.swapoff.org/wiki/ExcelViewer> 	0.1b
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracExcelViewer-0.1b-py2.5.egg

TracFilenameSearch <http://trac-hacks.org/wiki/FilenameSearchPlugin>
1.1
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracFilenameSearch-1.1-py2.5.egg

TracPrivateTickets <http://trac-hacks.org/wiki/PrivateTicketsPlugin>
2.0.2
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracPrivateTickets-2.0.2-py2.5.egg

TracSectionEditPlugin <http://code.optaros.com/trac/oforge> 	0.2.6
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracSectionEditPlugin-0.2.6-py2.5.egg

TracTags <http://trac-hacks.org/wiki/TagsPlugin> 	0.6
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracTags-0.6-py2.5.egg
TracTocMacro <http://trac-hacks.org/wiki/TocMacro> 	11.0.0.3
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracTocMacro-11.0.0.3-py2.5.egg

TracWikiReplace <http://trac-hacks.org/wiki/WikiReplacePlugin> 	1.1.1
/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracWikiReplace-1.1.1-py2.5.egg
<#frame4>