Any known errors with Blog module 2.6.0.1

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
7/10/2014 2:57:02 AM
Gravatar
Total Posts 18
regards, Svein-Martin Holt Norway

Any known errors with Blog module 2.6.0.1

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

7/10/2014 8:16:48 AM
Gravatar
Total Posts 18444

Re: Any known errors with Blog module 2.6.0.1

Hi,

Yes there is a known problem that happens sometimes with the 2.6.0.1 upgrade script of the blog. It is migrating comments fromt eh older blog comment system into the newer one but the newer one has only 50 chars allowed for the name and the old one had 100 so if there was data in the old one that is larger than 50 chars it throws this error.

If you edit the file at

/Setup/applications/blog/SchemaUpgradeScripts/mssql/2.6.0.1.config

look for the select statement after insert statement,

bc.[Name],

change to Substring(bc.[Name],0,50),

Then visit the setup page again so it can run that script as well as other newer ones.

I will add this same change into my copy of the script to prevent this in the future.

Hope that helps,

Joe

7/10/2014 8:40:59 AM
Gravatar
Total Posts 18
regards, Svein-Martin Holt Norway

Re: Any known errors with Blog module 2.6.0.1

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

7/10/2014 8:46:31 AM
Gravatar
Total Posts 18444

Re: Any known errors with Blog module 2.6.0.1

Glad to be of help. Many thanks for the beers and coffee!

Cheers,

Joe

You must sign in to post in the forums. This thread is closed to new posts.