Error Message: Failed to create environment. You can only execute one statement at a time.

[hobbeston@…]

My configuration:

• trac: 0.9.4
• sqlite: 2.8.17
• pysqlite: 2.0.5
• clearsilver: 0.10.1
• Python: 2.4.2
• svn: 1.3.0

I get the following error when initializing an environment:

Creating and Initializing Project
Failed to create environment. You can only execute one statement at a time.
Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/scripts/admin.py", line 139, in env_create
    self.__env = Environment(self.envname, create=True, db_str=db_str)
  File "/usr/lib/python2.4/site-packages/trac/env.py", line 79, in __init__
    self.create(db_str)
  File "/usr/lib/python2.4/site-packages/trac/env.py", line 197, in create
    db.init_db(self.path, db_str)
  File "/usr/lib/python2.4/site-packages/trac/db.py", line 442, in init_db
    cls.init_db(**args)
  File "/usr/lib/python2.4/site-packages/trac/db.py", line 326, in init_db
    cursor.execute(stmt)
Warning: You can only execute one statement at a time.
Failed to initialize environment. 1
Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/scripts/admin.py", line 594, in do_initenv
    self.env_create(db_str)
  File "/usr/lib/python2.4/site-packages/trac/scripts/admin.py", line 144, in env_create
    sys.exit(1)
SystemExit: 1

[anonymous]

I get the same message Any fixes? will it help to install another version?

[Christopher Lenz]

(The combination sqlite: 2.8.17 and pysqlite: 2.0.5 is invalid, because pysqlite 2.x doesn't support sqlite < 3.x.)

I've seen this error when using PySQLite 2.1.x with SQLite 3.2.x.

If you're using PySQLite ≥ 2.1.x, then please make sure you're using SQLite ≥ 3.3.x. If you're using PySQLite 2.1.x, then please make sure you're using SQLite < 3.3.x.

[Christian Boos]

Well, see also my comment on #2993.

I've run pysqlite-2.1.3 with sqlite 3.2.8 without any problems. It's more likely a mismatch like I describe on the above ticket.