Modify

Opened 3 years ago

Last modified 15 months ago

#8837 new defect

does not work on 0.12

Reported by: yenik Owned by: framay
Priority: normal Component: BudgetingPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

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: ":"

Attachments (0)

Change History (9)

comment:1 Changed 3 years ago by 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

comment:2 Changed 3 years ago by framay

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?

comment:3 Changed 3 years ago by xeross

  • Trac Release changed from 0.11 to 0.12

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.

comment:4 Changed 3 years ago by anonymous

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

comment:5 Changed 3 years ago by framay

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

comment:6 Changed 2 years ago by anonymous

exactly the same error:-(

comment:7 Changed 2 years ago by 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, ...

comment:8 Changed 2 years ago by lfarkas

any other info needed?

comment:9 Changed 2 years ago by framay

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

Last edited 15 months ago by rjollos (previous) (diff)

Add Comment

Modify Ticket

Action
as new .
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.