Ticket #10864: error.txt

File error.txt, 9.9 KB (added by hopfrog@…, 4 years ago)

Python trackback & system information

Line 
1Replaced "Quest" with "Pest". See the timeline for modified pages.
2
3
4  Oops…
5
6*Trac detected an internal error:*
7
8ProgrammingError: syntax error at or near "glob"
9LINE 1: ... w2.max_version AND w1.name = w2.name AND w1.name glob E'Sha...
10                                                             ^
11
12This is probably a local installation issue.
13
14
15...
16
17    Python Traceback
18
19Most recent call last:
20
21  * File "build/bdist.linux-x86_64/egg/trac/web/main.py", line *522*, in
22    _dispatch_request <#frame0>
23
24
25          Code fragment:
26
27    Line   
28    517 try:
29    518 if not env and env_error:
30    519 raise HTTPInternalError(env_error)
31    520 try:
32    521 dispatcher = RequestDispatcher(env)
33    522 dispatcher.dispatch(req)
34    523 except RequestDone:
35    524 pass
36    525 resp = req._response or []
37    526 
38    527 except HTTPException, e:
39
40
41          Local variables:
42
43    Name    Value
44    dispatcher  |<trac.web.main.RequestDispatcher object at
45    0x2aaaabce8b90>|
46    e   |ProgrammingError('syntax error at or near "glob"\nLINE 1: ... ...|
47    env     |<trac.env.Environment object at 0x2aba3052dd90>|
48    env_error   |None|
49    req     |<Request "POST '/admin/general/wikireplace'">|
50    resp    |[]|
51
52  * File "build/bdist.linux-x86_64/egg/trac/web/main.py", line *243*, in
53    dispatch <#frame1>
54
55
56          Code fragment:
57
58    Line   
59    238 msg = _('Do you have cookies enabled?')
60    239 raise HTTPBadRequest(_('Missing or invalid form token.'
61    240 ' %(msg)s', msg=msg))
62    241 
63    242 # Process the request and render the template
64    243 resp = chosen_handler.process_request(req)
65    244 if resp:
66    245 if len(resp) == 2: # Clearsilver
67    246 chrome.populate_hdf(req)
68    247 template, content_type = \
69    248 self._post_process_request(req, *resp)
70
71
72          Local variables:
73
74    Name    Value
75    chosen_handler  |<trac.admin.web_ui.AdminModule object at
76    0x2aaaabce8b50>|
77    chrome  |<trac.web.chrome.Chrome object at 0x2aaaabce8310>|
78    ctype   |'application/x-www-form-urlencoded'|
79    err     |(<class 'psycopg2.ProgrammingError'>, ProgrammingError('syntax
80    error at or ...|
81    handler     |<trac.admin.web_ui.AdminModule object at 0x2aaaabce8b50>|
82    options     |{}|
83    req     |<Request "POST '/admin/general/wikireplace'">|
84    self    |<trac.web.main.RequestDispatcher object at 0x2aaaabce8b90>|
85
86  * File "build/bdist.linux-x86_64/egg/trac/admin/web_ui.py", line
87    *117*, in process_request <#frame2>
88
89
90          Code fragment:
91
92    Line   
93    112 if not provider:
94    113 raise HTTPNotFound(_('Unknown administration panel'))
95    114 
96    115 if hasattr(provider, 'render_admin_panel'):
97    116 template, data = provider.render_admin_panel(req, cat_id, panel_id,
98    117 path_info)
99    118 
100    119 else: # support for legacy WebAdmin panels
101    120 data = {}
102    121 cstmpl, ct = provider.process_admin_request(req, cat_id, panel_id,
103    122 path_info)
104
105
106          Local variables:
107
108    Name    Value
109    _panel_order    |<function _panel_order at 0x2aaaafe11c08>|
110    cat_id  |u'general'|
111    panel_id    |u'wikireplace'|
112    panels  |[('general', 'General', 'basics', 'Basic Settings'),
113    ('general', ...|
114    path_info   |None|
115    provider    |<wikireplace.web_ui.WikiReplaceModule object at
116    0x2aaaabcf5050>|
117    providers   |{('ticket', 'customfields'): ...|
118    req     |<Request "POST '/admin/general/wikireplace'">|
119    self    |<trac.admin.web_ui.AdminModule object at 0x2aaaabce8b50>|
120
121  * File "build/bdist.linux-x86_64/egg/wikireplace/web_ui.py", line
122    *61*, in render_admin_panel <#frame3>
123
124
125          Code fragment:
126
127    Line   
128    56  # Replace the text if the find and wikipages fields have been input.
129    57  if data['find'] and data['wikipages'] and data['wikipages'][0]:
130    58  add_notice(req, 'Replaced "%s" with "%s". See the timeline for
131    modified pages.'
132    59  % (data['find'], data['replace']))
133    60  wiki_text_replace(self.env, data['find'], data['replace'],
134    data['wikipages'],
135    61  req.authname, req.remote_addr, debug=self.log.debug)
136    62 
137    63  # Reset for the next display
138    64  data['find'] = ''
139    65  data['replace'] = ''
140    66  data['wikipages'] = ''
141
142
143          Local variables:
144
145    Name    Value
146    cat     |u'general'|
147    data    |{'redir': False, 'wikipages': [u'Shareplex'], 'find':
148    u'Quest', 'replace': ...|
149    page    |u'wikireplace'|
150    parts   |[u'Shareplex']|
151    path_info   |None|
152    req     |<Request "POST '/admin/general/wikireplace'">|
153    self    |<wikireplace.web_ui.WikiReplaceModule object at 0x2aaaabcf5050>|
154    wikipages   |u'Shareplex'|
155
156  * File "build/bdist.linux-x86_64/egg/wikireplace/util.py", line *69*,
157    in wiki_text_replace <#frame4>
158
159
160          Code fragment:
161
162    Line   
163    64 
164    65  for wikipage in wikipages:
165    66  sql = 'SELECT w1.version,w1.name,w1.text' + sqlbase + 'AND
166    w1.name glob %s AND w1.text like %s'
167    67  debug('Running query %r', sql)
168    68   
169    69  cursor.execute(sql, (wikipage, '%'+oldtext+'%'))
170    70   
171    71  for row in list(cursor):
172    72  debug("Found a page with searched text in it: %s (v%s)", row[1],
173    row[0])
174    73  newcontent = re.sub(oldtext,newtext,row[2])
175    74   
176
177
178          Local variables:
179
180    Name    Value
181    cursor  |<trac.db.util.IterableCursor object at 0x2aaaaebf4d90>|
182    db  |<trac.db.pool.PooledConnection object at 0x2aaaaef0e3c0>|
183    debug   |<function out at 0x2aaaafe11d70>|
184    env     |<trac.env.Environment object at 0x2aba3052dd90>|
185    handle_commit   |True|
186    ip  |'127.0.0.1'|
187    newtext     |u'Pest'|
188    oldtext     |u'Quest'|
189    sql     |'SELECT w1.version,w1.name,w1.text FROM wiki w1, (SELECT name,
190    ...|
191    sqlbase     |' FROM wiki w1, (SELECT name, MAX(version) AS max_version
192    FROM wiki GROUP ...|
193    user    |u'hoff022'|
194    wikipage    |u'Shareplex'|
195    wikipages   |[u'Shareplex']|
196
197  * File "build/bdist.linux-x86_64/egg/trac/db/util.py", line *65*, in
198    execute <#frame5>
199
200
201          Code fragment:
202
203    Line   
204    60  return r
205    61  except Exception, e:
206    62  self.log.debug('execute exception: %r', e)
207    63  raise
208    64  if args:
209    65  return self.cursor.execute(sql_escape_percent(sql), args)
210    66  return self.cursor.execute(sql)
211    67   
212    68  def executemany(self, sql, args):
213    69  if self.log:
214    70  self.log.debug('SQL: %r', sql)
215
216
217          Local variables:
218
219    Name    Value
220    args    |(u'Shareplex', u'%Quest%')|
221    self    |<trac.db.util.IterableCursor object at 0x2aaaaebf4d90>|
222    sql     |'SELECT w1.version,w1.name,w1.text FROM wiki w1, (SELECT name,
223    ...|
224
225File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 522, in _dispatch_request
226  dispatcher.dispatch(req)
227File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 243, in dispatch
228  resp = chosen_handler.process_request(req)
229File "build/bdist.linux-x86_64/egg/trac/admin/web_ui.py", line 117, in process_request
230  path_info)
231File "build/bdist.linux-x86_64/egg/wikireplace/web_ui.py", line 61, in render_admin_panel
232  req.authname, req.remote_addr, debug=self.log.debug)
233File "build/bdist.linux-x86_64/egg/wikireplace/util.py", line 69, in wiki_text_replace
234  cursor.execute(sql, (wikipage, '%'+oldtext+'%'))
235File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 65, in execute
236  return self.cursor.execute(sql_escape_percent(sql), args)
237
238
239    System Information:
240
241Trac    0.12.3
242Genshi  0.6
243psycopg2    2.0.8
244Pygments    0.11.1
245Python  2.5.2 (r252:60911, Oct 23 2008, 08:46:37) [GCC 4.1.2 20070115
246(SUSE Linux)]
247setuptools  0.6c9
248Subversion  1.6.6 (r40053)
249
250
251    Enabled Plugins:
252
253BackLinks   N/A     /PDIS/users/ggXXXsvn/trac_root/doc/plugins/BackLinks.pyc
254BreadCrumbsNavPlugin
255<http://trac-hacks.org/wiki/BreadCrumbsNavPlugin>   0.1
256/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/BreadCrumbsNavPlugin-0.1-py2.5.egg
257
258cctoolslink     N/A     /PDIS/users/ggXXXsvn/trac_base/plugins/cctoolslink.pyc
259graphviz <http://trac-hacks.org/wiki/GraphvizPlugin>    0.7.6t8dev
260/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/graphviz-0.7.6t8dev-py2.5.egg
261
262IncludeSource   N/A
263/PDIS/users/ggXXXsvn/trac_root/fiasng/plugins/IncludeSource.pyc
264msdoc   N/A     /PDIS/users/ggXXXsvn/trac_root/doc/plugins/msdoc.pyc
265PageToDoc <mailto:lucas.eisenzimmer@t-systems-mms.com>  0.2e
266/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/PageToDoc-0.2e-py2.5.egg
267
268techdocs    N/A     /PDIS/users/ggXXXsvn/trac_base/plugins/techdocs.pyc
269TracAccountManager <http://trac-hacks.org/wiki/AccountManagerPlugin>
2700.2.1dev-r4698
271/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracAccountManager-0.2.1dev_r4698-py2.5.egg
272
273TracCodeReview <http://trac-hacks.org/wiki/PeerReviewPlugin>
2742.2-devdev-r3854
275/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracCodeReview-2.2_devdev_r3854-py2.5.egg
276
277TracCustomFieldAdmin
278<http://trac-hacks.org/wiki/CustomFieldAdminPlugin>     0.2
279/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracCustomFieldAdmin-0.2-py2.5.egg
280
281TracExcelViewer <http://trac-hacks.swapoff.org/wiki/ExcelViewer>    0.1b
282/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracExcelViewer-0.1b-py2.5.egg
283
284TracFilenameSearch <http://trac-hacks.org/wiki/FilenameSearchPlugin>
2851.1
286/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracFilenameSearch-1.1-py2.5.egg
287
288TracPrivateTickets <http://trac-hacks.org/wiki/PrivateTicketsPlugin>
2892.0.2
290/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracPrivateTickets-2.0.2-py2.5.egg
291
292TracSectionEditPlugin <http://code.optaros.com/trac/oforge>     0.2.6
293/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracSectionEditPlugin-0.2.6-py2.5.egg
294
295TracTags <http://trac-hacks.org/wiki/TagsPlugin>    0.6
296/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracTags-0.6-py2.5.egg
297TracTocMacro <http://trac-hacks.org/wiki/TocMacro>  11.0.0.3
298/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracTocMacro-11.0.0.3-py2.5.egg
299
300TracWikiReplace <http://trac-hacks.org/wiki/WikiReplacePlugin>  1.1.1
301/PDIS/users/ggXXXsvn/opt/lib/python2.5/site-packages/TracWikiReplace-1.1.1-py2.5.egg
302<#frame4>
303
304