| 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:23 2023,565 [1761634] DEBUG user - Entering Users() method ...
Fri Sep 15 05:36:23 2023,565 [1761634] DEBUG VT - Entering getColumnFields(Users) method ...
Fri Sep 15 05:36:23 2023,565 [1761634] DEBUG VT - in getColumnFields Users
Fri Sep 15 05:36:23 2023,565 [1761634] DEBUG VT - Prepared sql query being executed : SELECT tabid, name, ownedby FROM vtiger_tab
Fri Sep 15 05:36:23 2023,565 [1761634] 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:23 2023,565 [1761634] DEBUG VT - Prepared sql query parameters : [29]
Fri Sep 15 05:36:23 2023,567 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,567 [1761634] DEBUG user - Exiting Users() method ...
Fri Sep 15 05:36:23 2023,567 [1761634] DEBUG VT - Entering getColumnFields(Users) method ...
Fri Sep 15 05:36:23 2023,567 [1761634] DEBUG VT - in getColumnFields Users
Fri Sep 15 05:36:23 2023,567 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,567 [1761634] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_tab
Fri Sep 15 05:36:23 2023,568 [1761634] DEBUG VT - Prepared sql query being executed : SELECT fieldname,modulename,tablename,entityidfield,entityidcolumn from vtiger_entityname
Fri Sep 15 05:36:23 2023,576 [1761634] DEBUG VT - Entering getUserProfile(1) method ...
Fri Sep 15 05:36:23 2023,577 [1761634] DEBUG VT - Entering fetchUserRole(1) method ...
Fri Sep 15 05:36:23 2023,577 [1761634] DEBUG VT - Prepared sql query being executed : select roleid from vtiger_user2role where userid=?
Fri Sep 15 05:36:23 2023,577 [1761634] DEBUG VT - Prepared sql query parameters : [1]
Fri Sep 15 05:36:23 2023,579 [1761634] DEBUG VT - Exiting fetchUserRole method ...
Fri Sep 15 05:36:23 2023,579 [1761634] DEBUG VT - Prepared sql query being executed : select profileid from vtiger_role2profile where roleid=?
Fri Sep 15 05:36:23 2023,579 [1761634] DEBUG VT - Prepared sql query parameters : [H2]
Fri Sep 15 05:36:23 2023,581 [1761634] DEBUG VT - Exiting getUserProfile method ...
Fri Sep 15 05:36:23 2023,581 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,581 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,581 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,581 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,581 [1761634] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_profile
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_pdfmaker_profilespermissions
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - PearDatabase ->ADODB fetchByAssoc return null
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Entering getActionid(Delete) method ...
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - get Actionid Delete
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - action id selected is 2
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Entering getActionid(Export) method ...
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - get Actionid Export
Fri Sep 15 05:36:23 2023,582 [1761634] INFO VT - action id selected is 6
Fri Sep 15 05:36:23 2023,582 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Delete) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Delete
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 2
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Export) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Export
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 6
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Delete) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Delete
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 2
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Export) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Export
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 6
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Delete) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Delete
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 2
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Export) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Export
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 6
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Delete) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Delete
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 2
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Export) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Export
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 6
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Delete) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Delete
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 2
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Entering getActionid(Export) method ...
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - get Actionid Export
Fri Sep 15 05:36:23 2023,583 [1761634] INFO VT - action id selected is 6
Fri Sep 15 05:36:23 2023,583 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,584 [1761634] DEBUG VT - Prepared sql query being executed : SELECT crmid, setype, label FROM vtiger_crmentity WHERE crmid=?
Fri Sep 15 05:36:23 2023,584 [1761634] DEBUG VT - Prepared sql query parameters : [171144]
Fri Sep 15 05:36:23 2023,585 [1761634] DEBUG VT - Entering getColumnFields(Contacts) method ...
Fri Sep 15 05:36:23 2023,585 [1761634] DEBUG VT - in getColumnFields Contacts
Fri Sep 15 05:36:23 2023,585 [1761634] 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:23 2023,585 [1761634] DEBUG VT - Prepared sql query parameters : [4]
Fri Sep 15 05:36:23 2023,587 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,587 [1761634] DEBUG VT - Entering getColumnFields(Contacts) method ...
Fri Sep 15 05:36:23 2023,587 [1761634] DEBUG VT - in getColumnFields Contacts
Fri Sep 15 05:36:23 2023,587 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,587 [1761634] DEBUG VT - Prepared sql query being executed : SELECT vtiger_contactdetails.salutation AS vtiger_contactdetailssalutationtype,vtiger_contactdetails.firstname AS vtiger_contactdetailsfirstname,vtiger_contactdetails.contact_no AS vtiger_contactdetailscontact_no,vtiger_contactdetails.phone AS vtiger_contactdetailsphone,vtiger_contactdetails.lastname AS vtiger_contactdetailslastname,vtiger_contactdetails.mobile AS vtiger_contactdetailsmobile,vtiger_contactdetails.accountid AS vtiger_contactdetailsaccount_id,vtiger_contactsubdetails.homephone AS vtiger_contactsubdetailshomephone,vtiger_contactsubdetails.leadsource AS vtiger_contactsubdetailsleadsource,vtiger_contactsubdetails.otherphone AS vtiger_contactsubdetailsotherphone,vtiger_contactdetails.title AS vtiger_contactdetailstitle,vtiger_contactdetails.fax AS vtiger_contactdetailsfax,vtiger_contactdetails.department AS vtiger_contactdetailsdepartment,vtiger_contactsubdetails.birthday AS vtiger_contactsubdetailsbirthday,vtiger_contactdetails.email AS vtiger_contactdetailsemail,vtiger_contactdetails.reportsto AS vtiger_contactdetailscontact_id,vtiger_contactsubdetails.assistant AS vtiger_contactsubdetailsassistant,vtiger_contactdetails.secondaryemail AS vtiger_contactdetailssecondaryemail,vtiger_contactsubdetails.assistantphone AS vtiger_contactsubdetailsassistantphone,vtiger_contactdetails.donotcall AS vtiger_contactdetailsdonotcall,vtiger_contactdetails.emailoptout AS vtiger_contactdetailsemailoptout,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_contactdetails.reference AS vtiger_contactdetailsreference,vtiger_contactdetails.notify_owner AS vtiger_contactdetailsnotify_owner,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_customerdetails.portal AS vtiger_customerdetailsportal,vtiger_customerdetails.support_start_date AS vtiger_customerdetailssupport_start_date,vtiger_customerdetails.support_end_date AS vtiger_customerdetailssupport_end_date,vtiger_contactaddress.mailingstreet AS vtiger_contactaddressmailingstreet,vtiger_contactaddress.otherstreet AS vtiger_contactaddressotherstreet,vtiger_contactaddress.mailingcity AS vtiger_contactaddressmailingcity,vtiger_contactaddress.othercity AS vtiger_contactaddressothercity,vtiger_contactaddress.mailingstate AS vtiger_contactaddressmailingstate,vtiger_contactaddress.otherstate AS vtiger_contactaddressotherstate,vtiger_contactaddress.mailingzip AS vtiger_contactaddressmailingzip,vtiger_contactaddress.otherzip AS vtiger_contactaddressotherzip,vtiger_contactaddress.mailingcountry AS vtiger_contactaddressmailingcountry,vtiger_contactaddress.othercountry AS vtiger_contactaddressothercountry,vtiger_contactaddress.mailingpobox AS vtiger_contactaddressmailingpobox,vtiger_contactaddress.otherpobox AS vtiger_contactaddressotherpobox,vtiger_contactdetails.imagename AS vtiger_contactdetailsimagename,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_contactdetails.isconvertedfromlead AS vtiger_contactdetailsisconvertedfromlead,vtiger_crmentity.source AS vtiger_crmentitysource,vtiger_crmentity_user_field.starred AS vtiger_crmentity_user_fieldstarred,vtiger_contactdetails.tags AS vtiger_contactdetailstags,vtiger_contactdetails.emailcampaign_optout AS vtiger_contactdetailsemailcampaign_optout,vtiger_contactdetails.technology AS vtiger_contactdetailstechnology,vtiger_contactdetails.lead_stage AS vtiger_contactdetailslead_stage,vtiger_contactscf.cf_1006 AS vtiger_contactscfcf_1006,vtiger_contactscf.cf_1147 AS vtiger_contactscfcf_1147,vtiger_contactscf.cf_1149 AS vtiger_contactscfcf_1149,vtiger_contactscf.cf_1151 AS vtiger_contactscfcf_1151,vtiger_contactscf.cf_1153 AS vtiger_contactscfcf_1153,vtiger_crmentity.deleted, vtiger_crmentity.label FROM vtiger_crmentity LEFT JOIN vtiger_contactdetails ON (vtiger_contactdetails.contactid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactaddress ON (vtiger_contactaddress.contactaddressid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactsubdetails ON (vtiger_contactsubdetails.contactsubscriptionid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactscf ON (vtiger_contactscf.contactid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_customerdetails ON (vtiger_customerdetails.customerid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_crmentity_user_field ON (vtiger_crmentity_user_field.recordid = vtiger_crmentity.crmid AND vtiger_crmentity_user_field.userid = 1 ) WHERE vtiger_crmentity.crmid=? LIMIT 1
Fri Sep 15 05:36:23 2023,587 [1761634] DEBUG VT - Prepared sql query parameters : [171144]
Fri Sep 15 05:36:23 2023,588 [1761634] DEBUG VT - Entering getUserProfile(1) method ...
Fri Sep 15 05:36:23 2023,588 [1761634] DEBUG VT - Entering fetchUserRole(1) method ...
Fri Sep 15 05:36:23 2023,588 [1761634] DEBUG VT - Prepared sql query being executed : select roleid from vtiger_user2role where userid=?
Fri Sep 15 05:36:23 2023,588 [1761634] DEBUG VT - Prepared sql query parameters : [1]
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Exiting fetchUserRole method ...
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Prepared sql query being executed : select profileid from vtiger_role2profile where roleid=?
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Prepared sql query parameters : [H2]
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Exiting getUserProfile method ...
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,589 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,589 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Prepared sql query being executed : SELECT templateid, is_active, is_default, sequence
FROM vtiger_pdfmaker_userstatus
INNER JOIN vtiger_pdfmaker USING(templateid)
WHERE userid=? AND vtiger_pdfmaker.deleted=?
Fri Sep 15 05:36:23 2023,589 [1761634] DEBUG VT - Prepared sql query parameters : [1,0]
Fri Sep 15 05:36:23 2023,590 [1761634] INFO VT - PearDatabase ->ADODB fetchByAssoc return null
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Prepared sql query being executed : select * from vtiger_ws_entity where name=?
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Prepared sql query parameters : [Contacts]
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Prepared sql query being executed : select * from vtiger_ws_entity where id=?
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Prepared sql query parameters : [12x171144]
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Entering getColumnFields(Contacts) method ...
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - in getColumnFields Contacts
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Entering getColumnFields(Contacts) method ...
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - in getColumnFields Contacts
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,590 [1761634] DEBUG VT - Prepared sql query being executed : select setype from vtiger_crmentity where crmid=? and deleted=0
Fri Sep 15 05:36:23 2023,591 [1761634] DEBUG VT - Prepared sql query parameters : [171144]
Fri Sep 15 05:36:23 2023,591 [1761634] DEBUG VT - Entering getPermittedModuleNames() method ...
Fri Sep 15 05:36:23 2023,591 [1761634] DEBUG VT - Exiting getPermittedModuleNames method ...
Fri Sep 15 05:36:23 2023,591 [1761634] DEBUG VT - Prepared sql query being executed : select name,id,ismodule from vtiger_ws_entity
Fri Sep 15 05:36:23 2023,591 [1761634] INFO VT - PearDatabase ->ADODB fetchByAssoc return null
Fri Sep 15 05:36:23 2023,591 [1761634] DEBUG VT - Prepared sql query being executed : select * from vtiger_ws_entity
Fri Sep 15 05:36:23 2023,592 [1761634] DEBUG VT - Prepared sql query being executed : select table_name, webservice_entity_id from vtiger_ws_entity_tables
Fri Sep 15 05:36:23 2023,593 [1761634] 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:23 2023,593 [1761634] DEBUG VT - Prepared sql query parameters : [Contacts]
Fri Sep 15 05:36:23 2023,594 [1761634] 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:23 2023,594 [1761634] DEBUG VT - Prepared sql query parameters : [4,4,6,7,8,73]
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Entering isPermitted(Contacts,DetailView,171144) method ...
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Entering getActionid(DetailView) method ...
Fri Sep 15 05:36:23 2023,596 [1761634] INFO VT - get Actionid DetailView
Fri Sep 15 05:36:23 2023,596 [1761634] INFO VT - action id selected is 4
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Exiting isPermitted method ...
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Prepared sql query being executed : select 1 from vtiger_crmentity where crmid=? and deleted=0 and setype='Contacts'
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Prepared sql query parameters : [171144]
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Entering getColumnFields(Contacts) method ...
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - in getColumnFields Contacts
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,596 [1761634] DEBUG VT - Entering getColumnFields(Contacts) method ...
Fri Sep 15 05:36:23 2023,597 [1761634] DEBUG VT - in getColumnFields Contacts
Fri Sep 15 05:36:23 2023,597 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,597 [1761634] INFO VT - PearDatabase ->TRANS Started
Fri Sep 15 05:36:23 2023,597 [1761634] DEBUG VT - Prepared sql query being executed : SELECT vtiger_contactdetails.salutation AS vtiger_contactdetailssalutationtype,vtiger_contactdetails.firstname AS vtiger_contactdetailsfirstname,vtiger_contactdetails.contact_no AS vtiger_contactdetailscontact_no,vtiger_contactdetails.phone AS vtiger_contactdetailsphone,vtiger_contactdetails.lastname AS vtiger_contactdetailslastname,vtiger_contactdetails.mobile AS vtiger_contactdetailsmobile,vtiger_contactdetails.accountid AS vtiger_contactdetailsaccount_id,vtiger_contactsubdetails.homephone AS vtiger_contactsubdetailshomephone,vtiger_contactsubdetails.leadsource AS vtiger_contactsubdetailsleadsource,vtiger_contactsubdetails.otherphone AS vtiger_contactsubdetailsotherphone,vtiger_contactdetails.title AS vtiger_contactdetailstitle,vtiger_contactdetails.fax AS vtiger_contactdetailsfax,vtiger_contactdetails.department AS vtiger_contactdetailsdepartment,vtiger_contactsubdetails.birthday AS vtiger_contactsubdetailsbirthday,vtiger_contactdetails.email AS vtiger_contactdetailsemail,vtiger_contactdetails.reportsto AS vtiger_contactdetailscontact_id,vtiger_contactsubdetails.assistant AS vtiger_contactsubdetailsassistant,vtiger_contactdetails.secondaryemail AS vtiger_contactdetailssecondaryemail,vtiger_contactsubdetails.assistantphone AS vtiger_contactsubdetailsassistantphone,vtiger_contactdetails.donotcall AS vtiger_contactdetailsdonotcall,vtiger_contactdetails.emailoptout AS vtiger_contactdetailsemailoptout,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_contactdetails.reference AS vtiger_contactdetailsreference,vtiger_contactdetails.notify_owner AS vtiger_contactdetailsnotify_owner,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_customerdetails.portal AS vtiger_customerdetailsportal,vtiger_customerdetails.support_start_date AS vtiger_customerdetailssupport_start_date,vtiger_customerdetails.support_end_date AS vtiger_customerdetailssupport_end_date,vtiger_contactaddress.mailingstreet AS vtiger_contactaddressmailingstreet,vtiger_contactaddress.otherstreet AS vtiger_contactaddressotherstreet,vtiger_contactaddress.mailingcity AS vtiger_contactaddressmailingcity,vtiger_contactaddress.othercity AS vtiger_contactaddressothercity,vtiger_contactaddress.mailingstate AS vtiger_contactaddressmailingstate,vtiger_contactaddress.otherstate AS vtiger_contactaddressotherstate,vtiger_contactaddress.mailingzip AS vtiger_contactaddressmailingzip,vtiger_contactaddress.otherzip AS vtiger_contactaddressotherzip,vtiger_contactaddress.mailingcountry AS vtiger_contactaddressmailingcountry,vtiger_contactaddress.othercountry AS vtiger_contactaddressothercountry,vtiger_contactaddress.mailingpobox AS vtiger_contactaddressmailingpobox,vtiger_contactaddress.otherpobox AS vtiger_contactaddressotherpobox,vtiger_contactdetails.imagename AS vtiger_contactdetailsimagename,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_contactdetails.isconvertedfromlead AS vtiger_contactdetailsisconvertedfromlead,vtiger_crmentity.source AS vtiger_crmentitysource,vtiger_crmentity_user_field.starred AS vtiger_crmentity_user_fieldstarred,vtiger_contactdetails.tags AS vtiger_contactdetailstags,vtiger_contactdetails.emailcampaign_optout AS vtiger_contactdetailsemailcampaign_optout,vtiger_contactdetails.technology AS vtiger_contactdetailstechnology,vtiger_contactdetails.lead_stage AS vtiger_contactdetailslead_stage,vtiger_contactscf.cf_1006 AS vtiger_contactscfcf_1006,vtiger_contactscf.cf_1147 AS vtiger_contactscfcf_1147,vtiger_contactscf.cf_1149 AS vtiger_contactscfcf_1149,vtiger_contactscf.cf_1151 AS vtiger_contactscfcf_1151,vtiger_contactscf.cf_1153 AS vtiger_contactscfcf_1153,vtiger_crmentity.deleted, vtiger_crmentity.label FROM vtiger_crmentity LEFT JOIN vtiger_contactdetails ON (vtiger_contactdetails.contactid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactaddress ON (vtiger_contactaddress.contactaddressid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactsubdetails ON (vtiger_contactsubdetails.contactsubscriptionid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_contactscf ON (vtiger_contactscf.contactid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_customerdetails ON (vtiger_customerdetails.customerid = vtiger_crmentity.crmid ) LEFT JOIN vtiger_crmentity_user_field ON (vtiger_crmentity_user_field.recordid = vtiger_crmentity.crmid AND vtiger_crmentity_user_field.userid = 1 ) WHERE vtiger_crmentity.crmid=? LIMIT 1
Fri Sep 15 05:36:23 2023,597 [1761634] DEBUG VT - Prepared sql query parameters : [171144]
Fri Sep 15 05:36:23 2023,598 [1761634] INFO VT - PearDatabase ->TRANS Commited
Fri Sep 15 05:36:23 2023,598 [1761634] INFO VT - PearDatabase ->TRANS Completed
Fri Sep 15 05:36:23 2023,598 [1761634] DEBUG VT - Prepared sql query being executed : select * from vtiger_ws_fieldtype
Fri Sep 15 05:36:23 2023,599 [1761634] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=?
Fri Sep 15 05:36:23 2023,599 [1761634] DEBUG VT - Prepared sql query parameters : [21]
Fri Sep 15 05:36:23 2023,601 [1761634] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=?
Fri Sep 15 05:36:23 2023,601 [1761634] DEBUG VT - Prepared sql query parameters : [22]
Fri Sep 15 05:36:23 2023,603 [1761634] DEBUG VT - Prepared sql query being executed : select type from vtiger_ws_referencetype where fieldtypeid=?
Fri Sep 15 05:36:23 2023,603 [1761634] DEBUG VT - Prepared sql query parameters : [31]
Fri Sep 15 05:36:23 2023,604 [1761634] DEBUG user - Entering Users() method ...
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Entering getColumnFields(Users) method ...
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - in getColumnFields Users
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG user - Exiting Users() method ...
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Entering getColumnFields(Users) method ...
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - in getColumnFields Users
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Exiting getColumnFields method ...
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query being executed : select 1 from vtiger_users where id=? and deleted=0 and status='Active'
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query parameters : [1]
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query being executed : select groupname from vtiger_groups where groupid = ?
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query parameters : [1]
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query being executed : select first_name from vtiger_users where id = ?
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query parameters : [1]
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query being executed : SELECT vtiger_pdfmaker_displayed.*, vtiger_pdfmaker.templateid, vtiger_pdfmaker.filename, vtiger_pdfmaker.description
FROM vtiger_pdfmaker
INNER JOIN vtiger_pdfmaker_settings USING(templateid)
LEFT JOIN vtiger_pdfmaker_displayed USING(templateid)
WHERE vtiger_pdfmaker.module=? AND vtiger_pdfmaker.deleted = ? AND is_listview=?
ORDER BY vtiger_pdfmaker.filename ASC
Fri Sep 15 05:36:23 2023,605 [1761634] DEBUG VT - Prepared sql query parameters : [Contacts,0,0]
Fri Sep 15 05:36:23 2023,606 [1761634] INFO VT - PearDatabase ->ADODB fetchByAssoc return null
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Entering isPermitted(Contacts,EditView,171144) method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,606 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,606 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Exiting isPermitted method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Entering isPermitted(Documents,EditView,) method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Entering getActionid(EditView) method ...
Fri Sep 15 05:36:23 2023,606 [1761634] INFO VT - get Actionid EditView
Fri Sep 15 05:36:23 2023,606 [1761634] INFO VT - action id selected is 1
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Exiting getActionid method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Exiting isPermitted method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Entering getUserProfile(1) method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Entering fetchUserRole(1) method ...
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Prepared sql query being executed : select roleid from vtiger_user2role where userid=?
Fri Sep 15 05:36:23 2023,606 [1761634] DEBUG VT - Prepared sql query parameters : [1]
Fri Sep 15 05:36:23 2023,607 [1761634] DEBUG VT - Exiting fetchUserRole method ...
Fri Sep 15 05:36:23 2023,607 [1761634] DEBUG VT - Prepared sql query being executed : select profileid from vtiger_role2profile where roleid=?
Fri Sep 15 05:36:23 2023,607 [1761634] DEBUG VT - Prepared sql query parameters : [H2]
Fri Sep 15 05:36:23 2023,607 [1761634] DEBUG VT - Exiting getUserProfile method ...