exception on first click ...

[anonymous]

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

[dagomez]

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

[anonymous]

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

[Narno]

Same error with Trac 0.10.4 and Stractistics 0.2.1

Sorry Trac 0.10.3

[dagomez]

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

[j0k]

Yes we are using SQLite

[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'

[anonymous]

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

[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

[Ryan J Ollos]

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).