Not inserting a JOB-Log file shows no error

[siyaverma]

Hi ,

I am trying to add a job and my tool is working all fine but not inserting a job into job table and log file is not giving any error ,i am unable to understand where is the problem,please help.

this is log file giving when i try to add a job(using 123 as IP address this is the code for log file

select: 'select section_id from wjtp_sectionaction where actionname='AddJob''
2008-01-14    (DEBUG) 123[BaseAction.class.php] - Creating instance of action AddJob...
2008-01-14   (DEBUG) 123[BaseAction.class.php] - ...instance of AddJob created
2008-01-14    (DEBUG) 123[Mysql.class.php] - Executing SQL select: 'select value from wjtp_ustate where person_id=3 and dataset_id is null and display='' and action='' and name='lastdisplay' limit 1'
2008-01-14   (DEBUG) 123[Mysql.class.php] - Executing SQL: 'delete from wjtp_ustate where person_id=3 and dataset_id is null and display='AddJob' and action='' and name='prevparms''
2008-01-14   (DEBUG) 123[Mysql.class.php] - Executing SQL: 'insert into wjtp_ustate (createdon,person_id,dataset_id,display,action,name,data)values(now(),3,null,'AddJob','','prevparms','a:18:{s:6:\"action\";s:12:\"AddJobAction\";s:7:\"display\";s:10:\"BrowseJobs\";s:9:\"returnurl\";s:28:\"index.php%3Fdisplay%3DAddJob\";s:8:\"d_emails\";s:1:\"3\";s:8:\"a_emails\";s:3:\"4,5\";s:4:\"area\";s:8:\"PSLGroup\";s:10:\"jobtype_id\";s:1:\"7\";s:6:\"needby\";s:10:\"01/21/2008\";s:13:\"department_id\";s:1:\"9\";s:11:\"assignee_id\";s:1:\"5\";s:11:\"priority_id\";s:1:\"2\";s:5:\"title\";s:19:\"List Request of HAB\";s:11:\"description\";s:16:\"HAB List Request\";s:22:\"attachment_description\";s:0:\"\";s:16:\"attachment_count\";s:1:\"0\";s:9:\"d_d_count\";s:1:\"1\";s:9:\"a_d_count\";s:1:\"2\";s:10:\"ccassignee\";s:1:\"Y\";}')'
2008-01-14  (DEBUG) 123[BaseAction.class.php] - Performing action AddJob...
2008-01-14   (DEBUG) 123[Mysql.class.php] - Executing SQL select: 'select nickname,lastname,email from wjtp_person where id=3 limit 1'
2008-01-14   (DEBUG) 123[User.class.php] - Checking to see if 'admin' is a contact...
2008-01-14   (DEBUG) 123[Mysql.class.php] - Executing SQL select: 'select * from wjtp_contact where id=3 limit 1'
2008-01-14  (DEBUG) 123[User.class.php] -     ...user is NOT a contact.
2008-01-14  (DEBUG) 123[User.class.php] - Checking for administrator rights for 'admin'...
2008-01-14  (DEBUG) 123[Mysql.class.php] - Executing SQL select: 'select * from wjtp_personsection left join wjtp_section on (id = section_id) where person_id=3 and admin='Y''
2008-01-14  (DEBUG) 123[User.class.php] -     ...administrator rights GRANTED!  Remember: With great power comes great responsibility.
2008-01-14   (DEBUG)123[Mysql.class.php] - Executing SQL select: 'select * from wjtp_person where id=5 limit 1'
2008-01-14   (DEBUG)123[Mysql.class.php] - Executing SQL: 'insert into wjtp_job set createdon=now(), createdby=3, updatedby=3, updatedon=now(), status_id=2, title='List Request of HAB', description='HAB List Request', needby='2008-01-21', last_ip=123, last_port='', area='PSLGroup', department_id=9, cat_id=null, priority_id=2, assignedto=5, assignedon=now(), jobtype_id = 7'

after this it don't perform any action ,but rest of the application working fine,and the php coding is given below ,i am not using the organization,i have turned off the set organization in ini.file please see the 1st reply for PHP coding

Thanks
Siya

[siyaverma]

class AddJobAction extends AddAction
{

function getName()
{
    return "AddJob";
}

function doPerform( &$req )
{
    	    # Who's performing this action?
    $person_id = $this->context->user->getId();
    $sql = "select nickname,lastname,email from ".W_TBL."person where id=".$person_id;
    $person = $this->context->db->select_one( $sql );
    $personname = $person["nickname"]." ".$person["lastname"];
    $personemail = $person["email"];

    # Set next display
    $this->setDisplay( "JobDetails" );

    # Get some config info.
    $readonly_except_admin = $this->context->config->get( "readonly_except_admin" );
    $strict_readonly_except_admin = $this->context->config->get( "strict_readonly_except_admin" );
    $use_departments = $this->context->config->get( "use_departments" );
    $strict_departments = $this->context->config->get( "strict_departments" );
    $semistrict_departments = $this->context->config->get( "semistrict_departments" );
    $use_custom_fields = $this->context->config->get( "use_custom_fields" );
    $strict_custom_fields = $this->context->config->get( "strict_custom_fields" );
    $time_and_expenses = $this->context->config->get( "time_and_expenses" );
    $use_organizations = $this->context->config->get( "use_organizations" );
    $use_area = $this->context->config->get( "use_area" );

    # Make sure title, and description have been entered.
    $title = $req->get( "title" );
    $description = $req->get( "description" );
    if( ! $title )
    {
        $this->redisplay();
        $this->setMessage( "Sorry, you must specify a title!  Aborting..." );
        return;
    }
    if( ! $description )
    {
        $this->redisplay();
        $this->setMessage( "Sorry, you must specify a description!  Aborting..." );
        return;
    }
    # Support old field
    if( $this->context->config->get( "use_area" ) )
    {
        $area = $req->get( "area" );
    }

    # Get or set department.
    if( $use_departments
      && ! $this->context->user->isContact()
      && (  ! $strict_departments 
         || ( $strict_departments 
            && $this->context->user->isAdmin()
            )
         )
      && (  ! $semistrict_departments 
         || ( $semistrict_departments 
            && ( $this->context->user->isAdmin() || $this->context->user->isTech() )
            )
         )
      )
    {
        $department_id = $req->getInteger( "department_id" );
    }
    else
    {
        $department_id = $this->context->user->get( "department_id" );
    }
    # Use "null" if department_id not set.
    $department_id = $department_id ? $department_id : "null";

    # Get assignee, if appropriate.
    if( ! $this->context->user->isContact() )
    {
        $assignee_id = $req->get( "assignee_id" );
        if( $assignee_id )
        {
            $assignee = $this->context->db->select_one( "select * from ".W_TBL."person where id=$assignee_id" );
        }
    }
    # See if the assignment is compatible with current settings
    if(  $use_departments
      && $assignee["department_id"] != $department_id
      && (  (  $strict_departments 
            && ! $this->context->user->isAdmin()
            )
         || (  $semistrict_departments 
            && ! $this->context->user->isAdmin()
            && ! $this->context->user->isTech()
            )
         )
      )
    {
        $assignee_id = NULL;
    }
    $assignee_id = $assignee_id ? $assignee_id : "null";

        # Other information
    $cat_id = $req->getKey( "cat_id" );
    if( $this->context->user->isAdmin() || $this->context->user->isTech() )
    {
        $priority_id = $req->getInteger( "priority_id" );
    }
    else
    {
        $priority_id = $this->context->config->get( "default_job_priority" );
    }
    $priority_id = $priority_id ? $priority_id : "null";

#insert job type
       $jobtype_id = $req->getInteger( "jobtype_id" );
	   //echo $jobtype_id;

    # Get and reformat needby date
    $needby = $req->get( "needby" );
    if( $needby )
    {
        if( "us" == $this->context->config->get( "date_format" ) )
        {
            list( $m, $d, $y ) = explode( "/", $needby );
        }
        else
        {
            list( $d, $m, $y ) = explode( "/", $needby );
        }
        $needby = "'".$y."-".$m."-".$d."'";
    }
    else
    {
        $needby = "null";
    }

    if( ! $assignee_id || "null" == $assignee_id )
    {
        $status_id = $this->context->config->get( "unassigned_job_status_id" );
        $status_id = $status_id ? $status_id : 1;
        $assignedon = "null";
        $updatedon = "null";
        $updatedby = "null";
    }
    else
    {
        $status_id = $this->context->config->get( "assigned_job_status_id" );
        $status_id = $status_id ? $status_id : 2;
        $assignedon = "now()";
        $updatedon = "now()";
        $updatedby = $this->person_id;
    }
    # Begin db transaction
    $this->context->db->begin();

    # Main insert
    if( ! $error )
    {
        $sqlarray = array( "createdon=now()",
                           "createdby=".$this->person_id,
                           "updatedby=$updatedby",
                           "updatedon=$updatedon",
                           "status_id=$status_id",
                           "title='$title'",
                           "description='$description'",
                           "needby=$needby",
                           "last_ip='".$req->getIp()."'",
                           "last_port='".$req->getPort()."'"
                         );

        if( $this->context->config->get( "use_area" ) )
        {
            $sqlarray[] = "area='$area'";
        }
        if( $this->context->config->get( "use_organizations" ) )
        {
            $sqlarray[] = "organization_id=$organization_id";
        }
        if( $this->context->config->get( "use_departments" ) )
        {
            $sqlarray[] = "department_id=$department_id";
        }
        if( ! $this->context->user->isContact() )
        {
            $sqlarray[] = "cat_id=$cat_id";
        }
        if( $this->context->user->isAdmin() || $this->context->user->isTech() )
        {
            $sqlarray[] = "priority_id=$priority_id";
        }
        if( $this->context->user->isAdmin() || $this->context->user->isTech() || ( $assignee_id == $person_id ) )
        {
            $sqlarray[] = "assignedto=$assignee_id";
            $sqlarray[] = "assignedon=$assignedon";
        }

		$sqlarray[] = "jobtype_id = $jobtype_id";

        $sql = "insert into ".W_TBL."job set ".join( ", ", $sqlarray );
        $this->context->db->execute( $sql );
        $error = $this->context->db->last_error();
    }

    # The new job id.
    $id = $this->context->db->last_insert_id();
    $req->set( "id", $id );

This is the main insert coding ,Please Please i have a hard time finding it out ,Please help to find out where the problem is?