Lunarmedia

Web Deploy: (401) Unauthorized

Anders Vindberg — Tue, 17 Jan 2012 12:20:00 GMT

If you are getting the 401 Unauthorized error from Visual Studio when trying to use Web Deploy, then (because of a Bug in Web Deploy (also version 2)) add this to your regedit:

at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

add DWORD: LocalAccountTokenFilterPolicy with value: 1.

Now you can use a windows user that is a member of your admin group (not the native admin) to deploy your content!

IIS6: The service did not respond to the start or control request in a timely fashion

Anders Vindberg — Fri, 25 Nov 2011 19:14:00 GMT

After a Windows Update on our Win2003 server, we suddently received this message when trying to stop or start an app pool or website.

For our particular situation I found the answer on JessWatts.com:

"It is possible that a shared dll that IIS 6 relies on has become unregistered.
Try running the following command: regsvr32 qmgr.dll
Then reboot the server and start the failed websites."

Thanks Jess!

Solr delete/clear index

Anders Vindberg — Wed, 19 Oct 2011 06:13:00 GMT

To delete/clear the solr index.

Simply run both of these in the browser (change the "solr" name and port to your specific solr instance name if the default wasn't used):

1. http://localhost:8080/solr/update?stream.body=%3Cdelete%3E%3Cquery%3E*:*%3C/query%3E%3C/delete%3E
2. http://localhost:8080/solr/update?stream.body=%3Ccommit/%3E

Performance with Entity Framework

Anders Vindberg — Thu, 22 Sep 2011 20:22:00 GMT

Here are some links to great resources if you are looking to build high-performance enterprise website solutions:

Microsoft is moving fast these days. The entity framework is getting more functionality and structure as it progresses. It seems to be implementing several best practice patterns such as repository and unit of work patterns among others.

Sql Profiler - Analyzing number of database calls

Anders Vindberg — Thu, 20 Jan 2011 13:33:00 GMT

Is your pageload taking more than 0.2 seconds! its time to investigate how many database roundtrips your webapplication is making. If you haven't got Sql Profiler (with MS Sql Server) go download AnjLab Sql Profiler its free.

To identify database roundtrips from an application, Setup the following events:

RPC:Completed SQL:BatchCompleted

And this filter: TextData Not Like exec sp_reset_connection%

Source: Jeremy Jameson - http://blogs.msdn.com/b/jjameson/archive/2010/09/03/analyzing-database-roundtrips-with-sql-server-profiler.aspx

IIS Application Pool Queue Length Settings

Anders Vindberg — Mon, 06 Dec 2010 13:16:00 GMT

This is hard to find information:

The default limit for an application pool is 4000 requests. On a moderately sized server with a few application pools configured, this might be a good value. However, on a server with multiple CPUs and lots of RAM, this value might be too low. On a server with limited resources or many application pools configured, this value might be too high. Here you might want to use a formula of Memory Size in Megabytes x Number of CPUs x 10 divided by Number of Configured Application Pools to determine what the size of the average request queue should be. This is meant to be a guideline to give you a starting point for consideration and not an absolute rule. For example, on a server with two CPUs, 1024 MB of RAM, and twenty configured application pools, the size of the average request queue limit would be around 1,000 requests. You might have some application pools configured with request queue limits of 750 and others with request queue limits of 1,250. However, if the same server had only one configured application pool, you probably wouldn’t configure a request queue limit of 10,000.

Source: http://forums.asp.net/p/623323/623323.aspx (Matthew, Microsoft).

Dealing with TC/CS DateFormats

Anders Vindberg — Tue, 02 Nov 2010 15:53:00 GMT

Defining a specific date format in TC (and CS (Community Server)) can be tricky. An example could be: "30 september, 2003" or "01-01-2010".

First you need to know that all the users you may have registered in your database will not be affected by changes made to the default date format defined in the controlpanel. They each need to select a new date format in their profile settings to get a new date format.

Working with a new TC website you should define the preferred date format before any users are registered:

Search for "Utility_DateFormatDropDownList_F1" in your language files located in the "languages" folder.
Edit one or more of the defined date formats if your preferred format is not already defined. Reset the application pool (iisreset).
Goto yourwebsite.com/controlpanel/Settings/Setup.aspx and select the preferred date format. Press "Save".

From this time forward new users will be preselected to use the date format selected. They can still at any time goto their profile settings to select a different format from the dropdown list unless you simply remove this from the template :).

