Error in NukeProject "Add Task"

New Member Joined: Apr 20, 2004 Posts: 5

Hi all,

just upgraded from Work Board to NukeProject 2.0.0 and now I get a blank page when trying to add a new task. It is added to the database, but it seems that there is an error in PJProjectTask.php. [ Only registered users can see links on this board! Get registered or login! ]
PHPNuke 7.2 Patched 3.1
Any suggestions?

chiroptera

Sells PC To Pay For Divorce Joined: Posts: 5661

well posting the error would be nice,and a link like you just posted doesnt realy help.. Sad

Posted: Fri Mar 31, 2006 7:52 am

hitwalker wrote:

well posting the error would be nice,and a link like you just posted doesnt realy help.. Sad

There is no error message - just a blank page. I have tried to enable the debugger, but without success Sad

Therefore I have no error message - just the hint that it must have something to do with PJProjectTask.php
Would it help to post the code?

chiroptera

Posted: Fri Mar 31, 2006 7:57 am

well you can post it but are you sure your stuff is compatible?
Some coding is changed here and there vand specialy nuke project.
but you can start by posting the file and explaining what the error could be your talking about..

Posted: Mon Apr 03, 2006 3:51 am

hitwalker wrote:

well you can post it but are you sure your stuff is compatible?

Nukeproject 2.0.0 readme wrote:

- It requires PHP-Nuke 7.0 thru 7.9 plus Patched 3.1 be installed.

As I am using Nuke 7.2 plus Patched 3.1 it should be compatible ... and it works fine accept those blank screen after a task was added.

hitwalker wrote:

Some coding is changed here and there vand specialy nuke project.

what kind of code changes are you talking about? Changes of NukeProject 2.0.0?

hitwalker wrote:

but you can start by posting the file and explaining what the error could be your talking about..

hmmm - I have removed PJProjectTasks.php from the server to see if the error is in this file, but still a blank page without any error message.
These are the codes of the admin files which seems to be used when a task is added
PJTaskInsert.php

Code:

<?php





/********************************************************/


/* NukeProject(tm)                                      */


/* By: NukeScripts Network (webmaster@nukescripts.net)  */


/* http://www.nukescripts.net                           */


/* Copyright © 2000-2005 by NukeScripts Network         */


/********************************************************/





if(!defined('NSNPJ_ADMIN')) { die("Illegal Access Detected!!!"); }


$date = time();


$task_name = htmlentities($task_name, ENT_QUOTES);


$task_description = htmlentities($task_description, ENT_QUOTES);


$priority_id = intval($priority_id);


$status_id = intval($status_id);


$task_percent = intval($task_percent);


$project_id = intval($project_id);


$start_date = "$task_start_year-$task_start_month-$task_start_day";


if($start_date == "0000-00-00") { $start_date = 0; } else { $start_date = strtotime($start_date); }


$finish_date = "$task_finish_year-$task_finish_month-$task_finish_day";


if($finish_date == "0000-00-00") { $finish_date = 0; } else { $finish_date = strtotime($finish_date); }


$db->sql_query("INSERT INTO `".$prefix."_nsnpj_tasks` VALUES (NULL, '$project_id', '$task_name', '$task_description', '$priority_id', '$status_id', '$task_percent', '$date', '$start_date', '$finish_date')");


$taskresult = $db->sql_query("SELECT `task_id` FROM `".$prefix."_nsnpj_tasks` WHERE `date_created`='$date'");


list($task_id) = $db->sql_fetchrow($taskresult);


if(implode("", $member_ids) > "") {


  while(list($null, $member_id) = each($member_ids)) {


    $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM `".$prefix."_nsnpj_tasks_members` WHERE `task_id`='$task_id' AND `member_id`='$member_id'"));


    if($numrows == 0) {


      $db->sql_query("INSERT INTO `".$prefix."_nsnpj_tasks_members` VALUES ('$task_id', '$member_id', '".$pj_config['new_task_position']."')");        


    }


  }


}


header("Location: ".$admin_file.".php?op=PJProjectTasks&project_id=$project_id");





?>

PJTaskAdd.php

Code:

<?php





/********************************************************/


/* NukeProject(tm)                                      */


/* By: NukeScripts Network (webmaster@nukescripts.net)  */


