Re: [Webcollab-users] 3.00 - Tasks not being updated with current date upon completion

[Andrew S. <and...@co...>]

On Tue, 28 Feb 2012 17:09:38 -0600
Justin Winschief <jw...@at...> wrote:

> Hi Andrew and webcollab users,
> 
> After upgrading to 3.00 recently, we noticed that tasks are not being updated with the current
> date when they are marked as completed - instead, any task we close seems to have finished_time
> left set to the same value as created.  Looks like this field is set upon task creation but is no
> longer being updated upon completion.   This might not be a big problem for most users, but we
> wrote some PHP "status" pages for management to track recently-completed tasks/projects, and this
> breaks that.  I verified this is happening in the database and is not just a display issue.   I
> had included some SQL output here but removed it since this should be easy enough to verify.
> 
> The "edited" and "status" columns are being updated but 'finished_time' is not.  The task's
> webpage shows the same data.  Looking at the database documentation I actually don't see
> finished_time in the list of fields so I'm hoping you haven't removed this for some reason.  I
> ran some queries and was able to verify that, since our upgrade to 3.00, no tasks have had this
> field modified.  This is the case for both new and old tasks.
> 
> I tested a bit on the online demo page and it seems to happen there too.   Wondering if you have
> any ideas for a quick fix and if you can reproduce this behavior, as it seems to be new to
> 3.00.   Thanks very much for the help and the great software =)
> 
> -Justin
> 

Justin,

The problem with doing big database engine rewrites is that things get broken. Hopefully this is
the last (or nearly last) of the little database bugs.

If you can grab the file webcollab/tasks/task_submit_update.php from the Git Repository, this bug
should be fixed now.

Andrew