Error upgrading database

[efeldt@…]

2007-01-02 15:50:17,756 Trac[env] WARNING: Component <timingandestimationplugin.api.TimeTrackingSetupParticipant object at 0x00F9C490> requires environment upgrade
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Ticket Work Summary' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Milestone Work Summary' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Developer Work Summary' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Ticket Hours' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Ticket Hours with Description' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Ticket Hours Grouped By Component' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Ticket Hours Grouped By Component with Description' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Ticket Hours Grouped By Milestone' needs to be added
2007-01-02 15:50:18,084 Trac[api] WARNING: Report 'Ticket Hours Grouped By MileStone with Description' needs to be added
2007-01-02 15:50:18,726 Trac[dbhelper] ERROR: There was a problem executing sql: UPDATE wiki SET time = 0 WHERE time='%s'  
 with parameters:()
Exception:(1292, "Truncated incorrect DOUBLE value: '%s'")

I use mySQL 5 as the database backend (the upgrade worked on a project using a sql-lite backend)

Any ideas?

[efeldt@…]

Also the management tab does not appear in this project, but does appear in the sql-lite project.

[Russ Tyndall]

This plugin doesn't quite support mysql as you can tell.

I will attempt to get a new version up tomorrow (or later tonight if you are lucky) that will fix this specific error. It seems like somewhere I am string formating when I should be passing sql parameters.

Sorry for the inconvenience,

Russ

[Russ Tyndall]

This was a fix put in place because the plugin inserted corrupt times into sqlite for a while. It is wrapped in a

try:

...

except:

pass

so I am not sure why you would be getting this error.

I have commented out the offending lines as all corrupt times have probably been fixed at this point. Please upgrade to version0.3.7 of this plugin and try again.

Hope this helps,

Russ