Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[ Solved ] Bug filter not working anymore
#2
Debug

2018-08-28T18:23:34-03:00 INFO VT PearDatabase ->ADODB fetchByAssoc return null
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select 1 FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid where vtiger_crmentity.deleted=0 and gvname=? limit 1
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Debug_ListView_Query]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : SELECT SQL_CALC_FOUND_ROWS vtiger_leadaddress.phone, vtiger_leaddetails.company, vtiger_leaddetails.industry, vtiger_leadscf.cf_742, vtiger_crmentity.smownerid, vtiger_leaddetails.firstname, vtiger_leaddetails.lastname, vtiger_leaddetails.leadstatus, vtiger_leaddetails.leadsource, vtiger_leaddetails.leadid FROM vtiger_leaddetails INNER JOIN vtiger_crmentity ON vtiger_leaddetails.leadid = vtiger_crmentity.crmid INNER JOIN vtiger_leadaddress ON vtiger_leaddetails.leadid = vtiger_leadaddress.leadaddressid INNER JOIN vtiger_leadscf ON vtiger_leaddetails.leadid = vtiger_leadscf.leadid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid WHERE vtiger_crmentity.deleted=0 and vtiger_leaddetails.converted=0 AND ( (( vtiger_leaddetails.leadsource IN (
select translation_key
from vtiger_cbtranslation
where locale="pt_br" and forpicklist="Leads::leadsource" and i18n = 'EMGE') OR vtiger_leaddetails.leadsource = 'EMGE') )) AND vtiger_leaddetails.leadid > 0 LIMIT 0, 20
2018-08-28T18:23:34-03:00 INFO VT PearDatabase ->ADODB error Query Failed:SELECT SQL_CALC_FOUND_ROWS vtiger_leadaddress.phone, vtiger_leaddetails.company, vtiger_leaddetails.industry, vtiger_leadscf.cf_742, vtiger_crmentity.smownerid, vtiger_leaddetails.firstname, vtiger_leaddetails.lastname, vtiger_leaddetails.leadstatus, vtiger_leaddetails.leadsource, vtiger_leaddetails.leadid FROM vtiger_leaddetails INNER JOIN vtiger_crmentity ON vtiger_leaddetails.leadid = vtiger_crmentity.crmid INNER JOIN vtiger_leadaddress ON vtiger_leaddetails.leadid = vtiger_leadaddress.leadaddressid INNER JOIN vtiger_leadscf ON vtiger_leaddetails.leadid = vtiger_leadscf.leadid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid WHERE vtiger_crmentity.deleted=0 and vtiger_leaddetails.converted=0 AND ( (( vtiger_leaddetails.leadsource IN (
select translation_key
from vtiger_cbtranslation
where locale="pt_br" and forpicklist="Leads::leadsource" and i18n = 'EMGE') OR vtiger_leaddetails.leadsource = 'EMGE') )) AND vtiger_leaddetails.leadid > 0 LIMIT 0, 20::->[1146]Table 'corebos580.vtiger_cbtranslation' doesn't exist
2018-08-28T18:23:34-03:00 DEBUG index query being executed : SELECT FOUND_ROWS();
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select 1 FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid where vtiger_crmentity.deleted=0 and gvname=? limit 1
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Compute_Page_Count]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select * FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid where vtiger_crmentity.deleted=0 and gvname=? and mandatory='1'
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Compute_Page_Count]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select * FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid inner join vtiger_user2role on vtiger_user2role.userid='6' where vtiger_crmentity.deleted=0 and gvname=? and rolegv like concat('%', vtiger_user2role.roleid, '%')
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Compute_Page_Count]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select * FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid where vtiger_crmentity.deleted=0 and gvname=? and vtiger_crmentity.smownerid='6'
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Compute_Page_Count]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select 1 FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid where vtiger_crmentity.deleted=0 and gvname=? limit 1
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Default_Sort_Order]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select * FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid where vtiger_crmentity.deleted=0 and gvname=? and mandatory='1'
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Default_Sort_Order]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select * FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid inner join vtiger_user2role on vtiger_user2role.userid='6' where vtiger_crmentity.deleted=0 and gvname=? and rolegv like concat('%', vtiger_user2role.roleid, '%')
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Default_Sort_Order]
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query being executed : select * FROM vtiger_globalvariable INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_globalvariable.globalvariableid where vtiger_crmentity.deleted=0 and gvname=? and vtiger_crmentity.smownerid='6'
2018-08-28T18:23:34-03:00 DEBUG index Prepared sql query parameters : [Application_ListView_Default_Sort_Order]
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting return_module_language method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering isPermitted(Leads,EditView,) method ...
2018-08-28T18:23:34-03:00 DEBUG index Exiting isPermitted method ...
2018-08-28T18:23:34-03:00 DEBUG index Entering return_module_language(pt_br,Leads) method ...
Ranieri
eCRM Web
Reply


Messages In This Thread
RE: Bug filter not working anymore - rslemer - 08-28-2018, 09:29 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)