I have problem With one of my sites when upgrading to the latest Version and running setup. The Blog 2.6.0.1 is broken after the Upgrade from an earlier Version to the latest 2.4.0.3. Running MSSQL2012, Windows, .NET4(The same problem occured before I upgraded from 3.5 to 4.)

Anybody knows what this can be and how to fix it?

The site in problem: http://drodle.biz.anemone.arvixe.com

The error I have is this when running the script:

Configuring feature Bing Map - 00:00:02.0239980
Running script blog - 2.6.0.1 - 00:00:02.0720007
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, Int32 commandTimeout, SqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) ClientConnectionId:f4e07e48-baaf-4a57-8c8f-0080eb560369 Error Number:8152,State:13,Class:16 - 00:00:02.1809976
Configuring feature Blog - 00:00:02.1840005
Configuring feature Comments - 00:00:02.3959955

I have turned on the error Messages in browser:

SubTitle Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: SubTitle

Source Error:
 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:
 

[IndexOutOfRangeException: SubTitle] System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +5318078 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +61 System.Data.SqlClient.SqlDataReader.get_Item(String name) +15 mojoPortal.Business.Blog.GetPageDataSet(Int32 moduleId, DateTime beginDate, Int32 pageNumber, Int32 pageSize, Int32& totalPages) +463 mojoPortal.Web.BlogUI.PostList.BindBlogs() +910 mojoPortal.Web.BlogUI.PostList.Page_Load(Object sender, EventArgs e) +91 System.Web.UI.Control.OnLoad(EventArgs e) +92 System.Web.UI.Control.LoadRecursive() +54 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Control.LoadRecursive() +145 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34209

That did the trick. Thank you.

I also upgraded another site without any problems, but that site was updated earlier so it was closer to the current Version. On that Upgrade I did not have any problems.

Thank you again for fast respons. I will buy you a beer :-)

Regards, Svein-Martin Holt