eTicket postfix problem with automail.pl

apps

#1

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/automail.pl"

Email sent to supportmail@ returns with :

The Postfix program

supportmail@spaceymail-mx2.g.dreamhost.com (expanded from
supportmail@provingzone.com): Command died with status 255: “
/home/supportmail/eTicket/automail.pl”. Command output: DBD::mysql::st
execute failed: Column ‘cat’ cannot be null at
/home/supportmail/eTicket/automail.pl line 578. Column ‘cat’ cannot be null
at /home/supportmail/eTicket/automail.pl line 578.

I’ve searched http://osticketcommunity.ath.cx/trac/ and Google with no good resolution.

Thanks in advance.

-lgm


#2

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;