Skip to content

MailConverter: Update Ticket Issue

My customer is trying to use the MailConverter to add incoming emails to existing Tickets using the "Update Ticket" action and the "Has Ticket Number" match.

Screenshot_from_2018-04-24_11-51-38

But when the process is trying to create the Comment to add to the Ticket it fails because there is no "assigned_to" value for the MailScannerRule object.

When you choose the "Update Ticket" action, the Assigned To field disappears so I would assume that the MailConverter would use either admin, or the owner of the Ticket... But I can't see anywhere where the MailScannerRule->assigned_to value is updated after initialisation...

Tue Apr 24 10:16:47 2018,757 [26529] DEBUG VT - Prepared sql query being executed : SELECT contactid FROM vtiger_contactdetails INNER JOIN vtiger_crmentity ON crmid = contactid WHERE
 setype = ? AND email = ? AND deleted = ?
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - Prepared sql query parameters : [Contacts,[email protected],0]
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - Caching Contact Id found for email: [email protected]
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - Caching Ticket [Test Ticket for Mail Converter]
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - Reusing Cached Contact Id for email: [email protected]
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - Entering getColumnFields(ModComments) method ...
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - in getColumnFields ModComments
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence
                FROM vtiger_field WHERE tabid in (?)
Tue Apr 24 10:16:47 2018,758 [26529] DEBUG VT - Prepared sql query parameters : [47]
Tue Apr 24 10:16:47 2018,759 [26529] DEBUG VT - Exiting getColumnFields method ...
Tue Apr 24 10:16:47 2018,759 [26529] INFO VT - PearDatabase ->TRANS Started
Tue Apr 24 10:16:47 2018,760 [26529] DEBUG VT - Prepared sql query being executed : insert into vtiger_crmentity (crmid,smcreatorid,smownerid,smgroupid,setype,description,modifiedby,
createdtime,modifiedtime,source) values(?,?,?,?,?,?,?,?,?,?)
Tue Apr 24 10:16:47 2018,760 [26529] DEBUG VT - Prepared sql query parameters : [16957,0,,0,ModComments,,0,2018-04-24 10:16:47,2018-04-24 10:16:47,CRM]
Tue Apr 24 10:16:47 2018,760 [26529] INFO VT - PearDatabase ->ADODB error  Query Failed:insert into vtiger_crmentity (crmid,smcreatorid,smownerid,smgroupid,setype,description,modifie
dby,createdtime,modifiedtime,source) values(?,?,?,?,?,?,?,?,?,?)::->[1048]Column 'smownerid' cannot be null
Tue Apr 24 10:16:47 2018,760 [26529] INFO VT - function insertIntoEntityTable ModComments vtiger_table name vtiger_modcomments