05-19-2020, 06:12 AM
Ok, here is the php debug log. Is long so I just snipped the part with the error in database:
Do we need more of the log?
Thanks
Code:
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters []
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT from_number,callertype FROM vtiger_asteriskincomingevents WHERE uid=? AND from_number is not NULL LIMIT 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters []
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT from_number,callertype FROM vtiger_asteriskincomingevents WHERE uid=? AND from_number is not NULL LIMIT 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters []
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT from_number,callertype FROM vtiger_asteriskincomingevents WHERE uid=? AND from_number is not NULL LIMIT 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters []
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT from_number,callertype FROM vtiger_asteriskincomingevents WHERE uid=? AND from_number is not NULL LIMIT 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters []
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT from_number,callertype FROM vtiger_asteriskincomingevents WHERE uid=? AND from_number is not NULL LIMIT 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [1589868326.29575]
2020-05-19T06:06:06+00:00 DEBUG VT > getColumnFields Contacts
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Contacts
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT < getColumnFields
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Contacts
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT 1 FROM vtiger_field WHERE uitype=69 and tabid = ? limit 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [4]
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Contacts
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT > pquery select fieldname,tablename,entityidfield from vtiger_entityname where modulename = ?
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [Contacts]
2020-05-19T06:06:06+00:00 DEBUG VT > pquery select crmid as id, phone,mobile,homephone,otherphone,fax,assistantphone, concat(firstname,' ',lastname) as name FROM vtiger_contactdetails INNER JOIN vtiger_crmentity ON vtiger_cont$
2020-05-19T06:06:06+00:00 DEBUG VT > getColumnFields Accounts
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Accounts
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT < getColumnFields
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Accounts
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT 1 FROM vtiger_field WHERE uitype=69 and tabid = ? limit 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [6]
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Accounts
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT > pquery select fieldname,tablename,entityidfield from vtiger_entityname where modulename = ?
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [Accounts]
2020-05-19T06:06:06+00:00 DEBUG VT > pquery select crmid as id, phone,fax,otherphone, accountname as name FROM vtiger_account INNER JOIN vtiger_crmentity ON vtiger_account.accountid = vtiger_crmentity.crmid AND deleted = 0 WH$
2020-05-19T06:06:06+00:00 DEBUG VT > getColumnFields Leads
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Leads
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT < getColumnFields
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Leads
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT 1 FROM vtiger_field WHERE uitype=69 and tabid = ? limit 1
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [7]
2020-05-19T06:06:06+00:00 DEBUG VT > getTabid Leads
2020-05-19T06:06:06+00:00 DEBUG VT < getTabid
2020-05-19T06:06:06+00:00 DEBUG VT > pquery select fieldname,tablename,entityidfield from vtiger_entityname where modulename = ?
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [Leads]
2020-05-19T06:06:06+00:00 DEBUG VT > pquery select crmid as id, phone,mobile,fax, concat(firstname,' ',lastname) as name FROM vtiger_leaddetails INNER JOIN vtiger_crmentity ON vtiger_leaddetails.leadid = vtiger_crmentity.crmid$
2020-05-19T06:06:06+00:00 DEBUG VT > pquery SELECT * FROM vtiger_asteriskincomingevents WHERE uid = ? and pbxrecordid is NULL AND flag=0
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [1589868326.29575]
2020-05-19T06:06:06+00:00 DEBUG VT > pquery select userid from vtiger_asteriskextensions where asterisk_extension=?
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [500]
2020-05-19T06:06:06+00:00 DEBUG VT > pquery insert into vtiger_crmentity values (?,?,?,?,?,?,?,?,?,?,?,?,?)
2020-05-19T06:06:06+00:00 DEBUG VT > pquery parameters [8389,1,1,0,PBXManager,,2020-05-19 06:06:06,2020-05-19 06:06:06,,,0,1,0]
2020-05-19T06:06:06+00:00 INFO DB DB >ADODB error Query Failed:insert into vtiger_crmentity values (?,?,?,?,?,?,?,?,?,?,?,?,?)::->[1136]Column count doesn't match value count at row 1
Do we need more of the log?
Thanks