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

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

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

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

Hello

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

Thanks

Ok, I suppose that I can mark this issue as solved.

Yes it is solved

Regards