Upgraded Able 7 site Jr Admin permissions do not work

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Upgraded Able 7 site Jr Admin permissions do not work

Post by AbleMods » Tue Jan 28, 2014 9:17 am

When working with a new Gold install, you'll see "Junior Admin" as a role in the ac_Roles table. This value is hard-coded in certain web.config files as well as the /app_data/Adminmenu.xml file.

However, existing Able 7.x sites use a value of "Jr. Admin". The value is not translated during the upgrade to Gold.

This breaks junior-admin security support in the upgraded site. The Able Gold code cannot accurately detect that "Jr. Admin" is considered an Admin role.

The solution is simple. Use SQL Studio Management to open the ac_Roles table for editing. Change the "Jr. Admin" role name to "Junior Admin". Be sure to change the corresponding lower case value as well.

This issue only appears if upgrading an existing Able 7.x database. It doesn't not seem to be a problem in any version of a fresh Gold install.

I have reported this via Feedback.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
ForumsAdmin
AbleCommerce Moderator
AbleCommerce Moderator
Posts: 399
Joined: Wed Mar 13, 2013 7:19 am

Re: Upgraded Able 7 site Jr Admin permissions do not work

Post by ForumsAdmin » Fri Jan 31, 2014 4:01 am

We will see if this can be fixed in the automatic upgrade.

Post Reply