The defaultDate defined in the web.config file can be disregarded.

Scandinavian letters (ÆØÅ) in javascript formatting!

Anders Vindberg — Thu, 09 Sep 2010 07:53:00 GMT

For future reference I am writing this post: ÆØÅ in JavaScript - simply save .js file as UTF-8 formatting! On how to save in UTF-8 encoding in Visual Studio 2010 see this answer: UTF-8 Encoding at Stackoverflow.

TC 5.5 Localization

Anders Vindberg — Thu, 12 Aug 2010 12:33:00 GMT

Everything in Telligent Community is becoming increasingly complex. A simple feature as localization has once again been filtered into the database. Its important to know if you are translating TC into a none-english language that profile field names and profile widget headlines are located in controlpanel (Membership) and not in the language files where they belong!

UPDATE: The widget headlines can be defined in codebehind and thus reference the language files. The profile fields can also reference the language file if defined in the theme.config file! Adding them adhoc is still an issue.

CSControl:Pager Template Styling

Anders Vindberg — Wed, 28 Jul 2010 07:44:00 GMT

Styling the pager control in Community Server always escapes me so here is an example:

<CSControl:Pager id="pager" runat="Server" Tag="div" style='text-align: center;'>
<FirstLinkTemplate>
<CSControl:CSLinkData LinkTo="Link" LinkCssClass="TextButton" runat="server"><ContentTemplate>Newest</ContentTemplate></CSControl:CSLinkData>
</FirstLinkTemplate>
<PreviousLinkTemplate>
<CSControl:CSLinkData LinkTo="Link" LinkCssClass="TextButton" runat="server"><ContentTemplate>Newer</ContentTemplate></CSControl:CSLinkData>
</PreviousLinkTemplate>
<PageLinkTemplate>
<CSControl:CSLinkData LinkTo="Link" Property="Text" Text="{0}" LinkCssClass="TextButton" runat="server" />
</PageLinkTemplate>
<CurrentPageLinkTemplate>
<CSControl:CSLinkData Tag="Span" CssClass="TextButtonDisabled" Property="Text" Text="{0}" runat="server" />
</CurrentPageLinkTemplate>
<SeparatorTemplate></SeparatorTemplate>
<NextLinkTemplate>
<CSControl:CSLinkData LinkTo="Link" LinkCssClass="TextButton" runat="server"><ContentTemplate>Older</ContentTemplate></CSControl:CSLinkData>
</NextLinkTemplate>
<LastLinkTemplate>
<CSControl:CSLinkData LinkTo="Link" LinkCssClass="TextButton" runat="server"><ContentTemplate>Oldest</ContentTemplate></CSControl:CSLinkData>
</LastLinkTemplate>
</CSControl:Pager>

Source: http://getben.com/archive/2007/01/30/introduction-to-chameleon-questions-and-answers.aspx

Visual Studio (VS) 2010 Build Configuration dropdown

Anders Vindberg — Thu, 22 Apr 2010 14:41:00 GMT

If you happen to be missing the Build configuration dropdown menu from your toolbar in Visual Studio 2010 and can't find it in the Build toolbar here is how you add it back in:

Tools -> Customize -> Commands (tab). Select "Toolbar:" and then select "Build" from the dropdown.

Click on "Add Command", select "Build" in Categories and find "Solution Configurations" (at the bottom). Click "Ok" and it is back in the "Build" toolbar!

Entity Framework 4.0 RC: Cannot insert the value NULL into column '*_Id', table 'Paragraphs'; column does not allow nulls. INSERT fails. The statement has been terminated.

Anders Vindberg — Thu, 08 Apr 2010 12:34:00 GMT

