Today we have released the second service pack to Community Server 2007. You can download it from the store/download center.

Note: The download contains the SP1 as well, so if you did not apply the first service pack, you can skip it and move directly to SP2.

Enhancements:

• Updated Manage Licenses page.
• Updated GetBodySummary to support specifying a CSS class instead of static colors.
• Update User Cache keys to avoid conflicts with numeric user names vs userid.
• Updated Chameleon list controls to not render any standard templates if there are no items to bind and the NoneTemplate is not defined.
• Updated TagCloudBase, InlineTagEditorBase, InlineContentEditor, and ContentPart controls to not render class attributes when the class name is empty.
• Added ParentSectionID and ParentSectionApplicationKey properties to the SectionQuery control to support specifying/overridding the parent section used when querying sections using Chameleon controls.
• Restored support for "Require authentication for profile viewing" option.
• Updated PreTemplatedPagerBase to set its visibility to false when there are no items to render.
• Corrected markup issue on the search page of the traveler theme.
• Fixed post view counting in all applications. Count now increments only on full post view except for forums.
• Fixed extraneous closing div tag in Traveler blog theme.
• Corrected markup issue on Simple blog theme's post.aspx page.
• Updated Thread that the user is monitoring was modified, and Forum that the user is monitoring was modified email templates.
• Added support for TruncateQueryFiltersAt, QueryFilterTruncationEllipsisText/ResourceName/ResourceFile properties on the SearchForm control.
• Updated TagBreadCrumb control to always honor ShowAllTags property.
• Fixed issue with some CSS markup in emails on gmail with IE7.
• Added support for EnableFileDateVersioning property on Script and Style controls.
• Added Rss LinkTo option to File Gallery GroupData control.
• Corrected ApplicationType-based queries for tags in the File Gallery TagCloud control to retrieve tags for FileGallery instead of Weblogs.
• Updated logic for the RssComments LinkTo value of GalleryPostData to match the display conditions of the related feed.
• Added support for GroupID in ForumThreadQueries.
• Password removed from create user email except for situations where the password was generated by Community Server.
• Updated GroupID query support in forums to include sub-forums.
• Added check to not render post tag editable lists when there are no tags to render and the control is not editable.
• Forum post objects are now more fully populated when creating/editing them.

Bug Fixes:

• Fix for missing row ids, which cause the photos posteditcontrol to break if a user disables trackbacks or ratings for a gallery.
• Removed the beta warning message on homepage welcome content part.
• Correcting TinyMCE editor issue in IE6 on Windows 2000/Windows XP (pre-SP2)
• ForumPostAnswerToggleButton - corrected check to enable thread starters to toggle answer statuses (updated logic to match Visible property)
• Sub forms now fire after committing the new user to the database in the CreateUserForm
• Aggregate Post Size in the Blog Presentation Settings now works
• Corrected issue preventing scored blog posts from being paged.
• Removed requirement to identify whether a URL contains a querystring when calling FormatUrlWithUserNameToken.  This also corrects issues where the querystring flag was incorrectly set.
• InviteUserForm now has IsValid check performed on SubForms before committing invitation.
• Corrected over-paging issue in the ScrollingPager control when GroupedItemsPerPage > 1.
• Report Abuse no longer displays exception whenever a registered user reports a post as being abusive.
• Corrected constant redirection when clicking the latest post link and viewing in threaded view.
• Update to moderation form change -- corrected JavaScript/AJAX error in FF and correct premature redirection to the main moderation page.
• Fixed "# of moderated posts" calculation in Weblog Create/Update/Delete sprocs
• Fixed ThemeConfigurations class to not blow up when it’s trying to get configurations under a non-web environment (windows services).
• Fixed the Filter Unread Posts drop down so that it works correctly when applying the changes permanently 
• Updated JavaScript used by the DefaultButtonTextBox control to properly cancel the keydown event.
• Rolled Feed Username now is properly Html Decoded.
• Fixed blog CP comments screen to not lose the feedback formatting when using the bulk publish/unpublish buttons.
• Fixed delete comment issue on default blog and on lean and green blog theme.
• Removed invalid JavaScript link around thread status icons
• Fixed an issue with Users.FindUserByEmail which failed to find users in the aspnet tables who don't yet have a Community Server profile
• Fixed error caused by an ampersand in a username.
• JavaScript updated to work in IE and FireFox for ConfirmationPage
• When threaded viewing a thread that has more than MaximumPostsToDisplay (200) the warning message is now formatted correctly.
• Corrected downloading PDF in IE6 issue in DownloadEntryForm control
• Updated improper use of Response.Url in ReturnUrls to instead use CSContext.RawUrl
• Added check to see if role already assigned to user before trying to assign it.
• Fixed issue when you use a TextPart with no values inside a blog post, such as "[name]" so that it now returns null when trying to access the value, instead of throwing an exception.
• Modified MetaBlogExtender CSModule to ignore TextParts with null values.
• Corrected cache vary-by parameters for avatar caching.
• Now you can delete a role that was assigned to a permission (global or section) without causing an exception.