3.5.1d - My Open Tasks

[Haicube]

Something is seriously damaged here.

I've upgraded to 3.5.1d. and now suddenly My Open Tasks doesn't get displayed on the "Home" page. I would imagine some of the fixes to tasks actually broke this one. Can someone confirm they have the same problem?

[clint]

Looking into this...

[sadek]

Are there no items in the Sub Panel, or is the Sub Panel itself completely gone?

~Sadek~

[ra42]

I'm also experiencing this problem.
The subpanel is showing but it is empty.

[sadek]

Can you change the following in <sugardir/modules/Tasks/MyTasks.php>

from:

$where .= "and (tasks.date_start is NULL or ";
$where .= " CONCAT(".db_convert("tasks.date_start","date_forma t",array("'YYYY-MM-DD'")).", CONCAT(' ',". db_convert("tasks.time_start","time_format",array( "'HH24:MI:SS'"))." )) <=". "'".$tomorrow."')";

to:

$where .= "and (tasks.date_start is NULL or CONCAT(tasks.date_start,' ',tasks.time_start) <= '$tomorrow')";

Please let me know if that is fixes the problem you are having.

~Sadek~

[ra42]

Thats fixed it for me. Thanks sadek!

[takens]

I had the same problem and this fixed it for me too.

Just to supply you eith some extra information:
My collegue used the year-month-day format (My account settings) did not have this problem. After the upgrade his tasks would show up normaly in My Open Tasks. I used the day-month-year format and my tasks would not show up.

I hope this helps

[Haicube]

Can you change the following in <sugardir/modules/Tasks/MyTasks.php>

from:

$where .= "and (tasks.date_start is NULL or ";
$where .= " CONCAT(".db_convert("tasks.date_start","date_forma t",array("'YYYY-MM-DD'")).", CONCAT(' ',". db_convert("tasks.time_start","time_format",array( "'HH24:MI:SS'"))." )) <=". "'".$tomorrow."')";

to:

$where .= "and (tasks.date_start is NULL or CONCAT(tasks.date_start,' ',tasks.time_start) <= '$tomorrow')";

Please let me know if that is fixes the problem you are having.

~Sadek~

Works very well... thank you very much. However, I've come across a whole bunch of other errors in the 3.5.1d release, I'll post them soon..

[dricrm]

This is broken again when upgrading to version 3.5.1e...

cheers,
diogo

[sadek]

Interesting. I'll look into why that happened.
In any case, this time please change the following in <sugarroot/modules/Tasks/MyTasks.php>:

$today = gmdate("Y-m-d H:i:s");
// Break down the date, add a day, and print it back out again
list($date_tmp,$time_tmp) = explode(' ',$today);
$date = explode('-',$date_tmp);
$time = explode(':',$time_tmp);
$tomorrow = gmdate("Y-m-d H:i:s",gmmktime($time[0],$time[1],$time[2],$date[1],($date[2]+1),$date[0]));

$ListView = new ListView();
$seedTasks = new Task();
$where = "tasks.assigned_user_id='". $current_user->id ."' and (tasks.status is NULL or (tasks.status!='Completed' and tasks.status!='Deferred')) ";
$where .= "and (tasks.date_start is NULL or ";
$where .=  " CONCAT(".db_convert("tasks.date_start","date_format",array("'YYYY-MM-DD'")).", CONCAT(' ',". db_convert("tasks.time_start","time_format",array("'HH24:MI:SS'"))." ))  <=". "'".$tomorrow."')";

to:

$today = gmdate("Y-m-d H:i:s");
// Break down the date, add a day, and print it back out again
list($date_tmp,$time_tmp) = explode(' ',$today);
$date = explode('-',$date_tmp);
$time = explode(':',$time_tmp);
$tomorrow = gmdate("Y-m-d H:i:s",gmmktime($time[0],$time[1],$time[2],$date[1],($date[2]+1),$date[0]));

$ListView = new ListView();
$seedTasks = new Task();
if ($seedTasks->db->dbType=='mysql') {
	$format=array("'%Y-%m-%d'");
} else {
	$format=array("'YYYY-MM-DD'");
}

$where = "tasks.assigned_user_id='". $current_user->id ."' and (tasks.status is NULL or (tasks.status!='Completed' and tasks.status!='Deferred')) ";
$where .= "and (tasks.date_start is NULL or ";
$where .=  " CONCAT(".db_convert("tasks.date_start","date_format",$format).", CONCAT(' ',". db_convert("tasks.time_start","time_format",$format)." ))  <=". "'".$tomorrow."')";

~Sadek~