Edgewall Software

Opened 18 years ago

Closed 18 years ago

Last modified 17 years ago

#2879 closed defect (worksforme)

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

Reported by: hobbeston@… Owned by: daniel
Priority: highest Milestone:
Component: admin/console Version: 0.9.4
Severity: critical Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Christopher Lenz)

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

Change History (2)

comment:1 by anonymous, 18 years ago

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

comment:2 by Christopher Lenz, 18 years ago

Description: modified (diff)
Resolution: worksforme
Status: newclosed

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

Note: See TracTickets for help on using tickets.