Modify

Opened 8 years ago

Closed 8 years ago

Last modified 3 years ago

#4143 closed defect (fixed)

OperationalError: (1054, "Unknown column 'started' in 'field list'")

Reported by: alex Owned by: daan
Priority: normal Component: ScrumBurndownPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description (last modified by Ryan J Ollos)

How to Reproduce
While doing a GET operation on /burndown, Trac issued an internal error. 

probably has something to do with the TestingWorkflow? plugin: http://trac-hacks.org/wiki/TestingWorkflow 

Request parameters: 

{'selected_component': u'All Components',
 'selected_milestone': u'Site beta version launch',
 'start': u'Start Milestone'}
User Agent was: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648) 

System Information
Trac  0.11.2.1  
Python  2.5.1 (r251:54863, Dec 7 2007, 23:58:55) 
[GCC 4.2.1 20070719 [FreeBSD]]  
setuptools  0.6c5  
MySQL  server: "5.1.22-rc", client: "5.1.22-rc", thread-safe: 1  
MySQLdb  1.2.2  
Genshi  0.6dev-r960  
mod_python  3.3.1  
Subversion  1.4.4 (r25188)  
jQuery:  1.2.6  

Python Traceback

Attachments (0)

Change History (4)

comment:1 Changed 8 years ago by alex

forgot the traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.2.1-py2.5.egg/trac/web/main.py
Last edited 3 years ago by Ryan J Ollos (previous) (diff)

comment:2 Changed 8 years ago by daan

Status: newassigned

Hi Alex,

It looks like your milestone table does not have the 'started' column. Create this column by executing the following commands:

First, backup your SQLite database!

Open your Trac database with SQLite (execute 'sqlite3 trac.db')

Execute the following SQL commands:

CREATE TEMP TABLE milestone_old AS SELECT * FROM milestone;
DROP TABLE milestone;
CREATE TABLE milestone (
                 name            text PRIMARY KEY,
                 due             integer,
                 completed       integer,
                 started        integer,
                 description     text
        );
INSERT INTO milestone(name,due,completed,started,description)
        SELECT name,due,completed,0,description FROM milestone_old;

Let me know if it works..

comment:3 Changed 8 years ago by daan

Resolution: fixed
Status: assignedclosed

Please reopen if this problem persists.

comment:4 Changed 3 years ago by Ryan J Ollos

Description: modified (diff)

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain daan.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.