Problem accessing Object Settings

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

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

3/28/2011 6:14:46 AM

andydkelly

Total Posts 16

View Posts

Problem accessing Object Settings

Hi,

I recently successfully (thanks to help from these forums!) migrated my local MojoPortal installation and site to my hosting company however i have one final issue. Any of the page items that i created locally i now cannot change however any new ones i change i can access. I have tried as my user or as Admin but when i click on Seetings i get the message:

Sorry, you are not allowed to edit this content. If you have questions about your permissions, please contact a site administrator.
Return to Site Home

I am guessing this is a security issue in the database. Can someone help me fix this? If it involves making changes in the DB i would rather do it now whilst the site is still relatively small.

Cheers

Andy

3/28/2011 1:28:20 PM

andydkelly

Total Posts 16

View Posts

Re: Problem accessing Object Settings

It is the Feature Instance Settings i cannot into.

Thanks

Andy

4/4/2011 4:35:01 AM

andydkelly

Total Posts 16

View Posts

Re: Problem accessing Object Settings

Any ideas guys??

Andy

4/4/2011 6:53:41 AM

Joe Audette

Total Posts 18439

View Posts

Re: Problem accessing Object Settings

Hi Andy,

Sorry for the delay, I thought from your other posts that you had got everything working.

To be able to help I would need to know more about what you did to "migrate" the data from your local machine.

My guess is something is not mapped to the right ids (PageID, PageGuid, ModuleID, ModuleGuid, ModuleDefID, FeatureGuid), in one or more of these tables:

mp_Pages
mp_PageModules
mp_FriendlyUrls
mp_Modules
mp_ModuleDefinitions
possibly others

probably the migration process lost some of the correct mappings/relationships

Hope it helps,

Joe

4/4/2011 7:52:39 AM

andydkelly

Total Posts 16

View Posts

Re: Problem accessing Object Settings

Hi Joe,

I created a new site and new blank database on my hosting server. I then imported my MojoPortal directory and ran the default.aspx page which configured the site and built the database structure. I then imported the database data from my local copy. This is the only thing not working now. I am guessing like you say that somewhere in the database the Features are pointing to the local user GUIDs for security or something similar but i have trawled the database and am unable to pin down where this would be.

I hope this sheds a little light on the matter for you.

Thanks

Andy

4/4/2011 8:25:28 AM

Joe Audette

Total Posts 18439

View Posts

Re: Problem accessing Object Settings

I would compare the rows for the affected pages (in the tables mentioned) in your local copy vs the server copy and look for differences in IDs. Unless you did identity inserts while importing, the integer ids probably changed on the way in, or if you left out any fields such as the guid ids while importing it can cause problems.

Importing data is dodgy, it would have been better to restore a backup or use a tool to script off the data and structure together so that it landed exactly as it was.

The only way to fix it is to understand what changed and correct the mappings in the data, or delete the pages and content and re-create them using copy paste from your local copy.

Best,

Joe

4/4/2011 8:30:01 AM

andydkelly

Total Posts 16

View Posts

Re: Problem accessing Object Settings

Thanks Joe.

I actually "imported" the data by using SQL Management Studio to script off the Structure and Data into a T-SQL file then ran this on the new Database.

Will have a look at the tables mentioned.

Thanks! Really impressed with MojoPortal and cannot sing its praises highly enough!

Andy

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