/* http://www.nukescripts.net                           */


/* Copyright © 2000-2005 by NukeScripts Network         */


/********************************************************/





if(!defined('NSNPJ_ADMIN')) { die("Illegal Access Detected!!!"); }


$pagetitle = ": "._PJ_TITLE." ".$pj_config['version_number'].": "._PJ_TASKS.": "._PJ_TASKADD;


include("header.php");


pjadmin_menu(_PJ_TASKS.": "._PJ_TASKADD);


echo "<br />\n";


OpenTable();


echo "<table align='center' border='0' cellpadding='2' cellspacing='2'>\n";


echo "<form method='post' action='".$admin_file.".php'>\n";


echo "<input type='hidden' name='op' value='PJTaskInsert'>\n";


echo "<tr><td bgcolor='$bgcolor2'>"._PJ_PROJECT.":</td>\n";


echo "<td><select name='project_id'>\n";


$projectlist = $db->sql_query("SELECT `project_id`, `project_name` FROM `".$prefix."_nsnpj_projects` ORDER BY `project_name`");


while(list($s_project_id, $s_project_name) = $db->sql_fetchrow($projectlist)){


  if($s_project_id == $project_id){ $sel = "SELECTed"; } else { $sel = ""; }


  echo "<option value='$s_project_id' $sel>$s_project_name</option>\n";


}


echo "</select></td></tr>\n";        


echo "<tr><td bgcolor='$bgcolor2'>"._PJ_TASKNAME.":</td>\n";


echo "<td><input type='text' name='task_name' size='30'></td></tr>\n";


echo "<tr><td bgcolor='$bgcolor2' valign='top'>"._PJ_TASKDESCRIPTION.":</td>\n";


echo "<td><textarea name='task_description' cols='60' rows='10'></textarea></td></tr>\n";


echo "<tr><td bgcolor='$bgcolor2'>"._PJ_PRIORITY.":</td>\n";


echo "<td><select name='priority_id'>\n";


$prioritylist = $db->sql_query("SELECT `priority_id`, `priority_name` FROM `".$prefix."_nsnpj_tasks_priorities` ORDER BY `priority_weight`");


while(list($s_priority_id, $s_priority_name) = $db->sql_fetchrow($prioritylist)){


  echo "<option value='$s_priority_id'>$s_priority_name</option>\n";


}


echo "</select></td></tr>\n";


echo "<tr><td bgcolor='$bgcolor2'>"._PJ_STATUSPERCENT.":</td>\n";


echo "<td><input type='text' name='task_percent' size='4'>%</td></tr>\n";


echo "<tr><td bgcolor='$bgcolor2'>"._PJ_STATUS.":</td>\n";


echo "<td><select name='status_id'>\n";


$statuslist = $db->sql_query("SELECT `status_id`, `status_name` FROM `".$prefix."_nsnpj_tasks_status` ORDER BY `status_weight`");


while(list($s_status_id, $s_status_name) = $db->sql_fetchrow($statuslist)){


  echo "<option value='$s_status_id'>$s_status_name</option>\n";


}


echo "</select></td></tr>\n";


echo "<tr><td bgcolor='$bgcolor2'>"._PJ_STARTDATE.":</td>\n";


echo "<td><select name='task_start_month'><option value='00'>--</option>\n";


for($i = 1; $i <= 12; $i++){


  if($i == date("m")){ $sel = "SELECTed"; } else { $sel = ""; }


  echo "<option value='$i' $sel>$i</option>\n";


}


echo "</select><select name='task_start_day'><option value='00'>--</option>\n";


for($i = 1; $i <= 31; $i++){


  if($i == date("d")){ $sel = "SELECTed"; } else { $sel = ""; }


  echo "<option value='$i' $sel>$i</option>\n";


}


echo "</select><input type=text name='task_start_year' value='".date("Y")."' size='4' maxlength='4'></td></tr>\n";


echo "<tr><td bgcolor='$bgcolor2'>"._PJ_FINISHDATE.":</td>\n";


echo "<td><select name='task_finish_month'><option value='00'>--</option>\n";


for($i = 1; $i <= 12; $i++){


  echo "<option value='$i'>$i</option>\n";


}


echo "</select><select name='task_finish_day'><option value='00'>--</option>\n";


