Trac detected an internal error after upgrade from .84 to .9-beta1

[anonymous]

After I upgraded from a working install, I run trac-admin upgrade and track-admin wiki upgrade. Restarted the apache. My trac install came up just fine, however when I got to the Tickets area I get an internal error.

Here is the error:

Traceback (most recent call last):
  File "C:\Python23\Lib\site-packages\trac\web\modpython_frontend.py", line 205, in handler
    dispatch_request(mpr.path_info, mpr, env)
  File "C:\Python23\Lib\site-packages\trac\web\main.py", line 139, in dispatch_request
    dispatcher.dispatch(req)
  File "C:\Python23\Lib\site-packages\trac\web\main.py", line 107, in dispatch
    resp = chosen_handler.process_request(req)
  File "C:\Python23\Lib\site-packages\trac\ticket\web_ui.py", line 62, in process_request
    ticket = Ticket(self.env, db=db)
  File "C:\Python23\Lib\site-packages\trac\ticket\model.py", line 33, in __init__
    self.fields = TicketSystem(self.env).get_ticket_fields()
  File "C:\Python23\Lib\site-packages\trac\ticket\api.py", line 88, in get_ticket_fields
    options = [val.name for val in cls.select(self.env, db=db)]
  File "C:\Python23\Lib\site-packages\trac\Milestone.py", line 136, in select
    cursor.execute(sql)
  File "C:\Python23\Lib\site-packages\sqlite\main.py", line 244, in execute
    self.rs = self.con.db.execute(SQL)
DatabaseError: no such column: due

[Christopher Lenz]

The due column should have been added by the database upgrade scripts (see TracUpgrade). I'm not sure how you've circumvented the database version check ;-)

In any case, try running trac-admin /path/to/projenv upgrade and report the results.

[randyjames@…]

I performed the trac-admin upgrade step as part of the overal upgrade.

1. Ran the windows install package for .9
2. Ran upgrade from the trac-admin interactive prompted.
3. Ran a resync.

This all worked fine. Running the trac-admin upgrade again states that the DB is up to date.

[randyjames@…]

Here is the sqlite dump of the schema for the milestone table. It appears that this is the table that is missing the due column.

sqlite> .schema milestone CREATE TABLE milestone (

id integer PRIMARY KEY, name text, time integer, owner text, descr text, UNIQUE(name)

);

[Matthew Good]

Based on emails about this on the mailing list I believe that the user updated the "database_version" entry in Trac's "system" table to 8 either by hand or some other method besides Trac's own upgrade scripts. Due to this manipulation the upgrade script for version 8 of the DB was never run. We really can't guarantee proper application of the upgrade scripts in this situation.