eTicket postfix problem with

First off, if anyone can suggest another ticket system that
has eTicket / osTicket features please let me know.

I can’t seem to find the answer to this problem.

Followed these instructions on the Wiki (Email to Script).

  • create new ssh user, create mailbox
  • created .forward.postfix in /home/supportmail
    "| /home/supportmail/eTicket/"

Email sent to supportmail@ returns with :

The Postfix program (expanded from Command died with status 255: “
/home/supportmail/eTicket/”. Command output: DBD::mysql::st
execute failed: Column ‘cat’ cannot be null at
/home/supportmail/eTicket/ line 578. Column ‘cat’ cannot be null
at /home/supportmail/eTicket/ line 578.

I’ve searched and Google with no good resolution.

Thanks in advance.


Temp fix :

line 577 and 578 remove $cat and one “?” in valuse

$sth = $dbh->prepare(“INSERT INTO ticket_messages (ticket, message, headers, timestamp) VALUES (?, ?, ?, FROM_UNIXTIME(?))”) or die $dbh->errstr
$sth->execute($ticket, $body, $eml_headers, $gmtime) or die $dbh->errstr;