Skip to content
Snippets Groups Projects

user_privileges files not recalculated after moving roles in hierarchy

    • Open Issue created by Ruben A. Estrada @ruben.estrada

    If you move a role to a different position in the hierarchy, the user_privileges files aren't recalculated.

    For example, let's say you have roles A and B in the same level of hierarchy and your records are private. That means users cannot see each others' records. Then you move role A below B. That would mean, that users in role B can now see records from users in A. But that doesn't happen.

    It seems that the user_privileges files are not recalculated.

    The action Settings_Roles_MoveAjax_Action is supposed to do that:

    image

    But it seems that something inside createUserSharingPrivilegesfile() fails to do it.

    However, if I run this script:

    require_once 'vtlib/Vtiger/Module.php';
require_once 'include/utils/VtlibUtils.php';
require_once 'config.inc.php';
require_once 'includes/Loader.php';
require_once 'modules/Users/CreateUserPrivilegeFile.php';
vimport ('includes.runtime.EntryPoint');

$current_user = Users::getActiveAdminUser();

vtlib_RecreateUserPrivilegeFiles();

    The files do get recreated.

    I doulbe checked it was not a files permissions issue.

    Designs

      Child items 0

      2. No child items are currently assigned. Use child items to break down this issue into smaller parts.

      Activity

      • Uma
        Uma @uma.s ·
        Guest

        @ruben.estrada Did you got a chance to check through the debug logs, which will throw the clues about api flaw.

        I have verified the below specified case scenario on vtiger 7.3.0

        • Created 2 roles under Vice president in same level as Support Manager and Sales Manager
        • Set the Contacts module sharing rules to private
        • So records assigned to Sales Manager is not viewable to Support Manager and Vice versa
        • Now moved the role Sales Manager under Support Manager
        • So records assigned to Sales Manager is viewable to support Manager, But Support Manager records are not visible to Sales Manager.

        So i think that works fine with Sharing rules and Role Heirarchy. Please do let me known if i am missing something.

      • Ruben A. Estrada
        Ruben A. Estrada @ruben.estrada ·
        Author Contributor

        Hi Uma!

        Yes, the scenario that you describe is correct.

        In my case, I created a new rol called "rol prueba" (test role in Spanish):

        image

        This is the user's privileges file before making the change:

        image

        After moving the role "rol prueba" under "Sales Person", the user_privileges_5.php remains unchanged.

        This is how the hierarchy look like after moving the role:

        image

        If I go to the user's profile click on edit and then save, the file is recalculated as it should have when moving the role:

        image

        Here are the contents of my log when performing the role hierarchy rearrangement:

        Mon Dec  7 18:33:49 2020,236 [1297] INFO VT - PearDatabase ->ADODB disconnect
Mon Dec  7 18:33:49 2020,243 [1297] DEBUG user - Entering Users() method ...
Mon Dec  7 18:33:49 2020,243 [1297] DEBUG VT - Entering getColumnFields(Users) method ...
Mon Dec  7 18:33:49 2020,243 [1297] DEBUG VT - in getColumnFields Users
Mon Dec  7 18:33:49 2020,243 [1297] DEBUG VT - Prepared sql query being executed : SELECT tabid, name, ownedby FROM vtiger_tab
Mon Dec  7 18:33:49 2020,244 [1297] DEBUG VT - Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence
		FROM vtiger_field WHERE tabid in (?)
