break;
case 'unassigned': // List unassigned (but not deleted) tasks
- $whereStatement = "`assigned_admin`=0 AND `status` != 'DELETED'";
+ $whereStatement = "(`assigned_admin`=0 OR `assigned_admin` IS NULL) AND `status` != 'DELETED'";
break;
case 'deleted': // List all deleted
if (isPostRequestParameterSet('unassign')) {
// Unassign from tasks
foreach (postRequestParameter('sel') as $id => $sel) {
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=0 WHERE `id`=%s AND `assigned_admin`=%s LIMIT 1",
+ SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=NULL WHERE `id`=%s AND `assigned_admin`=%s LIMIT 1",
array(bigintval($id), getCurrentAdminId()), __FILE__, __LINE__);
} // END - foreach
} elseif (isFormSent('delete')) {