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.

Clear MonoX Demo data script Issue. (Mono Support )

21188 put(a) pogledan, 4 odgovor(a) 13.8.2011. 13:27:00, Kreirao(la) shawndg

shawndg

13.8.2011. 13:27:36

I ran this script but I edited a little I did not want to delete some sections because I had data in them.. Now.. I got it working pretty good except for the fact then when I run it.. I can no longer click on my news articles.<br /> they are there.. but the linking breaks.

DECLARE @AdminID varchar(max);

set @AdminID = '67C919E2-8DF4-476A-B312-C26F82A36CFB'

DELETE FROM SnRelationship

DELETE FROM SnNote

DELETE FROM SnDiscussionTopic

DELETE FROM SnFriendRequest

DELETE FROM BlogEditor

DELETE FROM SnAlbum

DELETE FROM SnMessage

DELETE FROM BlogCategory

DELETE FROM Blog

DELETE FROM SnDiscussionBoardModerator

DELETE FROM SnDiscussionBoardInRole

DELETE FROM SnDiscussionBoard

DELETE FROM SnFriend

DELETE FROM SnGroup

DELETE FROM oaToken

DELETE FROM aspnet_PersonalizationPerUser

DELETE FROM Page WHERE UserID <> @AdminID

DELETE FROM aspnet_Profile WHERE UserID <> @AdminID

DELETE FROM aspnet_UsersInRoles WHERE UserID <> @AdminID

DELETE FROM aspnet_Membership WHERE UserID <> @AdminID

DELETE FROM aspnet_Users WHERE UserID <> @AdminID

DELETE
FROM aspnet_Roles WHERE RoleName NOT IN ( 'AdManagers',
'Administrators', 'All Users', 'Editors', 'NewsEditors', 'Publishers',
'Registered', 'Users' )

DELETE FROM aspnet_applications WHERE ApplicationName <> 'MonoX'

DELETE FROM aspnet_PersonalizationAllUsers

DELETE FROM aspnet_Paths

DELETE FROM aspnet_WebEvent_Events

--DELETE FROM Ad

--DELETE FROM AdPage

DELETE FROM BlogPost

DELETE FROM BlogPostCategory

DELETE FROM BlogPostRole

--DELETE FROM Campaign

--DELETE FROM Document

--DELETE FROM List

--DELETE FROM ListItem

--DELETE FROM ListItemLocalization

--DELETE FROM NewsCategory

--DELETE FROM NewsCategoryInRole

--DELETE FROM NewsCategoryLocalization

--DELETE FROM NewsCategoryTemplate

--DELETE FROM NewsFile

--DELETE FROM NewsItem

--DELETE FROM NewsItemLocalization

DELETE FROM Newsletter

DELETE FROM NewsletterLog

DELETE FROM NewsletterRole

DELETE FROM NewsMetaIgnoredWord

--DELETE FROM NewsPublishQueue

DELETE FROM oaConsumer

DELETE FROM oaToken

DELETE FROM Poll

DELETE FROM PollAnswer

DELETE FROM PollAnswerLocalization

DELETE FROM PollLocalization

DELETE FROM PrivacyLevelDefinition

DELETE FROM SnDiscussionMessage

DELETE FROM SnFriendList

DELETE FROM SnFriendListMember

DELETE FROM SnGroupCategory

DELETE FROM SnGroupMember

DELETE FROM SnGroupRequest

DELETE FROM SnInvitation

DELETE FROM SnMessageRecipient

DELETE FROM TermsAndConditions

DELETE FROM UserAvatar

DELETE FROM UserProfile WHERE ID <> @AdminID

DELETE FROM [Version]

Im not sure what section would be causing me to lose the linking that makes the news headings work ?

All the news articles where setup as a admin..
The Readmore page was hard coded in

Ovaj sadržaj još nije ocijenjen.

1871 Reputacija 252 Ukupno objava

khorvat

13.8.2011. 14:36:08

Hi,

if page was hard-coded can you please take a look who was the owner of the page ? If admin wasn't the owner the you have deleted the page and news templates can't find the page to direct to.

Regards

Ovaj sadržaj još nije ocijenjen.

15993 Reputacija 2214 Ukupno objava