Mon Dec  7 18:33:49 2020,244 [1297] DEBUG VT - Prepared sql query parameters : [29]
Mon Dec  7 18:33:49 2020,247 [1297] DEBUG VT - Exiting getColumnFields method ...
Mon Dec  7 18:33:49 2020,247 [1297] DEBUG user - Exiting Users() method ...
Mon Dec  7 18:33:49 2020,247 [1297] DEBUG VT - Entering getColumnFields(Users) method ...
Mon Dec  7 18:33:49 2020,247 [1297] DEBUG VT - in getColumnFields Users
Mon Dec  7 18:33:49 2020,247 [1297] DEBUG VT - Exiting getColumnFields method ...
Mon Dec  7 18:33:49 2020,247 [1297] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_tab
Mon Dec  7 18:33:49 2020,250 [1297] DEBUG VT - Prepared sql query being executed : SELECT fieldname,modulename,tablename,entityidfield,entityidcolumn from vtiger_entityname
Mon Dec  7 18:33:49 2020,254 [1297] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_role WHERE roleid = ?
Mon Dec  7 18:33:49 2020,254 [1297] DEBUG VT - Prepared sql query parameters : [H5]
Mon Dec  7 18:33:49 2020,255 [1297] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_role WHERE roleid = ?
Mon Dec  7 18:33:49 2020,255 [1297] DEBUG VT - Prepared sql query parameters : [H6]
Mon Dec  7 18:33:49 2020,255 [1297] DEBUG VT - Prepared sql query being executed : SELECT * FROM vtiger_role WHERE parentrole LIKE ? ORDER BY depth
Mon Dec  7 18:33:49 2020,255 [1297] DEBUG VT - Prepared sql query parameters : [H1::H2::H3::H4::H6::%]
Mon Dec  7 18:33:49 2020,255 [1297] DEBUG VT - Prepared sql query being executed : UPDATE vtiger_role SET rolename=?, parentrole=?, depth=?, allowassignedrecordsto=? WHERE roleid=?
Mon Dec  7 18:33:49 2020,255 [1297] DEBUG VT - Prepared sql query parameters : [rol prueba,H1::H2::H3::H4::H5::H6,5,1,H6]
Mon Dec  7 18:33:49 2020,257 [1297] DEBUG VT - Prepared sql query being executed : SELECT vtiger_profile.*
					FROM vtiger_profile
					INNER JOIN
						vtiger_role2profile ON vtiger_profile.profileid = vtiger_role2profile.profileid
						AND
						vtiger_role2profile.roleid = ?