Entity Framework 4.0 RC bug. Usually after an "update model from database" I encounter this error message: Cannot insert the value NULL into column '*_Id', table 'column does not allow nulls. INSERT fails. The statement has been terminated.

To fix the association between the many-to-one relationship (in my case Paragraphs to Translation), you need to edit the .edmx model file and remove StoreGeneratedPattern="Identity" from the Paragraphs node.

See more here: http://stackoverflow.com/questions/2243618/how-do-you-insert-or-update-many-to-many-tables-in-net-entity-framework/2339834#2339834

LINQ to Entities - Common queries (.Net 4.0)

Anders Vindberg — Sat, 13 Mar 2010 09:08:00 GMT

T-Sql "WHERE IN":

Sql:

SELECT * FROM People
WHERE Firstname IN ('Peter', 'Steve', 'John', 'Bruno')

LINQ:

var names = new string[] { "Peter", "Steve", "John", "Bruno" };

var matches = from person in people
where names.Contains(person.Firstname)
select person;

Encrypting connectionstrings.config in IIS 6.0

Anders Vindberg — Tue, 09 Feb 2010 10:09:00 GMT

Simply call these two commands in cmd prompt:

C:\WINDOWS\microsoft.net\Framework64\v2.0.50727\aspnet_regiis.exe -pef "connectionStrings" C:\MyWebsiteFolder
C:\WINDOWS\microsoft.net\Framework64\v2.0.50727\aspnet_regiis -pa "NetFrameworkConfigurationKey" "Network Service"

If you still get a: "Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: The RSA key container could not be opened." Then call the second command again but replace "Network Service" with "ASPNET".

Source: MS Patterns & Practices: http://msdn.microsoft.com/en-us/library/ms998283.aspx

T-SQL Dynamic Sorting and Order By

Anders Vindberg — Wed, 15 Jul 2009 09:14:00 GMT

Using the CASE expression its possible to do efficient sorting and ordering by different parameters in one query. Here is an example from Greg Beech's Tech Blog which also includes paging:

DECLARE @SortType TINYINT, @SortAscending BIT, @FirstRow INT, @MaxRows INT;
SELECT @SortType = 2, @SortAscending = 0, @FirstRow = 10, @MaxRows = 10;

WITH FoundCustomers AS
(
    SELECT
        ROW_NUMBER() OVER
        (
            ORDER BY 
                CASE WHEN @SortType = 0 AND @SortAscending = 1 THEN c.ContactName END ASC
                ,CASE WHEN @SortType = 0 AND @SortAscending = 0 THEN c.ContactName END DESC
                ,CASE WHEN @SortType = 1 AND @SortAscending = 1 THEN c.CompanyName END ASC
                ,CASE WHEN @SortType = 1 AND @SortAscending = 0 THEN c.CompanyName END DESC
                ,CASE WHEN @SortType = 2 AND @SortAscending = 1 THEN c.Country END ASC
                ,CASE WHEN @SortType = 2 AND @SortAscending = 0 THEN c.Country END DESC
        ) AS RowNumber
        ,c.*
    FROM
        dbo.Customers c
)
SELECT
    fc.*
FROM
    FoundCustomers fc
WHERE
    fc.RowNumber BETWEEN @FirstRow AND @FirstRow + @MaxRows - 1
ORDER BY
    fc.RowNumber;

CSControl:ConditionalContent - a thing to remember!

Anders Vindberg — Fri, 08 May 2009 16:24:00 GMT

When using the ConditionalContent control from CommunityServer, always remember to use the <ContentConditions> tag when detailing the condition. Hmm that sounds obvious. No, its not. The control also has the DisplayCondition tag which is what we commonly use for other controls! Here is an example of correct usage:

<CSControl:ConditionalContent runat="server">
  
<ContentConditions><CSControl:QueryStringPropertyValueComparison
QueryStringProperty="condition" Operator="EqualTo"
ComparisonValue="true" runat="server" /></ContentConditions>
   <TrueContentTemplate>It's true!</TrueContentTemplate>
   <FalseContentTemplate>It's false!</FalseContentTemplate>
