08-24-2022, 12:14 PM
...
2022-08-21T11:07:48+00:00 DEBUG index > return_module_language en_us,ProductComponent
2022-08-21T11:07:48+00:00 DEBUG index < return_module_language
2022-08-21T11:07:48+00:00 DEBUG index > return_module_language en_us,ProductComponent
2022-08-21T11:07:48+00:00 DEBUG index < return_module_language
2022-08-21T11:07:48+00:00 DEBUG index > is_admin admin
2022-08-21T11:07:48+00:00 DEBUG index < is_admin
2022-08-21T11:07:48+00:00 DEBUG index > getAllUserGroups 1
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_users2group where userid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [1]
2022-08-21T11:07:48+00:00 DEBUG index > fetchUserRole 1
2022-08-21T11:07:48+00:00 DEBUG index > pquery select roleid from vtiger_user2role where userid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [1]
2022-08-21T11:07:48+00:00 DEBUG index < fetchUserRole
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2role where roleid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H2]
2022-08-21T11:07:48+00:00 DEBUG index > getParentRole H2
2022-08-21T11:07:48+00:00 DEBUG index > getRoleInformation H2
2022-08-21T11:07:48+00:00 DEBUG index > pquery select * from vtiger_role where roleid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H2]
2022-08-21T11:07:48+00:00 DEBUG index < getRoleInformation
2022-08-21T11:07:48+00:00 DEBUG index < getParentRole
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2rs where roleandsubid in (?,?)
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H1,H2]
2022-08-21T11:07:48+00:00 DEBUG index > getAllParentGroups 3
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2grouprel where containsgroupid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [3]
2022-08-21T11:07:48+00:00 DEBUG index < getAllParentGroups
2022-08-21T11:07:48+00:00 DEBUG index < getAllUserGroups
2022-08-21T11:07:48+00:00 DEBUG index > pquery select userid
from vtiger_user2role
inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid
inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid
where vtiger_role.parentrole like '::%'
2022-08-21T11:07:48+00:00 DEBUG index > pquery select vtiger_reportmodules.*,vtiger_report.*
from vtiger_report
inner join vtiger_reportmodules on vtiger_report.reportid = vtiger_reportmodules.reportmodulesid
where vtiger_report.reportid = ?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [27]
2022-08-21T11:07:48+00:00 DEBUG index > pquery select vtiger_reportdatefilter.*
from vtiger_reportdatefilter
inner join vtiger_report on vtiger_report.reportid = vtiger_reportdatefilter.datefilterid
where vtiger_report.reportid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [27]
2022-08-21T11:07:48+00:00 DEBUG index > return_module_language en_us,ProductComponent
2022-08-21T11:07:48+00:00 DEBUG index < return_module_language
2022-08-21T11:07:48+00:00 DEBUG index > return_module_language en_us,ProductComponent
2022-08-21T11:07:48+00:00 DEBUG index < return_module_language
2022-08-21T11:07:48+00:00 DEBUG index > is_admin admin
2022-08-21T11:07:48+00:00 DEBUG index < is_admin
2022-08-21T11:07:48+00:00 DEBUG index > getAllUserGroups 1
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_users2group where userid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [1]
2022-08-21T11:07:48+00:00 DEBUG index > fetchUserRole 1
2022-08-21T11:07:48+00:00 DEBUG index > pquery select roleid from vtiger_user2role where userid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [1]
2022-08-21T11:07:48+00:00 DEBUG index < fetchUserRole
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2role where roleid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H2]
2022-08-21T11:07:48+00:00 DEBUG index > getParentRole H2
2022-08-21T11:07:48+00:00 DEBUG index > getRoleInformation H2
2022-08-21T11:07:48+00:00 DEBUG index > pquery select * from vtiger_role where roleid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H2]
2022-08-21T11:07:48+00:00 DEBUG index < getRoleInformation
2022-08-21T11:07:48+00:00 DEBUG index < getParentRole
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2rs where roleandsubid in (?,?)
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [H1,H2]
2022-08-21T11:07:48+00:00 DEBUG index > getAllParentGroups 3
2022-08-21T11:07:48+00:00 DEBUG index > pquery select groupid from vtiger_group2grouprel where containsgroupid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [3]
2022-08-21T11:07:48+00:00 DEBUG index < getAllParentGroups
2022-08-21T11:07:48+00:00 DEBUG index < getAllUserGroups
2022-08-21T11:07:48+00:00 DEBUG index > pquery select userid
from vtiger_user2role
inner join vtiger_users on vtiger_users.id=vtiger_user2role.userid
inner join vtiger_role on vtiger_role.roleid=vtiger_user2role.roleid
where vtiger_role.parentrole like '::%'
2022-08-21T11:07:48+00:00 DEBUG index > pquery select vtiger_reportmodules.*,vtiger_report.*
from vtiger_report
inner join vtiger_reportmodules on vtiger_report.reportid = vtiger_reportmodules.reportmodulesid
where vtiger_report.reportid = ?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [27]
2022-08-21T11:07:48+00:00 DEBUG index > pquery select vtiger_reportdatefilter.*
from vtiger_reportdatefilter
inner join vtiger_report on vtiger_report.reportid = vtiger_reportdatefilter.datefilterid
where vtiger_report.reportid=?
2022-08-21T11:07:48+00:00 DEBUG index > pquery parameters [27]