Non-admin users cannot have access to any LISTVIEW in vtiger crm 7.1.0
Standard User are not able to View/List Contacts, Organizations, Opportunity, etc
This was a problem I have been struggling for couple of days, which were SOLVED completely by making sure ALL VTIGER database and tables have same collation. Since probably other VTIGER users possibly can face similar problem, I am summarizing the solution.
1) When Installing VTIGER from scratch, make sure to CREATE DATABASE/USER, instead of letting VTIGER INSTALLATON do it, prior to run VTIGER installation script and make sure to set its COLLATION to recommended "utf8_general_ci" (I used this method)
2) Case VTIGER was migrated, or after import and configurations, recoimmended solutions might be (I did not test, but very likely that it will work) altering collations and converting database and actual tables to target collation e.g. "utf8_general_ci". Please make sure to get FULL BACKUP of VTIUGER database before start making any changes to it.
crm vtiger vtigercrm
asked Jan 2 at 7:58
eimaeima
64
add a comment |
Standard User are not able to View/List Contacts, Organizations, Opportunity, etc
This was a problem I have been struggling for couple of days, which were SOLVED completely by making sure ALL VTIGER database and tables have same collation. Since probably other VTIGER users possibly can face similar problem, I am summarizing the solution.
1) When Installing VTIGER from scratch, make sure to CREATE DATABASE/USER, instead of letting VTIGER INSTALLATON do it, prior to run VTIGER installation script and make sure to set its COLLATION to recommended "utf8_general_ci" (I used this method)
2) Case VTIGER was migrated, or after import and configurations, recoimmended solutions might be (I did not test, but very likely that it will work) altering collations and converting database and actual tables to target collation e.g. "utf8_general_ci". Please make sure to get FULL BACKUP of VTIUGER database before start making any changes to it.
crm vtiger vtigercrm
asked Jan 2 at 7:58
eimaeima
64
add a comment |
Standard User are not able to View/List Contacts, Organizations, Opportunity, etc
This was a problem I have been struggling for couple of days, which were SOLVED completely by making sure ALL VTIGER database and tables have same collation. Since probably other VTIGER users possibly can face similar problem, I am summarizing the solution.
1) When Installing VTIGER from scratch, make sure to CREATE DATABASE/USER, instead of letting VTIGER INSTALLATON do it, prior to run VTIGER installation script and make sure to set its COLLATION to recommended "utf8_general_ci" (I used this method)
2) Case VTIGER was migrated, or after import and configurations, recoimmended solutions might be (I did not test, but very likely that it will work) altering collations and converting database and actual tables to target collation e.g. "utf8_general_ci". Please make sure to get FULL BACKUP of VTIUGER database before start making any changes to it.
crm vtiger vtigercrm
asked Jan 2 at 7:58
eimaeima
64
Standard User are not able to View/List Contacts, Organizations, Opportunity, etc
This was a problem I have been struggling for couple of days, which were SOLVED completely by making sure ALL VTIGER database and tables have same collation. Since probably other VTIGER users possibly can face similar problem, I am summarizing the solution.
1) When Installing VTIGER from scratch, make sure to CREATE DATABASE/USER, instead of letting VTIGER INSTALLATON do it, prior to run VTIGER installation script and make sure to set its COLLATION to recommended "utf8_general_ci" (I used this method)
2) Case VTIGER was migrated, or after import and configurations, recoimmended solutions might be (I did not test, but very likely that it will work) altering collations and converting database and actual tables to target collation e.g. "utf8_general_ci". Please make sure to get FULL BACKUP of VTIUGER database before start making any changes to it.
crm vtiger vtigercrm
crm vtiger vtigercrm
asked Jan 2 at 7:58
eimaeima
64
asked Jan 2 at 7:58
eimaeima
64
edited Jan 2 at 8:07
eima
asked Jan 2 at 7:58
eimaeima
64
asked Jan 2 at 7:58
eimaeima
64
asked Jan 2 at 7:58
eimaeima
64
64
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
go to Database. Get a backup of database.
runthe following query in database-
CREATE TABLE IF NOT EXISTS vtiger_cv2group (
cvid int(25) NOT NULL,
groupid int(25) NOT NULL,
KEY vtiger_cv2group_ibfk_1 (cvid),
KEY vtiger_groups_ibfk_1 (groupid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2role (
cvid int(25) NOT NULL,
roleid varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2rs (
cvid int(25) NOT NULL,
rsid varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2users (
cvid int(25) NOT NULL,
userid int(25) NOT NULL,
KEY vtiger_cv2users_ibfk_1 (cvid),
KEY vtiger_users_ibfk_1 (userid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Now check.
answered Jan 2 at 7:59
eimaeima
64
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003004%2fnon-admin-users-cannot-have-access-to-any-listview-in-vtiger-crm-7-1-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
go to Database. Get a backup of database.
runthe following query in database-
CREATE TABLE IF NOT EXISTS vtiger_cv2group (
cvid int(25) NOT NULL,
groupid int(25) NOT NULL,
KEY vtiger_cv2group_ibfk_1 (cvid),
KEY vtiger_groups_ibfk_1 (groupid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2role (
cvid int(25) NOT NULL,
roleid varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2rs (
cvid int(25) NOT NULL,
rsid varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2users (
cvid int(25) NOT NULL,
userid int(25) NOT NULL,
KEY vtiger_cv2users_ibfk_1 (cvid),
KEY vtiger_users_ibfk_1 (userid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Now check.
answered Jan 2 at 7:59
eimaeima
64
add a comment |
go to Database. Get a backup of database.
runthe following query in database-
CREATE TABLE IF NOT EXISTS vtiger_cv2group (
cvid int(25) NOT NULL,
groupid int(25) NOT NULL,
KEY vtiger_cv2group_ibfk_1 (cvid),
KEY vtiger_groups_ibfk_1 (groupid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2role (
cvid int(25) NOT NULL,
roleid varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2rs (
cvid int(25) NOT NULL,
rsid varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2users (
cvid int(25) NOT NULL,
userid int(25) NOT NULL,
KEY vtiger_cv2users_ibfk_1 (cvid),
KEY vtiger_users_ibfk_1 (userid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Now check.
answered Jan 2 at 7:59
eimaeima
64
add a comment |
go to Database. Get a backup of database.
runthe following query in database-
CREATE TABLE IF NOT EXISTS vtiger_cv2group (
cvid int(25) NOT NULL,
groupid int(25) NOT NULL,
KEY vtiger_cv2group_ibfk_1 (cvid),
KEY vtiger_groups_ibfk_1 (groupid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2role (
cvid int(25) NOT NULL,
roleid varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2rs (
cvid int(25) NOT NULL,
rsid varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2users (
cvid int(25) NOT NULL,
userid int(25) NOT NULL,
KEY vtiger_cv2users_ibfk_1 (cvid),
KEY vtiger_users_ibfk_1 (userid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Now check.
answered Jan 2 at 7:59
eimaeima
64
go to Database. Get a backup of database.
runthe following query in database-
CREATE TABLE IF NOT EXISTS vtiger_cv2group (
cvid int(25) NOT NULL,
groupid int(25) NOT NULL,
KEY vtiger_cv2group_ibfk_1 (cvid),
KEY vtiger_groups_ibfk_1 (groupid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2role (
cvid int(25) NOT NULL,
roleid varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2rs (
cvid int(25) NOT NULL,
rsid varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS vtiger_cv2users (
cvid int(25) NOT NULL,
userid int(25) NOT NULL,
KEY vtiger_cv2users_ibfk_1 (cvid),
KEY vtiger_users_ibfk_1 (userid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Now check.
answered Jan 2 at 7:59
eimaeima
64
answered Jan 2 at 7:59
eimaeima
64
answered Jan 2 at 7:59
eimaeima
64
answered Jan 2 at 7:59
eimaeima
64
64
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54003004%2fnon-admin-users-cannot-have-access-to-any-listview-in-vtiger-crm-7-1-0%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