</CSControl:ConditionalContent>

Ahh that was good.

301 Redirect

Anders Vindberg — Tue, 03 Mar 2009 13:50:00 GMT

I always forget this particular code and spend time finding it again and again: This is for redirecting call to the root domain in Community Server to the /forums/ folder. I usually create a blank aspx page that does the redirect - otherwise the page will load (which may be several 20-30 kb before directing). In SiteUrls_override.config you can set the "home" location name to the redirect file.

<%@ Page %>
<%@ Import Namespace="System.Web" %>

<script language="C#" runat="server">

    protected override void OnInit(EventArgs e)
    {
        System.Web.HttpContext context = System.Web.HttpContext.Current;

        context.Response.Status = "301 Moved Permanently";
        context.Response.AddHeader("Location", "/forums/");

    }
</script>

OpenSocial API for CSharp

Anders Vindberg — Fri, 27 Feb 2009 14:21:00 GMT

Im currently looking for an OpenSocial API for the dotnet (.net) platform preferably written in csharp (C#). There are already APIs for PHP, Ruby, and other open source frameworks - where is the .net version?

It seems that the OpenSocial movement is less active in the proprietary world which for our sake (im part of it) is unfortunate. I believe the advent of OpenSocial will heavily be reflected in the future of the web.

Enable/Disable "Question & Answers"

Anders Vindberg — Thu, 19 Feb 2009 12:15:00 GMT

In CS 2008.5 its possible to post a forum topic that is a "Question" or a "Discussion". In order to enable this you need to check two places in the Controlpanel.

In Forum Administration - Configuration - Global Forum Settings

Set "Enable Thread Status Tracking" to Yes

In Forums and Groups - Forums

Select to "Edit" the particular forum - in "Allowed Thread Types" check "Questions and Answers".

And you are done!

CustomCondition in Community Server

Anders Vindberg — Thu, 19 Feb 2009 09:40:00 GMT

Often I find situations where I need to do a customized condition comparision. To enable this, Telligent have added the following chameleon control:

<CSControl:CustomCondition runat="server" CustomResult='<%# ((CommunityServer.Discussions.Components.Forum) ForumControlUtility.Instance().GetCurrentForum(Container)).SectionID == ForumControlUtility.Instance().GetCurrentThread(this.Page).SectionID %>'
            />

In this example I check the sectionId of the current forum (eg. in a dropdown list populated with all the forums) and the forum in which the thread im viewing is in.

Website Performance Optimization

Anders Vindberg — Thu, 29 Jan 2009 13:15:00 GMT

Today I implemented some of the best practice guidelines for speeding up websites. It has resulted in significant improved load times on the subtitle website Subscene. Although all "rules" as specified by Yahoo has not been implemented yet it has already decreased load times to the half. For future developments all guidelines will be followed, first implemented in the new translator markedplace Lingbay.

Scott Hanselman has a post about enabling proxy caching in IIS.

Lingbay - A Marketplace for Linguistic Jobs

Anders Vindberg — Wed, 21 Jan 2009 13:28:00 GMT

The new marketplace for linguistic jobs (Lingbay) is nearing completion. Expected launch is around April this year. If you want to be notified when we go live sign-up today!

About Lingbay:

Lingbay is an auction-house for linguistic related jobs, including translations, proofreadings, and transcriptions. As a freelance translator you bid on linguistic jobs and are paid the agreed amount after completion. As an outsourcer or employer you receive competitive quotes on jobs directly from the translator.

For a successful launch the procedure is as follows:

Collect a email-list of interested parties (active)
Gather a registered list of translators, linguistic professionals, and students
Launch a working beta version with active linguistic jobs

In addition to the listed procedure, a large ad-campaign will run as Lingbay is launched. A website like Lingbay requires a critical mass the be meet in order for the marketplace to function. First, a group of freelance translators needs to be ready to complete linguistic jobs within a certain period. Secondly, a continous flow of new jobs are needed to keep the marketplace active. The strategy employed is designed to fulfill that purpose.

How to Add Extended Properties

Anders Vindberg — Mon, 19 Jan 2009 15:48:00 GMT

In Community Server its easy to add extended properties to the user profile without having to write any code:

To your CommunityServer.config file, add

<ExtendedUserData>
  <add name="EXTENDED ATTRIBUTE NAME" />
</ExtendedUserData>

Then on your theme pages:

User Register (/themes/YOURTHEME/user/createuser.aspx)
Edit Profile (/themes/YOURTHEME/user/edituser.aspx)
Edit User page in Membership Administration in Control Panel (/ControlPanel/Membership/UserEdit.aspx)

add the following input field:

<asp:TextBox id="EXTENDED ATTRIBUTE NAME" runat="server" />

That's it!

Retrieve Extendedproperties Via SQL

Anders Vindberg — Mon, 19 Jan 2009 15:37:00 GMT

In Community Server, dynamic user fields are saved in extended properties. In order to retrieve them in Sql add the following function:

/*------------------------------------------------------------------------------
// <copyright company="Telligent Systems">
//     Copyright (c) Telligent Systems Corporation.  All rights reserved.
// </copyright> 
------------------------------------------------------------------------------*/

CREATE  function [dbo].[FetchExtendendAttributeValue] (
	@Key nvarchar(4000), 
	@Keys nvarchar(4000), 
	@Values nvarchar(4000)
)

/*
CS uses ExtendedAttributes to allow metadata about a post, user, or section to be stored
in a special ':' delimited format. This enables storing metadata without adding new columns
to any tables, changing sprocs, etc. 

However, any data stored in this format is not easily queryable (so use it wisely :)

Occassionaly, you may want to query against this data. This function should make that task simple!

Keys are stored in this format: string:S:Int:Int = Key + :S : Starting Location : Length : 

An example: 'Theme:S:0:7:dummyTotalPosts:S:7:1:BannedUntil:S:8:21:UserBanReason:S:29:5:'

Values are stored in a single string with no spaces between them.
An example: 'default04/20/2005 12:16:41 AMOther'

Theme starts a 0 and continues for 7 characters (default)
dummyTotalPosts starts at 7 and coninutes for 1 character (0)
BannedUntil starts at 8 and continues for 21 characters (4/20/2005 12:16:41 AM)
*/

RETURNS nvarchar(4000)
AS
BEGIN
DECLARE @Value nvarchar(4000)
Declare @CharIndex int
Declare @StartIndex int
Declare @Len int

--Find the index of the key
Set @CharIndex = CHARINDEX(@Key + ':s',@Keys)

--If the key does not exist, return NULL
if(@CharIndex = 0)
RETURN NULL

--If the key is not the first, remove any leading keys
if(@CharIndex > 1)
Begin
  Set @Keys = Stuff(@Keys,1,@CharIndex-1,'')
End

--Remove the Key from the keys list. This will 
Set @Keys = Stuff(@Keys,1,Len(@Key+':S:'),'')

--Find the location of the : after the starting location
Set @CharIndex = CHARINDEX(':',@Keys)

--Grab the starting location
Set @StartIndex = SUBSTRING(@Keys,1,@CharIndex-1)

--Remove the starting location from the Keys
Set @Keys = Stuff(@Keys,1,@CharIndex,'')

--Find the lenght value's index
Set @CharIndex = CHARINDEX(':',@Keys)

--Find the lenghth value
Set @Len = SUBSTRING(@Keys,1,@CharIndex-1)

--Get the value from the values string
Set @Value = SUBSTRING(@Values,@StartIndex+1,@Len)


RETURN @Value
END

Source: http://code.communityserver.org...

Community Server DefaultButton

Anders Vindberg — Fri, 16 Jan 2009 15:08:00 GMT

Today I was reminded of a wonderful CSControl that will allow a textbox to initiate a submit button (when pressing enter). Using the:

<CSControl:DefaultButtonTextBox ID="..." ButtonId="SubscriptionEmailButton" runat="server" />

you define the buttonId of the submit button.