Unable to run upgrade on trac after installing plugin in project

[eklasso@…]

We have a few trac projects on our site and one of them want to use the timingandestimation plugin, but when I try to add the egg file to the plugin directory tracd tells me to run upgrade. When I do this all I get is "Database is up to date, no upgrade necessary."

If I create a new project I can do an enviroment upgrade without any problems.

So probably there are some information in the database that says i have done the upgrade, but It failed somehow, I would need some help with exactly what I have to remove/edit in the database to enable this plugin, or be able to run the upgrade command.

trac version: 0.10.4
sqlite: 3.4.0
timingestimation plugin: 0.4.9

Python: 2.4
Os: Solaris 9

[Russ Tyndall]

Your versions of everything look good. I'm not sure if there is anyone else running Solaris, but I would assume that Doesn't matter (given it is python).

Let me run down a few suggestions:

1. verify that you have enabled the plugin BEFORE you try to upgrade.
2. check the system table to verify the values of the following keys:
   • TimingAndEstimationPlugin_Db_Version|6
   • custom_report_manager_version|1
3. check the database schema (.schema in sqlite) for the tables:
   • bill_date
   • custom_report

If none of those exist and it is still giving you problems you might want to turn on trac's log (​http://trac.edgewall.org/wiki/TracLogging) and see if it will give you any more information about what is going on.

If those database keys are in there but the database is not upgraded correctly, you might wish to try setting the database version back to 0 and try again. If you keep getting failures, let me know, and I will try to assist further.

hope this helps,

Russ

[eklasso@…]

Hi!

The system table has this value only:
database_version|20
youngest_rev|
TimingAndEstimationPlugin_Db_Version|0

Also, there are no entries for bill_date and custom_report

So the best solution might be to change database version to 0 and try the upgrade again.

Niklas

[anonymous]

sorry I never saw that comment, but the database version I was speaking of was TimingAndEstimationPlugin_Db_Version which already was 0. You will need to check your logs to see whats going on. Sorry cant think of anything else right now.

Russ

[anonymous]

Replying to anonymous:

sorry I never saw that comment, but the database version I was speaking of was TimingAndEstimationPlugin_Db_Version which already was 0. You will need to check your logs to see whats going on. Sorry cant think of anything else right now.

Russ

I started logging and restarted the project to see what is going on, and this is what I get:

2007-09-20 13:17:11,830 Trac[init] DEBUG: Loading egg plugin timingandestimationplugin from /time_plugin/plugins/timingandestimationplugin-0.4.6-py2.4.egg

2007-09-20 13:17:11,860 Trac[init] WARNING: Component <timingandestimationplugin.api.TimeTrackingSetupParticipant object at 0x69 1730> requires environment upgrade

trac-admin <project> upgrade gives no output and I can not find any verbose option.

[Russ Tyndall]

Well one thing I notice is that you are using an out of date version of the plugin from around the time that Colin was reorganizing the reporting bits.

You listed timingestimation plugin: 0.4.9 as your version, but if you look in the log, it is trying to load 0.4.6. It could be possible that you have both installed and it is choosing the wrong version to use (not sure why it would do that). You should be able to fix it by removing any old versions of the plugin and actually getting it to load .4.9 which should work / be stable.

Sorry it took so long to detect what was broken, but I am 90% sure that this will solve your issues. If it doesnt, please feel free to reopen. Russ