Install Errors + DB error #1064

dscurlock

I seem to be getting a number of errors...

PHP Warning: session_start() : Cannot send session cookie - headers already sent in /home/minnesot/public_html/support/main.inc.php on line 46

PHP Warning: session_start() : Cannot send session cache limiter - headers already sent in /home/minnesot/public_html/support/main.inc.php on line 46

Now I have seen this all the way back from 2008 - but I have yet to run across any useful info on how to solve this...is this a user issue or administration issue?

When the notify box is check - the system does not work at all, when I uncheck the box, then I do get the incoming email, but no replies are sent out.

I am also getting a DB Error #1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 71.1.94.130

can someone actually help with this, or will i see

this go unanswered like so many others asking

for this type of help?

Thanks

David

jmutschler

Fixed: DB Error #1064

This was driving me nuts, the db errors are generated when a staff member checks off a ticket on the main tickets screen and then clicks the delete button and then refreshes the page. When the information is posted to the server again it attempts to delete tickets, however there are none selected. If you make the following change to the delete() function in include\class.ticket.php the errors will no-longer occur.

OLD:

function delete(){

if(db_query('DELETE FROM '.TICKET_TABLE.' WHERE ticket_id='.$this->getId()) && db_affected_rows()):

db_query('DELETE FROM '.TICKET_MESSAGE_TABLE.' WHERE ticket_id='.db_input($this->getId()));

db_query('DELETE FROM '.TICKET_RESPONSE_TABLE.' WHERE ticket_id='.db_input($this->getId()));

db_query('DELETE FROM '.TICKET_NOTE_TABLE.' WHERE ticket_id='.db_input($this->getId()));

$this->deleteAttachments();

return TRUE;

endif;

return FALSE;

}

NEW: