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 )

Viewed 20318 time(s), 4 post(s) 8/13/2011 1:27:00 PMby shawndg
shawndg

shawndg

8/13/2011 1:27:36 PM
 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
This content has not been rated yet. 
1871 Reputation 252 Total posts
khorvat

khorvat

8/13/2011 2:36:08 PM
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
This content has not been rated yet. 
15993 Reputation 2214 Total posts
shawndg

shawndg

8/14/2011 12:17:39 PM
Im not sure..

What table should I be looking in ?
This content has not been rated yet. 
1871 Reputation 252 Total posts
khorvat

khorvat

8/14/2011 2:25:26 PM
Hi,

  you need to look at the NewsItem table to check what PageId is set and then check the Page table for that Id.

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