Access denied error in Administration>Configuration>Email Accounts

Help.  I updated 1.7 to 1.8 on my local machine.  Everything is working great except trying to configure the email accounts in the admin.  Just get the generic "You do not have permission to perform the selected operation." when trying to access http://localhost:8242/administration/emailaccounts.aspx in the admin section.  

The same error occurs in the SMS sexction, although I don't need that functionality.  I've cleared the cache, recompiled, etc to no avail.  Permissions are fine. Using Visual Studio 2010 and SQL 2008.  Did I overlook a SQL script in the update or??

Thanks.

You are seeing the error because you have the ACL (Access Control List) enabled, but the entry to manage email accounts (system keyword: ManageEmailSettings) is missing from the Nop_CustomerAction table (this is a bug already reported in the 1.80 release announcement topic). Run the following SQL query on your database to add the entry to manage email accounts (query copied from the bug report):

IF NOT EXISTS (
    SELECT 1
    FROM [dbo].[Nop_CustomerAction]
    WHERE [SystemKeyword] = N'ManageEmailSettings')
BEGIN
  INSERT [dbo].[Nop_CustomerAction] ([Name], [SystemKeyword], [Comment], [DisplayOrder])
  VALUES (N'Manage Email Settings', N'ManageEmailSettings', N'', 20)
END
GO 

You can then go to Administration > Configuration > Access control list and enable the manage email settings action (named "Manage Email Settings") for your user's role. The action for accessing the SMS Providers is named "Manage SMS Providers" is already on the list but probably unchecked.

You may need to clear the cache after this and access the previously denied areas via the menu as refreshing the 'denied' page won't take you to the resource.

.

Thanks mb for the quick response and concise directions. Everything now works. It took just a minute to run the SQL script, clear cache and start adding more email accounts -- saving me tons of time!

Why cant i fine email account to setup my contact page what do i do

hi

admin

configuration --> email accounts

select the default account and edit the details accordingly

wbesthorne wrote:

Hi,

I replied you here with step by step instructions: http://www.strivingprogrammers.com/boards/t/50/how-to-setup-contact-us-form-in-nopcommerce.aspx

Thank you mb, thank God that was a quick fix... no need to debug, recompile and deploy.... i was definitely not in the mood for that.... :)

THANKS VERY MUCH 'MB' - YOUR LITTLE SQL SQRIPT FIXED IT RIGHT UP. i WAS RIGHT WHEN I FIRST SETUP OVER A YEAR AGO, I HAD MANAGED TO SETUP 3 EMAIL ADDRESSES - I DON'T UNDERSTAND HOW 20 WAS MISSING AND I WAS ABLE TO MANAGE EMAILS????

Hi
I have the same error message on Email Accounts:
You do not have permission to perform the selected operation.
I´ve upgraded to 2.4 version.
I´ve run the SQL script and returned:
Mens. 208, Nivel 16, Estado 1, Línea 1
Invalid object name 'dbo.Nop_CustomerAction'.

This isssue is solved by the correct script?
Do I need to restore to 1.7 and then check email account?

Thanks in advance.

Best Regards,

Germán