Modify

Opened 6 years ago

Closed 4 years ago

#2628 closed defect (wontfix)

exception on first click ...

Reported by: anonymous Owned by: dagomez
Priority: normal Component: StractisticsPlugin
Severity: normal Keywords:
Cc: jeremy.benoist@…, apedraz@… Trac Release: 0.10

Description

Traceback (most recent call last):
  File "/opt/csw/lib/python/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/opt/csw/lib/python/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.solaris-2.10-sun4u/egg/stractistics/stractistics.py", line 88, in process_request
    ticket_activity_query_response = self._ticket_activity(req.args)
  File "build/bdist.solaris-2.10-sun4u/egg/stractistics/stractistics.py", line 257, in _ticket_activity
    cursor.execute(sql_statement, [start_date])
  File "/opt/csw/lib/python/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/opt/csw/lib/python/site-packages/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/opt/csw/lib/python/site-packages/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: near "DISTINCT": syntax error

Attachments (0)

Change History (9)

comment:1 follow-up: Changed 6 years ago by dagomez

Hi,
I'd need more info.
What's your python version? Are you using sqlite as your Trac database?

comment:2 in reply to: ↑ 1 ; follow-up: Changed 6 years ago by anonymous

  • Cc jeremy.benoist@… added

Replying to dagomez:

Hi,
I'd need more info.
What's your python version? Are you using sqlite as your Trac database?

Same error with Trac 0.10.4 and Stractistics 0.2.1

Traceback (most recent call last):
  File "/var/lib/python-support/python2.4/trac/web/main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "/var/lib/python-support/python2.4/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/stractistics/stractistics.py", line 93, in process_request
  File "build/bdist.linux-i686/egg/stractistics/stractistics.py", line 267, in _ticket_activity
  File "/var/lib/python-support/python2.4/trac/db/util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 244, in execute
    self.rs = self.con.db.execute(SQL)
DatabaseError: near "DISTINCT": syntax error

comment:3 in reply to: ↑ 2 Changed 6 years ago by Narno

Same error with Trac 0.10.4 and Stractistics 0.2.1

Sorry Trac 0.10.3

comment:4 Changed 6 years ago by dagomez

Hi, could you tell me if you are using sqlite?

comment:5 Changed 6 years ago by j0k

Yes we are using SQLite

comment:6 follow-up: Changed 6 years ago by dagomez

Hi,

Please, run this inside an interpreter and check if the version numbers match.

>>> import trac.db.sqlite_backend as test
>>> test._ver
(3, 1, 3)
>>> test.have_pysqlite
2
>>> test.sqlite.version
'2.3.2'

comment:7 in reply to: ↑ 6 ; follow-up: Changed 6 years ago by anonymous

  • Cc apedraz@… added

Replying to dagomez:

Hi,

Please, run this inside an interpreter and check if the version numbers match.

>>> import trac.db.sqlite_backend as test
>>> test._ver
(3, 1, 3)
>>> test.have_pysqlite
2
>>> test.sqlite.version
'2.3.2'

The same problem for me:

#sqlite -version
2.8.17

comment:8 in reply to: ↑ 7 Changed 6 years ago by dagomez

Hi,
Sqlite 2.8.17 is a pretty old version so I'd suggest upgrading.
You can find good advice here: http://trac.edgewall.org/wiki/PySqlite


comment:9 Changed 4 years ago by rjollos

  • Resolution set to wontfix
  • Status changed from new to closed

0.10 version will no longer be supported. See trunk for a 0.11 version (trunk might have a 0.12 version shortly, in which case a 0.11 branch will be created).

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.