for($i = 1; $i <= 31; $i++){


  echo "<option value='$i'>$i</option>\n";


}


echo "</select><input type=text name='task_finish_year' value='0000' size='4' maxlength='4'></td></tr>\n";


echo "<tr><td bgcolor='$bgcolor2' valign='top'>"._PJ_ASSIGNMEMBERS.":</td>\n";


echo "<td><select name='member_ids[]' size='10' multiple>\n";


$memberlistresult = $db->sql_query("SELECT `member_id`, `member_name` FROM `".$prefix."_nsnpj_members` ORDER BY `member_name`");


while(list($member_id, $member_name) = $db->sql_fetchrow($memberlistresult)) {


  echo "<option value='$member_id'>$member_name</option>\n";


}


echo "</select></td></tr>\n";


echo "<tr><td align='center' colspan='2'><input type='submit' value='"._PJ_TASKADD."'></td></tr>\n";


echo "</form>\n";


echo "</table>\n";


CloseTable();


pj_copy();


include("footer.php");





?>

PJProjectTasks.php

Code:

<?php





/********************************************************/


/* NukeProject(tm)                                      */


/* By: NukeScripts Network (webmaster@nukescripts.net)  */


/* http://www.nukescripts.net                           */


/* Copyright © 2000-2005 by NukeScripts Network         */


/********************************************************/





if(!defined('NSNPJ_ADMIN')) { die("Illegal Access Detected!!!"); }


$pagetitle = ": "._PJ_TITLE." ".$pj_config['version_number'].": "._PJ_PROJECTS.": "._PJ_TASKLIST;


include("header.php");


$projectresult = $db->sql_query("SELECT `project_name`, `project_description`, `status_id`, `priority_id` FROM `".$prefix."_nsnpj_projects` WHERE `project_id`='$project_id'");


list($project_name, $project_description, $status_id, $priority_id) = $db->sql_fetchrow($projectresult);


pjadmin_menu(_PJ_PROJECTS.": "._PJ_TASKLIST);


echo "<br />\n";


$taskresult = $db->sql_query("SELECT `task_id`, `task_name`, `priority_id`, `status_id` FROM `".$prefix."_nsnpj_tasks` WHERE `project_id`='$project_id' ORDER BY `task_name`");


$task_total = $db->sql_numrows($taskresult);


OpenTable();


echo "<table width='100%' border='1' cellspacing='0' cellpadding='2'>\n";


echo "<tr><td colspan='2' bgcolor='$bgcolor2' width='100%'><nobr><b>"._PJ_PROJECT."</b></nobr></td>\n";


echo "<td align='center' bgcolor='$bgcolor2'><b>"._PJ_STATUS."</b></td>\n";


echo "<td align='center' bgcolor='$bgcolor2'><b>"._PJ_PRIORITY."</b></td>\n";


echo "<td align='center' bgcolor='$bgcolor2'><b>"._PJ_FUNCTIONS."</b></td></tr>\n";


$pjimage = pjimage("project.png", $modname);


echo "<tr><td><img src='$pjimage'></td>\n";


echo "<td width='100%'><a href='".$admin_file.".php?op=PJProjectList'>"._PJ_PROJECTS."</a> / <b>$project_name</b></td>\n";


$projectstatus = pjprojectstatus_info($status_id);


if($projectstatus['status_name'] == "") { $projectstatus['status_name'] = _PJ_NA; }


echo "<td align='center'><a href='".$admin_file.".php?op=PJProjectStatusList'>".$projectstatus['status_name']."</a></td>\n";


$projectpriority = pjprojectpriority_info($priority_id);


if($projectpriority['priority_name'] == "") { $projectpriority['priority_name'] = _PJ_NA; }


echo "<td align='center'><a href='".$admin_file.".php?op=PJProjectPriorityList'>".$projectpriority['priority_name']."</a></td>\n";


echo "<td align='center'><nobr>[ <a href='".$admin_file.".php?op=PJProjectEdit&amp;project_id=$project_id'>"._PJ_EDIT."</a> |";


echo " <a href='".$admin_file.".php?op=PJProjectRemove&amp;project_id=$project_id'>"._PJ_DELETE."</a> ]</nobr></td></tr>\n";


