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.

A Blank Database = No junk profiles ?  (Mono Support )

Viewed 36505 time(s), 6 post(s) 3/1/2011 2:31:13 PMby shawndg
shawndg

shawndg

3/1/2011 2:31:13 PM

The default monox install.. installed a database full with user profiles.. etc..

Any way for us to get a clear database with all the required info.. but not all the junk profiles.. example stuff ?

Because for a real production site.. it will be a pain to go threw and delete all this stuff.. =/
This content has not been rated yet. 
1871 Reputation 252 Total posts
khorvat

khorvat

3/1/2011 3:40:51 PM
We are preparing the SQL script that will clear all demo data from database, I think we will provide you with the script tomorrow COB.

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

shawndg

3/1/2011 3:43:34 PM
OK..

Thanks!..

No Rush... As I have time.. before Im ready for it.. As the example database provides a good test foundation for now =)
This content has not been rated yet. 
1871 Reputation 252 Total posts
khorvat

khorvat

3/2/2011 10:44:21 AM
Hi,

you can find the SQL script attached. Script will clear all the demo data from the DB but it will leave the data related to the "admin" user, MonoX navigation will be left as is and you need to keep in mind that pages that contain the HtmlEditor will automatically add default content to the database.
This content has not been rated yet. 
15993 Reputation 2214 Total posts
shawndg

shawndg

8/13/2011 12:30:49 PM
Ok..

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.
they are there.. but the linking breaks.

Script
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 ?
This content has not been rated yet. 
1871 Reputation 252 Total posts
khorvat

khorvat

8/13/2011 12:57:42 PM
Hi,

  this is probably related to the fact that "ReadMore" page is created by someone other then the administrator. Can you check that and get back to us ?

Regards

BTW: For this kind of issue can you please open a new topic so we can track it better ? Thanks
This content has not been rated yet. 
15993 Reputation 2214 Total posts