| « Browse websites on non-standard ports like 79 with Firefox | Cake and Water plants » |
If you have vTiger error like:
/var/www/vtigercrm/usr_privileges/sharing_priviliges_xyz.php on line xyz
its because of erroneous data in your vtiger database.
ERRONEOUS DATA FROM DATABASE:
login into mysql:
mysql -u root -p
use vtiger;
select * from vtiger_def_org_share where editstatus=0;
output:
+--------+-------+------------+------------+
| ruleid | tabid | permission | editstatus |
+--------+-------+------------+------------+
| 1 | 2 | 2 | 0 |
| 3 | 6 | 2 | 0 |
| 4 | 7 | 2 | 0 |
| 6 | 13 | 1 | 0 |
| 8 | 20 | 2 | 0 |
| 9 | 21 | 2 | 0 |
| 10 | 22 | 2 | 0 |
| 11 | 23 | 2 | 0 |
| 12 | 26 | 2 | 0 |
| 13 | 8 | 2 | 0 |
| 14 | 30 | 3 | 0 |
| 15 | 32 | 2 | 0 |
| 16 | 38 | NULL | 0 |
+--------+-------+------------+------------+
13 rows in set (0.00 sec)
The NULL data is what caused the error to be generated as VTiger creates a php
file from this database each time you create a user. After reviewing your privileges
under "Sharing Access" in the admin area - it looks like your install is corrupted or
your database data is corrupt. At the end of organizational sharing rules, you will
find the grid is not displayed correctly at the end.
As a warning, if someone does recalculate your permissions, it is possible you have
other errors show up due VTiger currently not being a proper installation with regards
to this.
QUERY WHICH FIX THE ISSUE:
update vtiger_def_org_share set permission = 2 where ruleid = 16 and tabid = 38
Thanks to Martin our consultant :-)
Cheers
Daniel
Trackback URL (right click and copy shortcut/link location)
This post has 546 feedbacks awaiting moderation...