Mon Dec  7 18:33:49 2020,257 [1297] DEBUG VT - Prepared sql query parameters : [H6]
Mon Dec  7 18:33:49 2020,258 [1297] DEBUG VT - Prepared sql query being executed : DELETE FROM vtiger_role2profile WHERE roleid=?
Mon Dec  7 18:33:49 2020,258 [1297] DEBUG VT - Prepared sql query parameters : [H6]
Mon Dec  7 18:33:49 2020,259 [1297] DEBUG VT - Prepared sql query being executed : INSERT INTO vtiger_role2profile(roleid, profileid) VALUES (?,?)
Mon Dec  7 18:33:49 2020,259 [1297] DEBUG VT - Prepared sql query parameters : [H6,5]
Mon Dec  7 18:33:49 2020,260 [1297] DEBUG VT - Prepared sql query being executed : SELECT id FROM vtiger_users WHERE status = ?
Mon Dec  7 18:33:49 2020,260 [1297] DEBUG VT - Prepared sql query parameters : [Active]
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG user - Entering Users() method ...
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - Entering getColumnFields(Users) method ...
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - in getColumnFields Users
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - Exiting getColumnFields method ...
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG user - Exiting Users() method ...
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - Entering into retrieve_entity_info(1, Users) method.
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_users where id=?
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_attachments where attachmentsid=?
Mon Dec  7 18:33:49 2020,261 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,262 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_user2role where userid=?
Mon Dec  7 18:33:49 2020,262 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,262 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_asteriskextensions where userid=?
Mon Dec  7 18:33:49 2020,262 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,262 [1297] DEBUG VT - Prepared sql query being executed : select columnname, tablename, fieldname from vtiger_field where tabid=? and vtiger_field.presence in (0,2)
Mon Dec  7 18:33:49 2020,262 [1297] DEBUG VT - Prepared sql query parameters : [29]
Mon Dec  7 18:33:49 2020,269 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_currency_info where id=? and currency_status='Active' and deleted=0
Mon Dec  7 18:33:49 2020,269 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,270 [1297] DEBUG VT - Exit from retrieve_entity_info(1, Users) method.
Mon Dec  7 18:33:49 2020,270 [1297] DEBUG VT - Entering into retrieve_entity_info(5, Users) method.
Mon Dec  7 18:33:49 2020,270 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_users where id=?
Mon Dec  7 18:33:49 2020,270 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,270 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_attachments where attachmentsid=?
Mon Dec  7 18:33:49 2020,271 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,271 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_user2role where userid=?
Mon Dec  7 18:33:49 2020,271 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,271 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_asteriskextensions where userid=?
Mon Dec  7 18:33:49 2020,271 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,272 [1297] DEBUG VT - Prepared sql query being executed : select columnname, tablename, fieldname from vtiger_field where tabid=? and vtiger_field.presence in (0,2)
Mon Dec  7 18:33:49 2020,272 [1297] DEBUG VT - Prepared sql query parameters : [29]
Mon Dec  7 18:33:49 2020,277 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_currency_info where id=? and currency_status='Active' and deleted=0
Mon Dec  7 18:33:49 2020,277 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,278 [1297] DEBUG VT - Exit from retrieve_entity_info(5, Users) method.
Mon Dec  7 18:33:49 2020,278 [1297] DEBUG user - Entering Users() method ...
Mon Dec  7 18:33:49 2020,278 [1297] DEBUG VT - Entering getColumnFields(Users) method ...
Mon Dec  7 18:33:49 2020,278 [1297] DEBUG VT - in getColumnFields Users
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Exiting getColumnFields method ...
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG user - Exiting Users() method ...
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Entering into retrieve_entity_info(1, Users) method.
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_users where id=?
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_attachments where attachmentsid=?
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_user2role where userid=?
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_asteriskextensions where userid=?
Mon Dec  7 18:33:49 2020,279 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,280 [1297] DEBUG VT - Prepared sql query being executed : select columnname, tablename, fieldname from vtiger_field where tabid=? and vtiger_field.presence in (0,2)
Mon Dec  7 18:33:49 2020,280 [1297] DEBUG VT - Prepared sql query parameters : [29]
Mon Dec  7 18:33:49 2020,282 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_currency_info where id=? and currency_status='Active' and deleted=0
Mon Dec  7 18:33:49 2020,282 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,282 [1297] DEBUG VT - Exit from retrieve_entity_info(1, Users) method.
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG user - Entering Users() method ...
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - Entering getColumnFields(Users) method ...
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - in getColumnFields Users
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - Exiting getColumnFields method ...
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG user - Exiting Users() method ...
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - Entering into retrieve_entity_info(5, Users) method.
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_users where id=?
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_attachments where attachmentsid=?
Mon Dec  7 18:33:49 2020,283 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,284 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_user2role where userid=?
Mon Dec  7 18:33:49 2020,284 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,284 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_asteriskextensions where userid=?
Mon Dec  7 18:33:49 2020,284 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,284 [1297] DEBUG VT - Prepared sql query being executed : select columnname, tablename, fieldname from vtiger_field where tabid=? and vtiger_field.presence in (0,2)
Mon Dec  7 18:33:49 2020,284 [1297] DEBUG VT - Prepared sql query parameters : [29]
Mon Dec  7 18:33:49 2020,287 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_currency_info where id=? and currency_status='Active' and deleted=0
Mon Dec  7 18:33:49 2020,287 [1297] DEBUG VT - Prepared sql query parameters : [1]
Mon Dec  7 18:33:49 2020,287 [1297] DEBUG VT - Exit from retrieve_entity_info(5, Users) method.
Mon Dec  7 18:33:49 2020,287 [1297] DEBUG VT - Entering getAllDefaultSharingAction() method ...
Mon Dec  7 18:33:49 2020,287 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_def_org_share
Mon Dec  7 18:33:49 2020,288 [1297] DEBUG VT - Exiting getAllDefaultSharingAction method ...
Mon Dec  7 18:33:49 2020,288 [1297] DEBUG VT - Prepared sql query being executed : select * from vtiger_datashare_relatedmodules
Mon Dec  7 18:33:49 2020,288 [1297] DEBUG VT - Prepared sql query being executed : SELECT name FROM vtiger_tab WHERE presence=0 AND ownedby = 0 AND isentitytype = 1 AND name NOT IN(?,?,?,?,?,?,?,?,?,?,?,?,?)
Mon Dec  7 18:33:49 2020,288 [1297] DEBUG VT - Prepared sql query parameters : [Leads,Accounts,Contacts,Potentials,HelpDesk,Emails,Campaigns,Quotes,PurchaseOrder,SalesOrder,Invoice,Calendar,Events]
Mon Dec  7 18:33:49 2020,289 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_role2role.* from vtiger_datashare_role2role inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_role2role.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_role2role.to_roleid=?
Mon Dec  7 18:33:49 2020,289 [1297] DEBUG VT - Prepared sql query parameters : [30,H6]
Mon Dec  7 18:33:49 2020,289 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_role2rs.* from vtiger_datashare_role2rs inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_role2rs.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_role2rs.to_roleandsubid in (?,?,?,?,?)
Mon Dec  7 18:33:49 2020,289 [1297] DEBUG VT - Prepared sql query parameters : [30,H1,H2,H3,H4,H6]
Mon Dec  7 18:33:49 2020,290 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_role2group.* from vtiger_datashare_role2group inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_role2group.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_role2group.to_groupid in (?,?)
Mon Dec  7 18:33:49 2020,290 [1297] DEBUG VT - Prepared sql query parameters : [30,3,4]
Mon Dec  7 18:33:49 2020,290 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_rs2role.* from vtiger_datashare_rs2role inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_rs2role.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_rs2role.to_roleid=?
Mon Dec  7 18:33:49 2020,290 [1297] DEBUG VT - Prepared sql query parameters : [30,H6]
Mon Dec  7 18:33:49 2020,290 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_rs2rs.* from vtiger_datashare_rs2rs inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_rs2rs.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_rs2rs.to_roleandsubid in (?,?,?,?,?)
Mon Dec  7 18:33:49 2020,290 [1297] DEBUG VT - Prepared sql query parameters : [30,H1,H2,H3,H4,H6]
Mon Dec  7 18:33:49 2020,291 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_rs2grp.* from vtiger_datashare_rs2grp inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_rs2grp.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_rs2grp.to_groupid in (?,?)
Mon Dec  7 18:33:49 2020,291 [1297] DEBUG VT - Prepared sql query parameters : [30,3,4]
Mon Dec  7 18:33:49 2020,291 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_grp2role.* from vtiger_datashare_grp2role inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_grp2role.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_grp2role.to_roleid=?
Mon Dec  7 18:33:49 2020,291 [1297] DEBUG VT - Prepared sql query parameters : [30,H6]
Mon Dec  7 18:33:49 2020,291 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_grp2rs.* from vtiger_datashare_grp2rs inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_grp2rs.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_grp2rs.to_roleandsubid in (?,?,?,?,?)
Mon Dec  7 18:33:49 2020,291 [1297] DEBUG VT - Prepared sql query parameters : [30,H1,H2,H3,H4,H6]
Mon Dec  7 18:33:49 2020,292 [1297] DEBUG VT - Prepared sql query being executed : select vtiger_datashare_grp2grp.* from vtiger_datashare_grp2grp inner join vtiger_datashare_module_rel on vtiger_datashare_module_rel.shareid=vtiger_datashare_grp2grp.shareid where vtiger_datashare_module_rel.tabid=? and vtiger_datashare_grp2grp.to_groupid in (?,?)
Mon Dec  7 18:33:49 2020,292 [1297] DEBUG VT - Prepared sql query parameters : [30,3,4]
Mon Dec  7 18:33:49 2020,292 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_read_user_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,292 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,292 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_write_user_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,293 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,293 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_read_group_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,293 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,293 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_write_group_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,293 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,293 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_read_user_rel_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,293 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_write_user_rel_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_read_group_rel_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query being executed : delete from vtiger_tmp_write_group_rel_sharing_per where userid=?
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query parameters : [5]
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query being executed : SELECT name FROM vtiger_tab WHERE presence=0 AND ownedby = 0 AND isentitytype = 1 AND name NOT IN(?,?)
Mon Dec  7 18:33:49 2020,294 [1297] DEBUG VT - Prepared sql query parameters : [Calendar,Events]
Mon Dec  7 18:33:49 2020,295 [1297] DEBUG VT - Entering getTabname(2) method ...
Mon Dec  7 18:33:49 2020,295 [1297] INFO VT - tab id is 2
Mon Dec  7 18:33:49 2020,295 [1297] DEBUG VT - Prepared sql query being executed : select tablabel from vtiger_tab where tabid=?
Mon Dec  7 18:33:49 2020,295 [1297] DEBUG VT - Prepared sql query parameters : [2]
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Entering getTabname(6) method ...
Mon Dec  7 18:33:49 2020,296 [1297] INFO VT - tab id is 6
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Prepared sql query being executed : select tablabel from vtiger_tab where tabid=?
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Prepared sql query parameters : [6]
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Entering getTabname(13) method ...
Mon Dec  7 18:33:49 2020,296 [1297] INFO VT - tab id is 13
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Prepared sql query being executed : select tablabel from vtiger_tab where tabid=?
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Prepared sql query parameters : [13]
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Entering getTabname(6) method ...
Mon Dec  7 18:33:49 2020,296 [1297] INFO VT - tab id is 6
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Entering getTabname(20) method ...
Mon Dec  7 18:33:49 2020,296 [1297] INFO VT - tab id is 20
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Prepared sql query being executed : select tablabel from vtiger_tab where tabid=?
Mon Dec  7 18:33:49 2020,296 [1297] DEBUG VT - Prepared sql query parameters : [20]
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Entering getTabname(6) method ...
Mon Dec  7 18:33:49 2020,297 [1297] INFO VT - tab id is 6
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Entering getTabname(2) method ...
Mon Dec  7 18:33:49 2020,297 [1297] INFO VT - tab id is 2
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Entering getTabname(22) method ...
Mon Dec  7 18:33:49 2020,297 [1297] INFO VT - tab id is 22
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Prepared sql query being executed : select tablabel from vtiger_tab where tabid=?
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Prepared sql query parameters : [22]
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Entering getTabname(6) method ...
Mon Dec  7 18:33:49 2020,297 [1297] INFO VT - tab id is 6
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Entering getTabname(2) method ...
Mon Dec  7 18:33:49 2020,297 [1297] INFO VT - tab id is 2
Mon Dec  7 18:33:49 2020,297 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Entering getTabname(20) method ...
Mon Dec  7 18:33:49 2020,298 [1297] INFO VT - tab id is 20
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Entering getTabname(23) method ...
Mon Dec  7 18:33:49 2020,298 [1297] INFO VT - tab id is 23
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Prepared sql query being executed : select tablabel from vtiger_tab where tabid=?
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Prepared sql query parameters : [23]
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Entering getTabname(6) method ...
Mon Dec  7 18:33:49 2020,298 [1297] INFO VT - tab id is 6
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Exiting getTabname method ...
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Entering getTabname(22) method ...
Mon Dec  7 18:33:49 2020,298 [1297] INFO VT - tab id is 22
Mon Dec  7 18:33:49 2020,298 [1297] DEBUG VT - Exiting getTabname method ...
      Please register or sign in to reply

      Copyright 2023 Vtiger. All rights reserved.