| Server IP : 138.197.176.125 / Your IP : 216.73.216.41 Web Server : Apache/2.4.41 (Ubuntu) System : Linux SuiteCRM-8 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : root ( 0) PHP Version : 8.3.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/suitesupport.varianceinfotech.net/logs/ |
Upload File : |
Fri Sep 15 05:36:22 2023,667 [1761707] DEBUG VT - Entering getColumnFields(ServiceContracts) method ... Fri Sep 15 05:36:22 2023,667 [1761707] DEBUG VT - in getColumnFields ServiceContracts Fri Sep 15 05:36:22 2023,667 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,667 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_field WHERE tabid=? ORDER BY sequence Fri Sep 15 05:36:22 2023,667 [1761707] DEBUG VT - Prepared sql query parameters : [37] Fri Sep 15 05:36:22 2023,670 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,671 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,672 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,672 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,673 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,673 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,674 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,674 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,674 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,674 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,674 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,674 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,674 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,675 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,676 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,677 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,678 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,678 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,678 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,678 [1761707] DEBUG VT - Prepared sql query parameters : [93] Fri Sep 15 05:36:22 2023,680 [1761707] DEBUG VT - Prepared sql query being executed : SELECT fieldname, tablename, entityidfield FROM vtiger_entityname WHERE tabid = ? Fri Sep 15 05:36:22 2023,680 [1761707] DEBUG VT - Prepared sql query parameters : [37] Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - Entering getColumnFields(ServiceContracts) method ... Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - in getColumnFields ServiceContracts Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,681 [1761707] INFO VT - PearDatabase ->ADODB disconnect Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - Entering getColumnFields(ServiceContracts) method ... Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - in getColumnFields ServiceContracts Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,681 [1761707] DEBUG VT - Prepared sql query parameters : [ServiceContracts] Fri Sep 15 05:36:22 2023,682 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,682 [1761707] DEBUG VT - Prepared sql query parameters : [37,93] Fri Sep 15 05:36:22 2023,685 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,685 [1761707] DEBUG VT - Prepared sql query parameters : [571] Fri Sep 15 05:36:22 2023,685 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,685 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,686 [1761707] DEBUG VT - Prepared sql query being executed : SELECT COUNT(DISTINCT vtiger_crmentity.crmid) AS count FROM vtiger_servicecontracts INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_servicecontracts.servicecontractsid LEFT JOIN vtiger_servicecontractscf ON vtiger_servicecontractscf.servicecontractsid = vtiger_servicecontracts.servicecontractsid INNER JOIN vtiger_contactdetails AS vtiger_contactdetailsContacts ON vtiger_contactdetailsContacts.contactid = vtiger_servicecontracts.sc_related_to LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_contactdetailsContacts.contactid = 171144 Fri Sep 15 05:36:22 2023,687 [1761707] DEBUG VT - Prepared sql query being executed : SELECT vtiger_relatedlists.*,vtiger_tab.name as modulename FROM vtiger_relatedlists INNER JOIN vtiger_tab on vtiger_tab.tabid = vtiger_relatedlists.related_tabid AND vtiger_tab.presence != 1 WHERE vtiger_relatedlists.tabid = ? AND related_tabid = ? AND label = ? Fri Sep 15 05:36:22 2023,687 [1761707] DEBUG VT - Prepared sql query parameters : [4,42,Projects] Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - Prepared sql query being executed : SELECT name FROM vtiger_tab WHERE tabid = ? Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,688 [1761707] DEBUG VT - Entering getColumnFields(Project) method ... Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - in getColumnFields Project Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - Entering getColumnFields(Project) method ... Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - in getColumnFields Project Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relationfieldid FROM vtiger_relatedlists WHERE relation_id=? Fri Sep 15 05:36:22 2023,689 [1761707] DEBUG VT - Prepared sql query parameters : [125] Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, columnname,tablename FROM vtiger_field WHERE uitype='10' AND fieldid IN (SELECT relationfieldid FROM vtiger_relatedlists WHERE relation_id=?) Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Prepared sql query parameters : [125] Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Entering getColumnFields(Project) method ... Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - in getColumnFields Project Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Entering getColumnFields(Project) method ... Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - in getColumnFields Project Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_field WHERE tabid=? ORDER BY sequence Fri Sep 15 05:36:22 2023,690 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query parameters : [106] Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query parameters : [105] Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,691 [1761707] DEBUG VT - Prepared sql query parameters : [105] Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query parameters : [105] Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,692 [1761707] DEBUG VT - Prepared sql query parameters : [105] Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query parameters : [105] Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query parameters : [105] Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,693 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query parameters : [105] Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,694 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,695 [1761707] DEBUG VT - Prepared sql query parameters : [104] Fri Sep 15 05:36:22 2023,696 [1761707] DEBUG VT - Prepared sql query being executed : SELECT fieldname, tablename, entityidfield FROM vtiger_entityname WHERE tabid = ? Fri Sep 15 05:36:22 2023,696 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - Entering getColumnFields(Project) method ... Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - in getColumnFields Project Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - Entering getColumnFields(Project) method ... Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - in getColumnFields Project Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,701 [1761707] DEBUG VT - Prepared sql query parameters : [Project] Fri Sep 15 05:36:22 2023,702 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,702 [1761707] DEBUG VT - Prepared sql query parameters : [42,104,105,106] Fri Sep 15 05:36:22 2023,704 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,704 [1761707] DEBUG VT - Prepared sql query parameters : [631] Fri Sep 15 05:36:22 2023,705 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,705 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,705 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,705 [1761707] DEBUG VT - Prepared sql query parameters : [851] Fri Sep 15 05:36:22 2023,706 [1761707] DEBUG VT - Prepared sql query being executed : SELECT COUNT(DISTINCT vtiger_crmentity.crmid) AS count FROM vtiger_project INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_project.projectid LEFT JOIN vtiger_projectcf ON vtiger_projectcf.projectid = vtiger_project.projectid INNER JOIN vtiger_contactdetails AS vtiger_contactdetailsContacts ON vtiger_contactdetailsContacts.contactid = vtiger_project.linktoaccountscontacts LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_contactdetailsContacts.contactid = 171144 Fri Sep 15 05:36:22 2023,707 [1761707] DEBUG VT - Prepared sql query being executed : SELECT vtiger_relatedlists.*,vtiger_tab.name as modulename FROM vtiger_relatedlists INNER JOIN vtiger_tab on vtiger_tab.tabid = vtiger_relatedlists.related_tabid AND vtiger_tab.presence != 1 WHERE vtiger_relatedlists.tabid = ? AND related_tabid = ? AND label = ? Fri Sep 15 05:36:22 2023,707 [1761707] DEBUG VT - Prepared sql query parameters : [4,43,ModComments] Fri Sep 15 05:36:22 2023,708 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,708 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,708 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,708 [1761707] DEBUG VT - Prepared sql query parameters : [43] Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Prepared sql query parameters : [ModComments] Fri Sep 15 05:36:22 2023,709 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,710 [1761707] DEBUG VT - Prepared sql query parameters : [43,107,108] Fri Sep 15 05:36:22 2023,710 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,710 [1761707] DEBUG VT - Prepared sql query parameters : [649] Fri Sep 15 05:36:22 2023,711 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,711 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,711 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,711 [1761707] DEBUG VT - Prepared sql query parameters : [651] Fri Sep 15 05:36:22 2023,712 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,712 [1761707] DEBUG VT - Prepared sql query parameters : [714] Fri Sep 15 05:36:22 2023,712 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,712 [1761707] DEBUG VT - Prepared sql query parameters : [733] Fri Sep 15 05:36:22 2023,713 [1761707] DEBUG lead - Entering Leads() method ... Fri Sep 15 05:36:22 2023,713 [1761707] DEBUG VT - Entering getColumnFields(Leads) method ... Fri Sep 15 05:36:22 2023,713 [1761707] DEBUG VT - in getColumnFields Leads Fri Sep 15 05:36:22 2023,713 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,713 [1761707] DEBUG VT - Prepared sql query parameters : [7] Fri Sep 15 05:36:22 2023,714 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,714 [1761707] DEBUG lead - Exiting Lead method ... Fri Sep 15 05:36:22 2023,714 [1761707] DEBUG VT - Entering getColumnFields(Leads) method ... Fri Sep 15 05:36:22 2023,714 [1761707] DEBUG VT - in getColumnFields Leads Fri Sep 15 05:36:22 2023,714 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,714 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,714 [1761707] DEBUG VT - Prepared sql query parameters : [Leads] Fri Sep 15 05:36:22 2023,715 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,715 [1761707] DEBUG VT - Prepared sql query parameters : [7,13,15,16] Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,717 [1761707] DEBUG VT - Prepared sql query parameters : [Contacts] Fri Sep 15 05:36:22 2023,718 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?,?,?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,718 [1761707] DEBUG VT - Prepared sql query parameters : [4,4,6,7,8,73] Fri Sep 15 05:36:22 2023,719 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,720 [1761707] DEBUG VT - Prepared sql query parameters : [21] Fri Sep 15 05:36:22 2023,722 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,722 [1761707] DEBUG VT - Prepared sql query parameters : [22] Fri Sep 15 05:36:22 2023,722 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,722 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,724 [1761707] DEBUG VT - Entering getColumnFields(Accounts) method ... Fri Sep 15 05:36:22 2023,724 [1761707] DEBUG VT - in getColumnFields Accounts Fri Sep 15 05:36:22 2023,724 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,724 [1761707] DEBUG VT - Prepared sql query parameters : [6] Fri Sep 15 05:36:22 2023,725 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,725 [1761707] DEBUG VT - Entering getColumnFields(Accounts) method ... Fri Sep 15 05:36:22 2023,725 [1761707] DEBUG VT - in getColumnFields Accounts Fri Sep 15 05:36:22 2023,725 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,725 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,725 [1761707] DEBUG VT - Prepared sql query parameters : [Accounts] Fri Sep 15 05:36:22 2023,726 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,726 [1761707] DEBUG VT - Prepared sql query parameters : [6,9,11,12] Fri Sep 15 05:36:22 2023,727 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,727 [1761707] DEBUG VT - Prepared sql query parameters : [21] Fri Sep 15 05:36:22 2023,728 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,728 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,729 [1761707] DEBUG VT - Entering getColumnFields(ProjectTask) method ... Fri Sep 15 05:36:22 2023,729 [1761707] DEBUG VT - in getColumnFields ProjectTask Fri Sep 15 05:36:22 2023,729 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,729 [1761707] DEBUG VT - Prepared sql query parameters : [41] Fri Sep 15 05:36:22 2023,729 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,730 [1761707] DEBUG VT - Entering getColumnFields(ProjectTask) method ... Fri Sep 15 05:36:22 2023,730 [1761707] DEBUG VT - in getColumnFields ProjectTask Fri Sep 15 05:36:22 2023,730 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,730 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,730 [1761707] DEBUG VT - Prepared sql query parameters : [ProjectTask] Fri Sep 15 05:36:22 2023,730 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,730 [1761707] DEBUG VT - Prepared sql query parameters : [41,101,102,103] Fri Sep 15 05:36:22 2023,731 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,731 [1761707] DEBUG VT - Prepared sql query parameters : [610] Fri Sep 15 05:36:22 2023,733 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,733 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG faq - Entering Faq() method ... Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Entering getColumnFields(Faq) method ... Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - in getColumnFields Faq Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Prepared sql query parameters : [15] Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG faq - Exiting Faq method ... Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Entering getColumnFields(Faq) method ... Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - in getColumnFields Faq Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,734 [1761707] DEBUG VT - Prepared sql query parameters : [Faq] Fri Sep 15 05:36:22 2023,735 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,735 [1761707] DEBUG VT - Prepared sql query parameters : [15,37] Fri Sep 15 05:36:22 2023,736 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,736 [1761707] DEBUG VT - Prepared sql query parameters : [33] Fri Sep 15 05:36:22 2023,736 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,737 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,738 [1761707] DEBUG user - Entering Users() method ... Fri Sep 15 05:36:22 2023,738 [1761707] DEBUG VT - Entering getColumnFields(Users) method ... Fri Sep 15 05:36:22 2023,738 [1761707] DEBUG VT - in getColumnFields Users Fri Sep 15 05:36:22 2023,738 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,738 [1761707] DEBUG user - Exiting Users() method ... Fri Sep 15 05:36:22 2023,738 [1761707] DEBUG VT - Entering getColumnFields(Users) method ... Fri Sep 15 05:36:22 2023,738 [1761707] DEBUG VT - in getColumnFields Users Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Prepared sql query being executed : select name_fields from vtiger_ws_entity_name where entity_id = ? Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Prepared sql query parameters : [20] Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,739 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,740 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Entering getColumnFields(ModComments) method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - in getColumnFields ModComments Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,741 [1761707] DEBUG VT - Prepared sql query being executed : SELECT COUNT(DISTINCT vtiger_crmentity.crmid) AS count FROM vtiger_modcomments INNER JOIN vtiger_crmentity ON vtiger_modcomments.modcommentsid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid WHERE vtiger_crmentity.deleted=0 AND vtiger_modcomments.modcommentsid > 0 AND related_to = 171144 ORDER BY vtiger_crmentity.createdtime DESC Fri Sep 15 05:36:22 2023,742 [1761707] DEBUG VT - Prepared sql query being executed : SELECT vtiger_relatedlists.*,vtiger_tab.name as modulename FROM vtiger_relatedlists INNER JOIN vtiger_tab on vtiger_tab.tabid = vtiger_relatedlists.related_tabid AND vtiger_tab.presence != 1 WHERE vtiger_relatedlists.tabid = ? AND related_tabid = ? AND label = ? Fri Sep 15 05:36:22 2023,743 [1761707] DEBUG VT - Prepared sql query parameters : [4,44,Assets] Fri Sep 15 05:36:22 2023,743 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,743 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Prepared sql query being executed : SELECT name FROM vtiger_tab WHERE tabid = ? Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Entering getColumnFields(Assets) method ... Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - in getColumnFields Assets Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,744 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,745 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,745 [1761707] DEBUG VT - Entering getColumnFields(Assets) method ... Fri Sep 15 05:36:22 2023,745 [1761707] DEBUG VT - in getColumnFields Assets Fri Sep 15 05:36:22 2023,745 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,745 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relationfieldid FROM vtiger_relatedlists WHERE relation_id=? Fri Sep 15 05:36:22 2023,745 [1761707] DEBUG VT - Prepared sql query parameters : [148] Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, columnname,tablename FROM vtiger_field WHERE uitype='10' AND fieldid IN (SELECT relationfieldid FROM vtiger_relatedlists WHERE relation_id=?) Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Prepared sql query parameters : [148] Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Entering getColumnFields(Assets) method ... Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - in getColumnFields Assets Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Entering getColumnFields(Assets) method ... Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - in getColumnFields Assets Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_field WHERE tabid=? ORDER BY sequence Fri Sep 15 05:36:22 2023,746 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,747 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,747 [1761707] DEBUG VT - Prepared sql query parameters : [112] Fri Sep 15 05:36:22 2023,747 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,747 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,748 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,749 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,750 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,751 [1761707] DEBUG VT - Prepared sql query parameters : [110] Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - Prepared sql query being executed : SELECT fieldname, tablename, entityidfield FROM vtiger_entityname WHERE tabid = ? Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - Entering getColumnFields(Assets) method ... Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - in getColumnFields Assets Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - Entering getColumnFields(Assets) method ... Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - in getColumnFields Assets Fri Sep 15 05:36:22 2023,752 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,753 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,753 [1761707] DEBUG VT - Prepared sql query parameters : [Assets] Fri Sep 15 05:36:22 2023,753 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,753 [1761707] DEBUG VT - Prepared sql query parameters : [44,110,112] Fri Sep 15 05:36:22 2023,754 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,754 [1761707] DEBUG VT - Prepared sql query parameters : [654] Fri Sep 15 05:36:22 2023,756 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,757 [1761707] DEBUG VT - Prepared sql query parameters : [660] Fri Sep 15 05:36:22 2023,757 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,757 [1761707] DEBUG VT - Prepared sql query parameters : [665] Fri Sep 15 05:36:22 2023,757 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,757 [1761707] DEBUG VT - Prepared sql query parameters : [666] Fri Sep 15 05:36:22 2023,758 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,758 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,758 [1761707] DEBUG VT - Prepared sql query being executed : SELECT COUNT(DISTINCT vtiger_crmentity.crmid) AS count FROM vtiger_assets INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_assets.assetsid LEFT JOIN vtiger_assetscf ON vtiger_assetscf.assetsid = vtiger_assets.assetsid INNER JOIN vtiger_contactdetails AS vtiger_contactdetailsContacts ON vtiger_contactdetailsContacts.contactid = vtiger_assets.contact LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_contactdetailsContacts.contactid = 171144 Fri Sep 15 05:36:22 2023,761 [1761707] DEBUG VT - Prepared sql query being executed : SELECT vtiger_relatedlists.*,vtiger_tab.name as modulename FROM vtiger_relatedlists INNER JOIN vtiger_tab on vtiger_tab.tabid = vtiger_relatedlists.related_tabid AND vtiger_tab.presence != 1 WHERE vtiger_relatedlists.tabid = ? AND related_tabid = ? AND label = ? Fri Sep 15 05:36:22 2023,761 [1761707] DEBUG VT - Prepared sql query parameters : [4,18,Vendors] Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - Entering get_vendors(171144) method ... Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - Prepared sql query being executed : SELECT name FROM vtiger_tab WHERE tabid = ? Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG VT - Prepared sql query parameters : [18] Fri Sep 15 05:36:22 2023,762 [1761707] DEBUG vendor - Entering Vendors() method ... Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - Entering getColumnFields(Vendors) method ... Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - in getColumnFields Vendors Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - Prepared sql query parameters : [18] Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG vendor - Exiting Vendor method ... Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - Entering getFieldVisibilityPermission(Vendors,1,parent_id) method ... Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_field WHERE tabid=? Fri Sep 15 05:36:22 2023,763 [1761707] DEBUG VT - Prepared sql query parameters : [18] Fri Sep 15 05:36:22 2023,764 [1761707] DEBUG VT - Exiting get_vendors method ... Fri Sep 15 05:36:22 2023,764 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_field WHERE tabid=? ORDER BY sequence Fri Sep 15 05:36:22 2023,764 [1761707] DEBUG VT - Prepared sql query parameters : [18] Fri Sep 15 05:36:22 2023,765 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,765 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,765 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,765 [1761707] DEBUG VT - Prepared sql query parameters : [45] Fri Sep 15 05:36:22 2023,765 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,765 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,766 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,767 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,767 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,767 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,767 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,767 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,767 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,767 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,768 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,768 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,768 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,768 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,768 [1761707] DEBUG VT - Prepared sql query parameters : [44] Fri Sep 15 05:36:22 2023,768 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,768 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,769 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,769 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,769 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,769 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,769 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,769 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,770 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,770 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,770 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,770 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,770 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,770 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,771 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,771 [1761707] DEBUG VT - Prepared sql query parameters : [42] Fri Sep 15 05:36:22 2023,771 [1761707] DEBUG VT - Prepared sql query being executed : SELECT fieldname, tablename, entityidfield FROM vtiger_entityname WHERE tabid = ? Fri Sep 15 05:36:22 2023,771 [1761707] DEBUG VT - Prepared sql query parameters : [18] Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG vendor - Entering Vendors() method ... Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - Entering getColumnFields(Vendors) method ... Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - in getColumnFields Vendors Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG vendor - Exiting Vendor method ... Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - Entering getColumnFields(Vendors) method ... Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - in getColumnFields Vendors Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,772 [1761707] DEBUG VT - Prepared sql query parameters : [Vendors] Fri Sep 15 05:36:22 2023,773 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?,?,?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,773 [1761707] DEBUG VT - Prepared sql query parameters : [18,42,44,45] Fri Sep 15 05:36:22 2023,774 [1761707] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=? Fri Sep 15 05:36:22 2023,774 [1761707] DEBUG VT - Prepared sql query parameters : [31] Fri Sep 15 05:36:22 2023,774 [1761707] DEBUG VT - Prepared sql query being executed : SELECT COUNT(DISTINCT vtiger_crmentity.crmid) AS count FROM vtiger_vendor inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_vendor.vendorid INNER JOIN vtiger_vendorcontactrel on vtiger_vendorcontactrel.vendorid=vtiger_vendor.vendorid LEFT JOIN vtiger_vendorcf on vtiger_vendorcf.vendorid=vtiger_vendor.vendorid LEFT JOIN vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid LEFT JOIN vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted=0 and vtiger_vendorcontactrel.contactid=171144 Fri Sep 15 05:36:22 2023,777 [1761707] DEBUG VT - Prepared sql query being executed : SELECT vtiger_relatedlists.*,vtiger_tab.name as modulename FROM vtiger_relatedlists INNER JOIN vtiger_tab on vtiger_tab.tabid = vtiger_relatedlists.related_tabid AND vtiger_tab.presence != 1 WHERE vtiger_relatedlists.tabid = ? AND related_tabid = ? AND label = ? Fri Sep 15 05:36:22 2023,777 [1761707] DEBUG VT - Prepared sql query parameters : [4,59,Customer Order] Fri Sep 15 05:36:22 2023,777 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Entering getColumnFields(Contacts) method ... Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - in getColumnFields Contacts Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Prepared sql query being executed : SELECT name FROM vtiger_tab WHERE tabid = ? Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Prepared sql query parameters : [59] Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (?) Fri Sep 15 05:36:22 2023,778 [1761707] DEBUG VT - Prepared sql query parameters : [59] Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,779 [1761707] INFO VT - PearDatabase ->ADODB disconnect Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,779 [1761707] INFO VT - PearDatabase ->ADODB disconnect Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relationfieldid FROM vtiger_relatedlists WHERE relation_id=? Fri Sep 15 05:36:22 2023,779 [1761707] DEBUG VT - Prepared sql query parameters : [195] Fri Sep 15 05:36:22 2023,780 [1761707] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, columnname,tablename FROM vtiger_field WHERE uitype='10' AND fieldid IN (SELECT fieldid FROM vtiger_fieldmodulerel WHERE relmodule=? AND module=?) Fri Sep 15 05:36:22 2023,780 [1761707] DEBUG VT - Prepared sql query parameters : [Contacts,CustomerOrder] Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,781 [1761707] INFO VT - PearDatabase ->ADODB disconnect Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_field WHERE tabid=? ORDER BY sequence Fri Sep 15 05:36:22 2023,781 [1761707] DEBUG VT - Prepared sql query parameters : [59] Fri Sep 15 05:36:22 2023,782 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,782 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,782 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,782 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,783 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,783 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,783 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,783 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,784 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,784 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,784 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,784 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,785 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,785 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,785 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,785 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,785 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,785 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,786 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,787 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,788 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,789 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,790 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,790 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,790 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,790 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,790 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,790 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,790 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,791 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,791 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,791 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,791 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,791 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,791 [1761707] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_blocks WHERE blockid=? Fri Sep 15 05:36:22 2023,791 [1761707] DEBUG VT - Prepared sql query parameters : [140] Fri Sep 15 05:36:22 2023,792 [1761707] DEBUG VT - Prepared sql query being executed : SELECT fieldname, tablename, entityidfield FROM vtiger_entityname WHERE tabid = ? Fri Sep 15 05:36:22 2023,792 [1761707] DEBUG VT - Prepared sql query parameters : [59] Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,793 [1761707] INFO VT - PearDatabase ->ADODB disconnect Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - Entering getColumnFields(CustomerOrder) method ... Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - in getColumnFields CustomerOrder Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - Exiting getColumnFields method ... Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - Prepared sql query being executed : SELECT DISTINCT block, vtiger_field.tabid, name, blocklabel FROM vtiger_field INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_field.block INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_field.tabid WHERE vtiger_tab.name IN (?) AND vtiger_field.presence IN (0,2) ORDER BY block Fri Sep 15 05:36:22 2023,793 [1761707] DEBUG VT - Prepared sql query parameters : [CustomerOrder] Fri Sep 15 05:36:22 2023,794 [1761707] DEBUG VT - Prepared sql query being executed : select *, '0' as readonly from vtiger_field where tabid =? and block in (?) and displaytype in (1,2,3,4,5,6) Fri Sep 15 05:36:22 2023,794 [1761707] DEBUG VT - Prepared sql query parameters : [59,140] Fri Sep 15 05:36:22 2023,797 [1761707] DEBUG VT - Prepared sql query being executed : SELECT relmodule AS type FROM vtiger_fieldmodulerel WHERE fieldid=? ORDER BY sequence ASC Fri Sep 15 05:36:22 2023,797 [1761707] DEBUG VT - Prepared sql query parameters : [991] Fri Sep 15 05:36:22 2023,798 [1761707] DEBUG VT - Prepared sql query being executed : SELECT COUNT(DISTINCT vtiger_crmentity.crmid) AS count FROM vtiger_customerorder INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_customerorder.customerorderid LEFT JOIN vtiger_customerordercf ON vtiger_customerordercf.customerorderid = vtiger_customerorder.customerorderid INNER JOIN vtiger_contactdetails AS vtiger_contactdetailsContacts ON vtiger_contactdetailsContacts.contactid = vtiger_customerorder.contact_name LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid WHERE vtiger_crmentity.deleted = 0 AND vtiger_contactdetailsContacts.contactid = 171144