php - vTiger 7 邮件转换器更新票证时出现问题

Question

邮件转换器和更新票证存在问题，据我所知，它在缺少链接表的查询上失败，在打开调试并运行邮件转换器后，这是它返回的查询:

INFO VT - PearDatabase ->ADODB error Query Failed: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.status AS vtiger_troubleticketsticketstatus,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_779 AS vtiger_ticketcfcf_779,vtiger_ticketcf.cf_781 AS vtiger_ticketcfcf_781,vtiger_ticketcf.cf_787 AS vtiger_ticketcfcf_787,vtiger_ticketcf.cf_791 AS vtiger_ticketcfcf_791,vtiger_ticketcf.cf_805 AS vtiger_ticketcfcf_805,vtiger_ticketcf.cf_811 AS vtiger_ticketcfcf_811,vtiger_crmentity.cf_viewname AS vtiger_crmentitycf_viewname,vtiger_ticketcf.cf_910 AS vtiger_ticketcfcf_910,vtiger_ticketcf.cf_916 AS vtiger_ticketcfcf_916,vtiger_ticketcf.cf_920 AS vtiger_ticketcfcf_920,vtiger_ticketcf.cf_922 AS vtiger_ticketcfcf_922,vtiger_ticketcf.cf_924 AS vtiger_ticketcfcf_924,vtiger_ticketcf.cf_934 AS vtiger_ticketcfcf_934,vtiger_ticketcf.cf_936 AS vtiger_ticketcfcf_936,vtiger_ticketcf.cf_938 AS vtiger_ticketcfcf_938,vtiger_ticketcf.cf_940 AS vtiger_ticketcfcf_940,vtiger_ticketcf.cf_942 AS vtiger_ticketcfcf_942,vtiger_ticketcf.cf_944 AS vtiger_ticketcfcf_944,vtiger_ticketcf.cf_950 AS vtiger_ticketcfcf_950,vtiger_ticketcf.cf_966 AS vtiger_ticketcfcf_966,vtiger_ticketcf.cf_968 AS vtiger_ticketcfcf_968,vtiger_ticketcf.cf_970 AS vtiger_ticketcfcf_970,vtiger_ticketcf.cf_972 AS vtiger_ticketcfcf_972,vtiger_ticketcf.cf_974 AS vtiger_ticketcfcf_974,vtiger_ticketcf.cf_976 AS vtiger_ticketcfcf_976,vtiger_ticketcf.cf_978 AS vtiger_ticketcfcf_978,vtiger_ticketcf.cf_980 AS vtiger_ticketcfcf_980,vtiger_ticketcf.cf_986 AS vtiger_ticketcfcf_986,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=? LIMIT 1::->[1054]Unknown column 'vtiger_helpdesk_user_field.starred' in 'field list'

您会注意到，FROM 列表中缺少 vtiger_helpdesk_user_field 表，如果我手动运行此查询，添加缺少的表，则查询运行正常，我的问题是，这是一个错误吗？或者任何人都可以建议我如何进行操作关于解决这个问题。

干杯，伙计们。

Answer 1

安装过程中未创建问题表 vtiger_helpdesk_user_field。

创建这个缺失的表将修复错误，这是正确的方法