echo "<tr><td colspan='5' width='100%' bgcolor='$bgcolor2'><nobr><b>"._PJ_PROJECTOPTIONS."</b></nobr></td></tr>\n";


$pjimage = pjimage("options.png", $modname);


echo "<tr><td><img src='$pjimage'></td><td colspan='4' width='100%'><nobr><a href='".$admin_file.".php?op=PJTaskAdd&amp;project_id=$project_id'>"._PJ_TASKADD."</a></nobr></td></tr>\n";


$pjimage = pjimage("stats.png", $modname);


echo "<tr><td><img src='$pjimage'></td><td colspan='4' width='100%'><nobr>"._PJ_TOTALTASKS.": <b>$task_total</b></nobr></td></tr>\n";


echo "</table>\n";


CloseTable();


echo "<br />\n";


OpenTable();


echo "<table width='100%' border='1' cellspacing='0' cellpadding='2'>\n";


echo "<tr><td colspan='2' bgcolor='$bgcolor2' width='100%'><b>"._PJ_PROJECTTASKS."</b></a></td>\n";


echo "<td align='center' bgcolor='$bgcolor2'><b>"._PJ_STATUS."</b></td><td align='center' bgcolor='$bgcolor2'><b>"._PJ_PRIORITY."</b></td><td align='center' bgcolor='$bgcolor2'><b>"._PJ_FUNCTIONS."</b></td></tr>\n";


if($task_total != 0){


  while(list($task_id, $task_name, $priority_id, $status_id) = $db->sql_fetchrow($taskresult)) {


    $pjimage = pjimage("task.png", $modname);


    echo "<tr><td><img src='$pjimage'></td><td width='100%'>$task_name</td>\n";


    $taskstatus = pjtaskstatus_info($status_id);


    if($taskstatus['status_name'] == "") { $taskstatus['status_name'] = _PJ_NA; }


    echo "<td align='center'><a href='".$admin_file.".php?op=PJTaskStatusList'>".$taskstatus['status_name']."</a></td>\n";


    $taskpriority = pjtaskpriority_info($priority_id);


    if($taskpriority['priority_name'] == "") { $taskpriority['priority_name'] = _PJ_NA; }


    echo "<td align='center'><a href='".$admin_file.".php?op=PJTaskPriorityList'>".$taskpriority['priority_name']."</a></td>\n";


    echo "<td align='center'><nobr>[ <a href='".$admin_file.".php?op=PJTaskEdit&amp;task_id=$task_id'>"._PJ_EDIT."</a>";


    echo " | <a href='".$admin_file.".php?op=PJTaskRemove&amp;task_id=$task_id'>"._PJ_DELETE."</a> ]</nobr></td></tr>\n";


  }


} else {


  echo "<tr><td width='100%' colspan='4' align='center'>"._PJ_NOPROJECTTASKS."</td></tr>\n";


}


echo "</table>\n";


CloseTable();


pj_copy();


include("footer.php");





?>

Posted: Mon Apr 03, 2006 4:13 am

well that doesnt help much,not your fault but its hard for anyone saying why this happens.
Getting the blank doesnt realy mean there's an error but an incompatibility somewhere,and with an patched 7.2 that could be anything.

Posted: Mon Apr 03, 2006 5:08 am

Ok - thanks so far Smile

As a work around I did the following in /modules/Projects/admin/PJTaskInsert.php:
Change

Code:

header("Location: ".$admin_file.".php?op=PJProjectTasks&project_id=$project_id");

to

Code:

header("Location: ".$admin_file.".php?op=PJTaskList");

After adding a task, it jumps now back to the task list - much better than a blank page Wink

Posted: Mon Apr 03, 2006 5:11 am

sure if this works for you why not..
i never used the module so i dont know what it should show after a task is submitted.

Posted: Tue Apr 04, 2006 6:53 am

Ok, that tells me that PJProjectTasks may not be defined in the case statements. (I.e., case.php or case-<<modulename>>.php). I wonder if it was a simple oversight.

Posted: Tue Apr 04, 2006 8:50 am

montego wrote:

Ok, that tells me that PJProjectTasks may not be defined in the case statements. (I.e., case.php or case-<<modulename>>.php).

It's defined in the corresponding case statements. Do you have any other suggestions?