Ravens PHP Scripts: Forums
 

 
  Forum Index  •  Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in

Error in NukeProject "Add Task"
 View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules
Author Message
chiroptera
New Member
New Member



Joined: Apr 20, 2004
Posts: 5
PostPosted: Fri Mar 31, 2006 1:45 am Reply with quote
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.
http://www.mywebsite.com/admin.php?op=PJProjectTasks&project_id=7
PHPNuke 7.2 Patched 3.1
Any suggestions?

chiroptera
 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce



Joined:
Posts: 5661
PostPosted: Fri Mar 31, 2006 6:28 am Reply with quote
well posting the error would be nice,and a link like you just posted doesnt realy help.. Sad
 
View user's profile Send private message
chiroptera
PostPosted: Fri Mar 31, 2006 7:52 am Reply with quote
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
 
hitwalker
PostPosted: Fri Mar 31, 2006 7:57 am Reply with quote
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..
 
chiroptera
PostPosted: Mon Apr 03, 2006 3:51 am Reply with quote
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.

Question 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");





?>
 
hitwalker
PostPosted: Mon Apr 03, 2006 4:13 am Reply with quote
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.
 
chiroptera
PostPosted: Mon Apr 03, 2006 5:08 am Reply with quote
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
 
hitwalker
PostPosted: Mon Apr 03, 2006 5:11 am Reply with quote
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.
 
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona
PostPosted: Tue Apr 04, 2006 6:53 am Reply with quote
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.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
chiroptera
PostPosted: Tue Apr 04, 2006 8:50 am Reply with quote
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?
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules


 Jump to:   




View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©