Trac environment upgrade doesn't work

[jan]

I want install the WatchlistPlugin together with the announcer plugin. I'am using Trac 0.11.6 on windows. python is 2.5. The ListOfWikiPagesMacro and the AdvParseArgsPlugin are installed and working. If I install the WatchlistPlugin r9054 for 0.11 i and run the upgrade of the trac environment I always get the response "Upgrade done". But the project always tells the the environment needs to be upgraded. I can run the upgrade as often as I want.

regards jan

[Martin Scharrer]

Hi Jan, sorry to hear that. The DB upgrade code of the current 0.11 branch seems to be a little doggy. You are not the first person having this issue. There is a new version coming up soon for 0.11 and 0.12 where the DB upgrade code was completely rewritten.

Could you answer me the following questions, so I can help you better in the meantime.

• Did you ever installed an old version of the WatchlistPlugin on that Trac?
• Which DB backend do you use? The default is sqlite, but postgresSQL and MySQL is also supported.

Regards, Martin_S

[Martin Scharrer]

Also, there should be some entries in the log file. Could you make sure that logging is enabled in the trac.ini file and post the log messages here? They all start with "Watchlist".

[anonymous]

Hi Martin,

i attached the logfile.

• No it is my first try to get it run in a test environment
• I'am using the sqlite backend

Thanks for your quick response!

Regards Jan

[Martin Scharrer]

(In [9056]) 0.11/tracwatchlist/plugin.py:: The case when the DB cursor returns 'None' is now handled correctly.

This should fix #7715. This change was already submitted as attachment:0002-fixes-needs_upgrade-bug.patch:ticket:6238​ but was not applied to the 0.11 branch yet.

[Martin Scharrer]

Should be fixed in r9056. Could you please try it again and reopen this ticket if it still doesn't work.

[Jan]

Hi Martin,

the problem still remains.

For testing I used the current development version r9078 - nothing changed.

If I use a new created trac-Project following log entries will come up:

2010-09-23 10:43:39,506 Trac[plugin] INFO: Watchlist table version to old
2010-09-23 10:43:39,506 Trac[env] WARNING: Component <tracwatchlist.plugin.WatchlistPlugin object at 0x013488B0> requires environment upgrade
2010-09-23 10:43:39,523 Trac[plugin] INFO: Watchlist table version to old
2010-09-23 10:43:39,538 Trac[plugin] INFO: Creating system table entry for watchlist plugin: No version entry in system table
2010-09-23 10:43:39,585 Trac[plugin] INFO: Updating watchlist table
2010-09-23 10:43:39,585 Trac[plugin] INFO: Old version: %d, new version: %d
2010-09-23 10:43:39,601 Trac[plugin] INFO: Creating table '('watchlist_new',)' for WatchlistPlugin
2010-09-23 10:43:39,960 Trac[plugin] INFO: Update from version 1
2010-09-23 10:43:39,960 Trac[plugin] INFO: Moving new table to old one

If I use the previous project following log entries are coming up:

2010-09-23 10:24:56,309 Trac[plugin] INFO: Watchlist table version to old
2010-09-23 10:24:56,309 Trac[env] WARNING: Component <tracwatchlist.plugin.WatchlistPlugin object at 0x0297D350> requires environment upgrade

Regards, Jan

[Martin Scharrer]

(In [9083]) 0.11/tracwatchlist/plugin.py:: Fixed initial DB creation. This should fix #7715.

[Martin Scharrer]

Ok, I went over the code again and it works now on my Trac test installation. As already mentioned there is a new version coming up soon (maybe this weekend) which adds a lot of functionality.

[Jan]

Hi Martin,
sorry for my late respone - it is working now[[BR]] Thanks[[BR]] Regards Jan