Thanks for the input. On the other places that I have posted, they also said the same thing. Three in a row...guess someone must know what their doing even if I don't. 🙂
I changed it and that changed the error message I am getting now, but it hasn't cured it as yet. The error I am now getting is as follows:
Warning: Cannot add header information - headers already sent by (output started at /home/affiliat/public_html/helpdesk/includes/functions.inc.php:75) in /home/affiliat/public_html/helpdesk/includes/cookie.inc.php on line 8
For some reason it makes a call back to the functions.inc.php. I have seen this error before when I dabbled with the different settings in the cookie.inc.php and couldn't find anything that might generate such an error inside of that script. It also is relatively small in comparison to some parts of the script and its content is as below:
<?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.
/
function showSummary() {
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;
}
print "Open Tickets: $openTickets<br>\n";
print "Assigned to you: $userTickets<br>\n";
}
/
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.
/
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.
/
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.
*/
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");
}
?>
Now if I can figure this out and lock the problem down, I can put this thing back together again. Never realize how much you are dependent on something until its broke.
In answer to your question, yes, they did change something recently. I know that they said a couple of weeks ago they upgraded the PHP version to 4.2 because of security holes in the previous version. I had thought that the most recent version was 4.6, but maybe I am offbase. In any case, if someone out there can see something I don't, I would greatly appreciate it.
Cliff Warren
Service Manager and Webmaster
www.affiliatedvoice.com