Modify

Opened 8 years ago

Closed 8 years ago

#1064 closed defect (fixed)

Error upgrading database

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

Description (last modified by athomas)

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 8 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 8 years ago by athomas

  • Description modified (diff)

comment:3 Changed 8 years ago by bobbysmith007

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 8 years ago by bobbysmith007

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 8 years ago by anonymous

  • Resolution set to fixed
  • Status changed from new to closed

Add Comment

Modify Ticket

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from bobbysmith007. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.