PDA

View Full Version : ticketsmith - problem with HTML emails


amitrana
27-04-04, 05:46 PM
Hi,
I am having problem with client followup emails if the mails have HTML. In these cases gateway.pl is unable to extract body of the email which causes insert query to fail.

problem: After client replies to acknowledgement of the original request, client recieves acknowledgement for a new ticket #0
email report goes correctly.

there is no ticket#0 in the system

gaeway.pl can update the original ticket but the insert for new ticket was failing. I printed the sql error it was "Column 'body' cannot be null "

In order to avoid this and make it run I put $body = ""; as first line of "sub get_body", after this addition insert query was not failing.

I also tried to print $attachement_info variable it has value Content-Type: multipart/alternative;boundary="----=_NextPart_000_010B_01C42C72.EC21F9C0

Please advice what should I do to get this to work?

thanks,
amit.

ajdonnison
28-04-04, 09:18 AM
This is fixed in the CVS. Download the new gateway.pl and install.

amitrana
28-04-04, 11:07 AM
Thanks for your quick action.

I also posted a small patch on the sourceforge site for gateway.pl for another small issue. I saw that "resolution" for all the patches submitted so far was open. Are we still using sourceforge for patches etc or shall I repost that here.

Thanks,
Amit.

Karen
28-04-04, 11:14 AM
Thanks for the patch Amit - we're currently leaving them on Sourceforge and as they are committed across to the CVS we'll announce them in the patch forum here.

Thanks again for the help.

Karen C