Edgewall Software
Modify

Opened 14 years ago

Closed 14 years ago

Last modified 13 years ago

#2879 closed defect (worksforme)

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

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:

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

Attachments (0)

Change History (3)

comment:1 by anonymous, 14 years ago

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

comment:2 by Christopher Lenz, 14 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.

comment:3 by Christian Boos, 14 years ago

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain daniel.
The resolution will be deleted. Next status will be 'reopened'.
to as closed The owner will be changed from daniel to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.