Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PBXManager module listview empty
#1
Thumbs Up 
Hello,
I noticed that on a fresh pull from git install when a pbx event takes place(incoming or outgoing) it is not displayed in the module's listview
Upon further inspection i noticed that the events were recorded in table vtiger_pbxmanager but the sql querry:


Code:
SELECT vtiger_pbxmanager.callfrom, vtiger_pbxmanager.callto, vtiger_pbxmanager.timeofcall, vtiger_pbxmanager.status, vtiger_pbxmanager.pbxmanagerid FROM vtiger_pbxmanager INNER JOIN vtiger_crmentity ON vtiger_pbxmanager.pbxmanagerid = vtiger_crmentity.crmid WHERE vtiger_crmentity.deleted=0 AND vtiger_pbxmanager.pbxmanagerid > 0


-as it was presented by the debug header in PBXManager listview- yeld 0 results. I noticed the ON vtiger_pbxmanager.pbxmanagerid = vtiger_crmentity.crmid and checked the table vtiger_crmentity as it is part of the statement. There were no PBXManager entries so that's why the SELECT did not return anything. On older versions I can locate the crmid in that  vtiger_crmentity.

Can someone replicate that or it is just my installation?
Any pointers as to where would the problem lay?

Thanks
Reply
#2
you should have a record in crmentity for the call, so I would ask you to activate debug log and force a call
then search i the log for an error, I suppose there will be an error creating the pbxmanager record there, share that with me
Joe
TSolucio
Reply
#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
#4
In this

Code:
Query Failed:insert into vtiger_crmentity values (?,?,?,?,?,?,?,?,?,?,?,?,?)::->[1136]Column count doesn't match value count at row 1

I count 13 values. The vtiger_crmentity table has 14 fields. i see that there is a field  cbuuid which is new(it did not used to be there a while ago) so old installation used to have 13 fields in that table. Could this be an issue?
Reply
#5
see if this helps
https://github.com/tsolucio/corebos/commit/f3005537129b4012c834ccd68c40a3c29928be28
Joe
TSolucio
Reply
#6
(05-21-2020, 10:58 PM)joebordes Wrote: see if this helps
https://github.com/tsolucio/corebos/commit/f3005537129b4012c834ccd68c40a3c29928be28

That seemed to do the trick.
Thanks!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)