« Browse websites on non-standard ports like 79 with FirefoxCake and Water plants »

vTiger permission Issues

01/18/10

Permalink 01:44:28 am, by novecento Email , 180 words   English (US)
Categories: News

vTiger permission Issues

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 address for this post

Trackback URL (right click and copy shortcut/link location)

Feedback awaiting moderation

This post has 546 feedbacks awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)