install of helpdesk don't works

[profwalken]

hi,
first i 'd like to know if phphelpdesk is running on xp pc with 1.70 version of wamp?

I dl the 1.02 on the web page of phphelpdesk , but nothing goes right . i have a index page with only images and log in button.
in footer of page the $title tag  stay visible with no name.

it's not possible to connect with admin user and password. it return's a 403 error forbidden.
if i try the url with wiz_start.php, that's an other error msg like in the msg from e944724a user.

So what can i do with all those problem ? let fall down and search other free product or is it possible to work with?

thanck a lot for all thoses who take part of time to answer me.

++
profwalken (sorry for mistakes i'm french)

[jackygrahamez]

I had a similar problem on WAMP. Now I'm trying it with Linux Centos 5
These errors show up in the logs when I open index.php
[Sat Apr 12 14:42:41 2008] [error] [client 144.171.126.227] PHP Notice:  Undefined variable: partfound in /var/www/html/languages/english.lang.php on line 256
[Sat Apr 12 14:42:41 2008] [error] [client 144.171.126.227] PHP Notice:  Undefined variable: p_id in /var/www/html/languages/english.lang.php on line 258
[Sat Apr 12 14:42:41 2008] [error] [client 144.171.126.227] PHP Notice:  Undefined variable: whattodo in /var/www/html/config/header.conf.php on line 8

When I actually hit Login
[Sat Apr 12 14:43:52 2008] [error] [client 144.171.126.227] PHP Notice:  Undefined variable: partfound in /var/www/html/languages/english.lang.php on line 256, referer: http://69.12.222.56/
[Sat Apr 12 14:43:52 2008] [error] [client 144.171.126.227] PHP Notice:  Undefined variable: p_id in /var/www/html/languages/english.lang.php on line 258, referer: http://69.12.222.56/
[Sat Apr 12 14:43:52 2008] [error] [client 144.171.126.227] PHP Notice:  Undefined variable: whattodo in /var/www/html/config/header.conf.php on line 8, referer: http://69.12.222.56/

[dave powell]

I am also having problems with the 1.0.2DEV version - like poster #1 I only get an index page with images, login buttons, and the "wizzard" link also is active. 

Logging in the 'admin' - 'admin' per the instructions just returns me to the same page.

Clicking the "wizzard" link pops out a browser with the following error from URL: phphelpdesk/wiz_start.php

Fatal error: Cannot redeclare ticketsummary() (previously declared in /usr/local/apache/htdocs/phphelpdesk/includes/functions.inc.php:16) in /usr/local/apache/htdocs/phphelpdesk/includes/functions.inc.php on line 61

Any help appreciated.
-DaveP

[dave powell]

Hey guys - check out this post:
https://sourceforge.net/forum/forum.php?thread_id=1205013&forum_id=17573

Here's the include.inc.php code with above referenced edits that at least got me somewhere:

<?php   // Global Functions

if( isset( $FUNCTIONS ) ) {
    return;
}

$FUNCTIONS=1;

include("includes/connect.inc.php");

/*
*  showSummary - Display current open tickets and open tickets for
*                the current user.
*/ 
if (!function_exists('ticketSummary')) {
function ticketSummary() {
   global $user, $mysql_link;
   $openTickets = 0;
   $userTickets = 0;
  
   $query = "SELECT events.e_id, events.t_id, events.e_status, " .
            "events.e_assignedto, ticket.t_id FROM events,ticket " .
            " WHERE events.t_id = ticket.t_id ORDER BY " .
        " events.t_id, events.e_id;";
   $result = query( $query );

   $row = mysql_fetch_row( $result );

   $prev_e_id = $row[0]; 
   $prev_t_id = $row[1]; 
   $prev_e_status = $row[2]; 
   $prev_e_assignedto = $row[3];

   $done = 0;
   while( !$done  ) {
       $row = mysql_fetch_row( $result );
       if( !$row ) {
           $done = 1;
       }
      
       $e_id = $row[0]; 
       $t_id = $row[1]; 
       $e_status = $row[2]; 
       $e_assignedto = $row[3];

       if( $t_id != $prev_t_id ) {
           if( $prev_e_status == "OPEN" ) {
           $openTickets++;
           if( $prev_e_assignedto == $user && isset($user) )
               $userTickets++;
       }
       }
      
       $prev_e_id = $e_id;
       $prev_t_id = $t_id;
       $prev_e_status = $e_status;
       $prev_e_assignedto = $e_assignedto;
   }
    $ticketarray[0]=$openTickets; //stuff the values into an array to hand themo over to the calling procedure
    $ticketarray[1]=$userTickets;
   return $ticketarray;
}
}

/*
*  query( $queryString ) Execute query on MySQL and report any errors
*
*  If $debug flag is set in config/general.conf.php, some debugging
*  information is printed such as the SQL statement sent to the back end.
*/
if (!function_exists('query')) {
function query( $q ) {
    global $mysql_link;
    global $debug;

    if( $debug >= 1 )
        echo "<br>Executed SQL:  <b>$q</b>";

    $result = mysql_query( $q, $mysql_link );
   
    unset( $error );
    $error = mysql_error( $mysql_link );
    if( $error )
        echo "<br><b>SQL ERROR: </b>$error<br>";

    if( $debug >= 1 )
    echo " (" . (0+mysql_affected_rows($mysql_link)) . " rows affected.)<br>";
     return $result;
}
}

/*
* heading( $headingText )
*
* This function prints a heading on the page.  This is intended to
* make a consistant heading style for all pages within the helpdesk.
*/
if (!function_exists('heading')) {
function heading( $text, $center ) {
    if( $center ) print "<center>";
    print "<hr><h1>$text</h1><hr>";
    if( $center ) print "</center>";
}
}

/*
* timestampToUnix( $timestamp )
*
* Converts a MySQL timestamp to a unix integer date.
*/
if (!function_exists('timestampToUnix')) {
function timestampToUnix( $t ) {
    $YYYY = $MM = $DD = $hh = $mm = 0;
   
    $YYYY = "$t[0]$t[1]$t[2]$t[3]";
    $MM = "$t[4]$t[5]";
    $DD = "$t[6]$t[7]";
    $hh = "$t[8]$t[9]";
    $mm = "$t[10]$t[11]";
   
    return strtotime("$YYYY-$MM-$DD $hh:$mm:00");
}
}
// this function is for determining the next ticket id.
if (!function_exists('getnextticketid')) {
function getnextticketid($for_department) {
// find out about last
    $old_id=0;
    $query = "SELECT t_et_id FROM ticket WHERE t_department = '$for_department' ";
    $query .= "ORDER BY t_et_id DESC;";
    $mysqlresult = query($query);
    $row = mysql_fetch_row($mysqlresult);
    list ($depcode,$curr_id) = split('[-]',$row[0]);
    if ($curr_id == NULL) { // in case it is the first ticket for the department
        $et_id = 0;
        // get the dep_key
        $query = "SELECT d_depkey FROM department WHERE d_name = '$for_department';";
        $mysqlresult = query($query);
        $key_row = mysql_fetch_row($mysqlresult);
        $depcode =$key_row[0];       
    }
    else { $et_id = $curr_id; }
    //echo "row: $row[0],depcore:$depcode,curid: $curr_id, etid:$et_id";
    $et_id++;   
    $et_id = "$depcode-$et_id";
return ($et_id);
}
}

?>