Modify

Opened 17 years ago

Closed 17 years ago

#1064 closed defect (fixed)

Error upgrading database

Reported by: efeldt@… Owned by: Russ Tyndall
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description (last modified by Alec Thomas)

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?

Attachments (0)

Change History (5)

comment:1 Changed 17 years ago by efeldt@…

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

comment:2 Changed 17 years ago by Alec Thomas

Description: modified (diff)

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

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

comment:5 Changed 17 years ago by anonymous

Resolution: fixed
Status: newclosed

Modify Ticket

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