Opened 12 months ago

Last modified 2 months ago

#11332 reopened defect

Unable to upgrade trac 1.0.1 database

Reported by: roger@… Owned by: martin_s
Priority: normal Component: WatchlistPlugin
Severity: normal Keywords:
Cc: Trac Release:


I just installed the plugin on a Trac 1.0.1 system.

easy_install TracWatchlistPlugin

When I try to update the database, I get this:

# trac-admin /vol1/trac/systems upgrade

The upgrade failed. Please fix the issue and try again.

OperationalError: table watchlist_new has 4 columns but 3 values were supplied

Does this plugin work with Trac 1.0.1?

Attachments (0)

Change History (7)

comment:1 Changed 12 months ago by martin_s

The WatchlistPlugin was written with Trac 0.11 and 0.12 and wasn't updated since. So 1.0.1 isn't activly supported. What DB backend are you using?

comment:2 Changed 12 months ago by rjollos

  • Resolution set to duplicate
  • Status changed from new to closed

Duplicate of #10054. I'll add some comments to that ticket.

comment:3 Changed 12 months ago by rjollos

  • Resolution duplicate deleted
  • Status changed from closed to reopened

Well, maybe not a duplicate since #10054 is running Trac 0.12.1.

At first I suspected this may be due to how the plugin is checking for table existence, which doesn't work in Trac 1.0 and later. hasienda and jun66j5 have worked out a good cross-db solution for that issue, see #9521.

However, if the issue is the same as that reported in #10054, then that probably is not the issue.

comment:4 Changed 12 months ago by roger@…

The default mysql.

Any plans to support 1.0.1? I think the features this plug-in offers would make many of our users happier with our system.

comment:5 Changed 12 months ago by anonymous

Yikes! I answered wrong! I means SQLite!

comment:6 Changed 2 months ago by paul.jendrowski@…

The "OperationalError: table watchlist_new has 4 columns but 3 values were supplied" error is because the old version of the plugin and the new version have different table structures as reported in #10054 (I opened that ticket). I tried a clean install of the plugin on a new Trac 1.0.1 project. When I run trac-admin upgrade, I get an error of just "Error: AttributeError: ", nothing else. No watchlist tables are created (using sqlite db).

Running this for an enterprise and have multiple projects that are already using watchlist. We need to upgrade to Trac 1.0.1 so we really would like watchlist to be upgraded to work with the latest version of Trac.

I'd be willing to help get this working. I know python, but not much about Trac architecture so would need some guidance.

comment:7 Changed 2 months ago by rjollos

With the changes committed to #10423 just now, the plugin should work for new installations on Trac 1.0 and later. It sounds like there may still be an issue when upgrading from an older version. Let me know if you find any hints as to what the issue might be there.

Add Comment

Modify Ticket

as reopened .

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

Note: See TracTickets for help on using tickets.