+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forum-17.html)
+--- Forum: Modules/Extension Support (https://discussions.corebos.org/forum-9.html)
+--- Thread: PBXManager module listview empty (/thread-1802.html)
PBXManager module listview empty - radu - 05-18-2020
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
RE: PBXManager module listview empty - joebordes - 05-18-2020
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
RE: PBXManager module listview empty - radu - 05-19-2020
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 1Do we need more of the log?
Thanks
RE: PBXManager module listview empty - radu - 05-19-2020
In this
Code:
Query Failed:insert into vtiger_crmentity values (?,?,?,?,?,?,?,?,?,?,?,?,?)::->[1136]Column count doesn't match value count at row 1I 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?
RE: PBXManager module listview empty - joebordes - 05-21-2020
see if this helps
https://github.com/tsolucio/corebos/commit/f3005537129b4012c834ccd68c40a3c29928be28
RE: PBXManager module listview empty - radu - 05-22-2020
(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!