Modify

Opened 7 years ago

Closed 7 years ago

Last modified 21 months ago

#7715 closed defect (fixed)

Trac environment upgrade doesn't work

Reported by: jan Owned by: Martin Scharrer
Priority: normal Component: WatchlistPlugin
Severity: major Keywords: DB upgrade brocken
Cc: Trac Release: 0.11

Description

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

Attachments (1)

trac.log (75.8 KB) - added by Jan 7 years ago.

Download all attachments as: .zip

Change History (10)

comment:1 Changed 7 years ago by Martin Scharrer

Keywords: DB upgrade brocken added
Severity: normalmajor
Status: newassigned

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

comment:2 Changed 7 years ago by 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".

Changed 7 years ago by Jan

Attachment: trac.log added

comment:3 Changed 7 years ago by 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

comment:4 Changed 7 years ago by Martin Scharrer

Resolution: fixed
Status: assignedclosed

(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.

comment:5 Changed 7 years ago by Martin Scharrer

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

comment:6 Changed 7 years ago by Jan

Resolution: fixed
Status: closedreopened

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

Last edited 21 months ago by Ryan J Ollos (previous) (diff)

comment:7 Changed 7 years ago by Martin Scharrer

Resolution: fixed
Status: reopenedclosed

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

comment:8 Changed 7 years ago by 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.

comment:9 Changed 7 years ago by Jan

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Martin Scharrer.
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.