Skip to content

Can't update ticket from mail scanner.

Anything around tickets in mailscanner is failing due to the following incorrect query.

Sun Nov 19 05:18:47 2017,495 [110031] INFO VT - PearDatabase ->ADODB error Query Failed: Unknown column 'vtiger_helpdesk_user_field.starred' in 'field list'

SELECT
    vtiger_troubletickets.ticket_no AS vtiger_troubleticketsticket_no,
    vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,
    vtiger_troubletickets.parent_id AS vtiger_troubleticketsparent_id,
    vtiger_troubletickets.priority AS vtiger_troubleticketsticketpriorities,
    vtiger_troubletickets.product_id AS vtiger_troubleticketsproduct_id,
    vtiger_troubletickets.status AS vtiger_troubleticketsticketstatus,
    vtiger_troubletickets.category AS vtiger_troubleticketsticketcategories,
    vtiger_troubletickets.hours AS vtiger_troubleticketshours,
    vtiger_troubletickets.days AS vtiger_troubleticketsdays,
    vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,
    vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,
    vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,
    vtiger_troubletickets.title AS vtiger_troubleticketsticket_title,
    vtiger_crmentity.description AS vtiger_crmentitydescription,
    vtiger_troubletickets.solution AS vtiger_troubleticketssolution,
    vtiger_troubletickets.contact_id AS vtiger_troubleticketscontact_id,
    vtiger_ticketcf.from_portal AS vtiger_ticketcffrom_portal,
    vtiger_crmentity.smcreatorid AS vtiger_crmentitycreated_user_id,
    vtiger_ticketcf.cf_751 AS vtiger_ticketcfcf_751,
    vtiger_crmentity.source AS vtiger_crmentitysource,
    vtiger_helpdesk_user_field.starred AS vtiger_helpdesk_user_fieldstarred,
    vtiger_troubletickets.tags AS vtiger_troubleticketstags,
    vtiger_crmentity.deleted,
    vtiger_crmentity.label
FROM
    vtiger_crmentity
LEFT JOIN vtiger_troubletickets ON(
        vtiger_troubletickets.ticketid = vtiger_crmentity.crmid
    )
LEFT JOIN vtiger_ticketcf ON(
        vtiger_ticketcf.ticketid = vtiger_crmentity.crmid
    )
LEFT JOIN vtiger_ticketcomments ON(
        vtiger_ticketcomments.ticketid = vtiger_crmentity.crmid
    )
WHERE
    vtiger_crmentity.crmid = 35409
LIMIT 1