does not work on 0.12

[yenik]

precompiled egg installed via GUI does not work. It gets installed, but when I try to display existing ticket, it throws following error :

Trac detected an internal error:

OperationalError: unrecognized token: ":"

[anonymous]

Most recent call last:

File "build/bdist.linux-i686/egg/trac/web/main.py", line 511, in _dispatch_request
  dispatcher.dispatch(req)
File "build/bdist.linux-i686/egg/trac/web/main.py", line 258, in dispatch
  content_type)
File "build/bdist.linux-i686/egg/trac/web/chrome.py", line 840, in render_template
  stream |= self._filter_stream(req, method, filename, stream, data)
File "build/bdist.macosx-10.6-universal/egg/genshi/core.py", line 132, in __or__
  return Stream(_ensure(function(self)), serializer=self.serializer)
File "build/bdist.linux-i686/egg/trac/web/chrome.py", line 991, in inner
  data)
File "build/bdist.win32/egg/ticketbudgeting/ticketbudgeting.py", line 286, in filter_stream
  self.create_table()
File "build/bdist.win32/egg/ticketbudgeting/ticketbudgeting.py", line 739, in create_table
  self.create_reports()
File "build/bdist.win32/egg/ticketbudgeting/ticketbudgeting.py", line 762, in create_reports
  raise e

[Franz]

This occurs when creating default report (see ​http://trac-hacks.org/browser/budgetingplugin/0.12/ticketbudgeting/ticketbudgeting.py#L741); there should be some more log-infos. This might be probably an encoding problem.

Are you using Trac 0.12 or 0.11? Have you tried to compile it yourself?

[Xeross]

I'm experiencing the same problem, I compiled Trac and BudgetingPlugin myself.

I'll look into the logs tomorrow, as I'm out of time now.

[anonymous]

Any news on a fix for this? Or a workaround?

[Franz]

No news, as I don't know what exactly the problem is. There might be a few issues, which might cuase the problem:

• if you you use Python 2.4 or 2.5 it might not be compiled or installed, see #8839
• in the SQL statement is an German umlaut, which migh cause some problems, see #9517; if you remove the words with umlauts, it might work

Note that there is already a discussion going on how to solve localized reports, see ​Google-Groups

[anonymous]

exactly the same error:-(

[anonymous]

rhel-6.3 :

Trac	0.12.3
Babel	0.9.4
Genshi	0.6
mod_python	3.3.1
pysqlite	2.4.1
Python	2.6.6 (r266:84292, Jun 18 2012, 21:49:31) [GCC 4.4.6 20110731 (Red Hat 4.4.6-3)]
pytz	2010h
setuptools	0.6
SQLite	3.6.20
Subversion	1.6.11 (r934486)
jQuery	1.4.2

python-2.6.6-29.el6_2.2.x86_64
trac-0.12.3-3.el6.noarch
httpd-2.2.15-15.el6_2.1.x86_64

and the error:

File "/usr/lib/python2.6/site-packages/trac/web/main.py", line 525, in _dispatch_request
File "/usr/lib/python2.6/site-packages/trac/web/main.py", line 267, in dispatch
File "/usr/lib/python2.6/site-packages/trac/web/chrome.py", line 841, in render_template
File "/usr/lib/python2.6/site-packages/Genshi-0.6-py2.6.egg/genshi/core.py", line 132, in __or__
File "/usr/lib/python2.6/site-packages/trac/web/chrome.py", line 997, in inner
File "/usr/lib/python2.6/site-packages/ticketbudgeting/ticketbudgeting.py", line 287, in filter_stream
File "/usr/lib/python2.6/site-packages/ticketbudgeting/ticketbudgeting.py", line 759, in create_table
File "/usr/lib/python2.6/site-packages/ticketbudgeting/ticketbudgeting.py", line 782, in create_reports

Code fragment:

Line	
777	                db.commit()
778	                self.log.info("[INIT reports] successfully created report with id %s" % report[0])
779	            except Exception, e:
780	                self.log.error("[INIT reports] Error executing SQL Statement \n %s" % e)
781	                db.rollback();
782	                raise e
783	            finally:
784	                db.close()
785	 
786	                    
787	    def get_col_list(self, ignore_cols=None):

Local variables:

Name	Value
db	<trac.db.pool.PooledConnection object at 0x7f6febbe5d70>
descr	u'report_description_90'
e	OperationalError('near ".": syntax error',)
myCursor	<trac.db.util.IterableCursor object at 0x7f6febc2bbd0>
report	(90, 'report_title_90', 'report_description_90', u'SELECT t.id, t.summary, ...
self	<ticketbudgeting.ticketbudgeting.TicketBudgetingView object at ...
sql	u'INSERT INTO report (id, author, title, query, description)  VALUES(90, ...

[Levente Farkas]

any other info needed?

[Franz]

Sorry, no idea. I just guess it is because of using SQLite. We use the latest BudgetingPlugin with postgres 8.4, Trac 1.0, and Python 2.6.5. In that environment it works fine.

For Trac 0.12 please use Budgeting_Plugin-0.5.a4-py2.6.egg:wiki:BudgetingPlugin or build it from source by using 0.12-tag​

[Ryan J Ollos]

The minimum requirement for the latest BudgetingPlugin is Trac 1.0.

There are some remaining string interpolation issues on SQL statements, which will be fixed in #9517.