My favorites | Sign in
Project Home Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 275: Time sheet performance change causes inconsistencies in existing data (Fix in report)
1 person starred this issue and may be notified of changes. Back to list
 
Project Member Reported by ca...@burkesoftware.com, Jan 27, 2012
The performance change causes any timesheets that had a performance value of NULL/None before changed to 0. Once the timesheet performance are adjusted, it's changed to 1.

To fix this, either change the "0" values to NULL in the database before performances are customized. If it's too late, follow these steps (will only work if you have backups of your database):

1. restore a backup from after the update (around January 6)

2. Select the timesheet ids from the timesheet table into an outfile (as a .sql). I terminated lines with " or id = " to make the UPDATE command easier to create.

3. Alter the .sql file so that it's set to update the timesheet table and set the performance to NULL where the timesheet IDs are the outfile (.sql)
If you did my suggestion above, make sure you remove the last "or id =" and add a semicolon to the end of the line.

4. Back up your database

5. Run the .sql file into the database

Voila! it should be fixed.

Powered by Google Project Hosting