Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PBXManager module listview empty
#3
Ok, here is the php debug log. Is long so I just snipped the part with the error in database:

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
Reply


Messages In This Thread
PBXManager module listview empty - by radu - 05-18-2020, 07:51 PM
RE: PBXManager module listview empty - by radu - 05-19-2020, 06:12 AM
RE: PBXManager module listview empty - by radu - 05-19-2020, 12:51 PM
RE: PBXManager module listview empty - by radu - 05-22-2020, 06:16 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)