MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Upgrade from 4_1_2741_40 to4_5_3057_40 (Closed) (Mono Support )

Viewed 17602 time(s), 9 post(s) 11/21/2011 4:10:58 PMby rule128
rule128

rule128

11/21/2011 4:10:59 PM
Hello

I have used the patch MonoX_Source_Patch_4_1_2741_40_to_4_5_3057_40 in order to upgrade from 4_1_2741_40 to4_5_3057_40
If i go to http://localhost:2666/Default.aspx I get the error :
"Personalization is not enabled and/or modifiable. The Enabled property must
be set to true, and a registered personalization provider must be selected. The
current user must be granted the right to modify personalization state"

I see the post :http://www.mono-software.com/Mono/Pages/Discussion/dtopic/hfG776X7CEe0oJ9_AVRDVw/Upgrading-to-4-5/?dbmpageno=1#dbmPageNopg
but unfortunately I can not solve the problem. I have tried both with the old and new web.config. The "appSettings" is synchronized. Any other ideas?

The second problem is after I log in. I get the error:
"
Invalid column name 'CampaignId'.
Invalid column name 'PageId'.
Invalid column name 'UserId'.
Invalid column name 'NewsCategoryId'.
Invalid column name 'NewsletterId'.
Invalid column name 'PollId'.
Invalid column name 'GroupId'.Description: An unhandled exception occurred during the exec"

I suppose that I did not run the correct sql update scripts.
I have used the one from "\Portal\MonoX\Installer\Sql\UpgradeScripts" from 4.1.2704.35 till 4.5.3016.35

Regards

This content has not been rated yet. 
265 Reputation 29 Total posts
khorvat

khorvat

11/21/2011 5:06:45 PM
Hi,

can you please check if resetting the personalization for this page is an option for you ? If so reset the personalization and get back to us with the result.

As for the SQL error you get, can you please provide us with the whole SQL error message that you get ?

Thanks
This content has not been rated yet. 
15993 Reputation 2214 Total posts
rule128

rule128

11/21/2011 5:15:43 PM
Hello


How can I reset the personalization? I can not access the administration page.

Please see the error that I get


{"An exception was caught during the execution of a retrieval query: Invalid column name 'CampaignId'.\r\nInvalid column name 'PageId'.\r\nInvalid column name 'UserId'.\r\nInvalid column name 'NewsCategoryId'.\r\nInvalid column name 'NewsletterId'.\r\nInvalid column name 'PollId'.\r\nInvalid column name 'GroupId'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception."}


Regards
This content has not been rated yet. 
265 Reputation 29 Total posts
khorvat

khorvat

11/21/2011 5:22:23 PM
Hi,

I suppose that you are missing this SQL script can you please check the attached script content and see if this is the missing piece ?

Regards 
This content has not been rated yet. 
15993 Reputation 2214 Total posts
rule128

rule128

11/21/2011 5:39:11 PM
OK

ALTER TABLE dbo.SnRelationship ADD
GroupId uniqueidentifier NULL,
UserId uniqueidentifier NULL,
CampaignId uniqueidentifier NULL,
NewsCategoryId uniqueidentifier NULL,
NewsletterId uniqueidentifier NULL,
PageId uniqueidentifier NULL,
PollId uniqueidentifier NULL

did the trick but I got error when I have tried to set the foreign keys:
ALTER TABLE dbo.SnRelationship ADD CONSTRAINT
FK_SnRelationship_SnGroup FOREIGN KEY
(
GroupId
) REFERENCES dbo.SnGroup
(
Id
) ON UPDATE NO ACTION
ON DELETE NO ACTION

and the error is:

Msg 1776, Level 16, State 0, Line 2
There are no primary or candidate keys in the referenced table 'dbo.SnGroup' that match the referencing column list in the foreign key 'FK_SnRelationship_SnGroup'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.

After I have rested the personalization for the default page it seems to work OK.

Thanks for the help


This content has not been rated yet. 
265 Reputation 29 Total posts
khorvat

khorvat

11/22/2011 7:51:45 AM
I'm glad that personalization error i gone now, and the SQL error seems a bit odd to me because you will have to have the primary key field Id, so please check if everything is ok with the SnGroup table.

Regards
This content has not been rated yet. 
15993 Reputation 2214 Total posts
rule128

rule128

11/22/2011 9:24:49 AM
Hello

I have set the primary key to id and now it works OK

Thanks
This content has not been rated yet. 
265 Reputation 29 Total posts
khorvat

khorvat

11/22/2011 9:45:33 AM
Ok, I suppose that I can mark this issue as solved.
This content has not been rated yet. 
15993 Reputation 2214 Total posts
rule128

rule128

11/22/2011 10:14:42 AM
Yes it is solved

Regards
This content has not been rated yet. 
265 Reputation 29 Total posts