"tracd --port 8000 /project" on CentOS5

[radek@…]

Hello guys,

After I create the trac project "test", I execute the command "tracd —port 8000 /repo/trac/test" at the terminal, then I write down the adress "​http://127.0.1.1:8000/test" in the AD bar, but It shows in the web page as below:

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/web/api.py", line 377, in send_error
    'text/html')
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/web/chrome.py", line 725, in render_template
    req.chrome[type_].append(
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/web/api.py", line 195, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/web/chrome.py", line 489, in prepare_request
    for category, name, text in contributor.get_navigation_items(req):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/ticket/web_ui.py", line 163, in get_navigation_items
    if 'TICKET_CREATE' in req.perm:
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/perm.py", line 524, in has_permission
    return self._has_permission(action, resource)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/perm.py", line 537, in _has_permission
    decision = PermissionSystem(self.env). \
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/perm.py", line 425, in check_permission
    perm)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/perm.py", line 281, in check_permission
    permissions = PermissionSystem(self.env). \
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/perm.py", line 357, in get_user_permissions
    for perm in self.store.get_user_permissions(username):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/perm.py", line 175, in get_user_permissions
    cursor.execute("SELECT username,action FROM permission")
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/db/util.py", line 60, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
Warning: You can only execute one statement at a time. 

Any ideas? I need your help. I have: Trac-0.11.5-py2.4.egg, Genshi-0.5.1-py2.4-linux-i686.egg, Setuptools-0.6c9-py2.4.egg, Python2.4, Pysqlite2 installed.

Many Thanks

[Christian Boos]

Which version of PySqlite and SQLite?

See the /about page as TRAC_ADMIN if you don't know.

[anonymous]

PySqlite: pysqlite-2.3.5.tar.gz SQLite: sqlite-3.6.16

[Christian Boos]

• PySqlite 2.3.5 is a bit old, try latest 2.5.5.
• SQLite 3.6.16 is the latest - hope it's not a new incompatibility ;-)

Looking at other tickets reporting a similar issue, it might still be possible that you're using a different PySqlite version than the one you think you're using (that's why it's important to check what Trac is really using, see the /about page as said above or PySqlite#DetermineactualSQLiteandPySqliteversion).

So this ticket is likely a duplicate of #2993.

See also ticket:2719#comment:12.

[radek@…]

Hi again,

I have tested the version of PySqlite what Python installation uses and the version of SQLite linked:

Python 2.4.3 (#1, Jan 21 2009, 01:10:13)
[GCC 4.1.2 20071124 (Red Hat 4.1.2-42)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite
>>> sqlite.version
'1.1.7'
>>> sqlite._sqlite.sqlite_version()
'3.3.6'
>>> import trac.db.sqlite_backend as test
>>> test._ver
(3, 3, '6')
>>> test.have_pysqlite
2
>>> test.sqlite.version
'2.0.5'

[Christian Boos]

Ah, great. So this is exactly the situation described in ticket:2719#comment:12.