click on Settings link using Admin user redirect me to

click on Settings link using Admin user redirect me to EditAccesDenied page issue

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

This thread is closed to new posts. You must sign in to post in the forums.

9/12/2013 6:01:41 AM

valik

Total Posts 98

View Posts

click on Settings link using Admin user redirect me to EditAccesDenied page issue

Hello,

Something is strange with my old html contents(i did upgrade from 2.3.3.4 to 2.3.9.8).

I cannot go to any content settings page. I'm administrator. But i can go to Edit page.

I check in DB for a content example(HtmlContent type) and i see that i have the same values like for a new content added. (i check mp_Modules table and the column 'AuthorizedEditRoles' have empty value).

For the new contents i can go on this page.

I want to specify that the problem is only on my english interface, for the rest interfaces are ok. I use folders based.

please help me

thank you

9/12/2013 6:55:24 AM

valik

Total Posts 98

View Posts

Re: click on Settings link using Admin user redirect me to EditAccesDenied page issue

hello,

i investigate the above issue.

i debugging on source code.

i cannot acces the settings page because the SiteGuid from modules are different than coresponding SiteGuid from mp_Sites table.

i don't know how this is happens.

example:

i have 3 sites:

admin site -> SiteID = 1, SiteGuid = 0000.0001

En Site -> SiteID = 2, SiteGuid = 0000.0002

FR Site -> SiteID = 3, SiteGuid = 0000.0003

on my list of modules i have

module 1 - > SiteID = 2, SiteGuid = 0000.0001 - see here that are not the correct data.

the correct line should be:

module 1 - > SiteID = 2, SiteGuid = 0000.0002

probably in the past i create these modules on the main site? but i cannot explain why SiteID is correct and SiteGuid not.

Advice me please what i can do.

I can create a sql script for updating mp_modules table with corresponding values from mp_Sites ?

Thank you,

valik

9/12/2013 11:40:45 AM

Joe Audette

Total Posts 18439

View Posts

Re: click on Settings link using Admin user redirect me to EditAccesDenied page issue

Hi,

It would be good if you can run a query to correct the siteguids, but I don't really think that is the cause of the problem.

However what you posted about SiteGuids I guess you mean they all have empty guids ie: "00000000-0000-0000-0000-000000000000" then you need to update them to new guids using

UPDATE mp_Sites SET SiteGuid = SELECT newid()

But then other data should ideally also be wired up with the correct siteguids in other tables. Some tables also have SiteID which could be used in queries to update them to the correct siteguid.

But the above may not be the problem about access denied.

You are upgrading from a very old version and I think we did change something at one point a long while back about how roles are stored.

I would look in mp_Modules.AuthorizedEditRoles and mp__Pages.EditRoles

If it looks like the affected rows have "Admins" as the value, run a query to update those to empty string and see if that solves the problem.

Hope that helps,

Joe

You must sign in to post in the forums. This thread is closed to new posts.