Get exception trying to create a new blog after upgrading to

Get exception trying to create a new blog after upgrading to 2.3.9.4

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.

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

12/2/2012 4:01:37 PM

Finnur

Total Posts 34

View Posts

Get exception trying to create a new blog after upgrading to 2.3.9.4

Operating system: Windows Server 2012 at Arvixe and also my own test server Windows Server 2008 R2 Std.

Database MS SQL Server 2012 at Arvixe and also my own test server with MS SQL Server 2008 R2

mojoPortal: just upgraded to 2.3.9.4 from a version 1-2 years old (don't remember exactly which)

Creating a blog on a page I get this error. (Also accessing a previous blog on my older server produced errors.)

Could there be something missing in the upgrade script to 2.3.9.4, I did not notice any errors when I upgraded?

regards

- Finnur

Just got the Mobile control and the Artisteer plugin for v4 and both work great!

======================

2012-12-02 15:27:28,170 ERROR xxx.. - is-IS - /home.aspx - mojoPortal.Web.Global - Referrer(http://www.stellarbits.com/Admin/PageLayout.aspx?pageid=164) useragent Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
System.InvalidOperationException: The stored procedure 'mp_Blogs_SelectAttachmentsForPage' doesn't exist.
   at System.Data.SqlClient.SqlCommand.DeriveParameters()
   at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
   at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
   at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
   at mojoPortal.Data.SqlParameterHelper.InitializeArray()
   at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
   at mojoPortal.Data.DBBlog.GetAttachmentsForPage(Int32 moduleId, DateTime beginDate, DateTime currentTime, Int32 pageNumber, Int32 pageSize)
   at mojoPortal.Business.Blog.GetPageDataSet(Int32 moduleId, DateTime beginDate, Int32 pageNumber, Int32 pageSize, Int32& totalPages)
   at mojoPortal.Web.BlogUI.PostList.BindBlogs()
   at mojoPortal.Web.BlogUI.PostList.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
...

...

   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2012-12-02 15:32:36,490 INFO (null) - (null) - (null) - mojoPortal.Business.WebHelpers.IndexWriterTask - deserialized IndexWriterTask task
2012-12-02 15:32:36,490 INFO (null) - (null) - (null) - mojoPortal.Business.WebHelpers.IndexWriterTask - Queued IndexWriterTask on a new thread

12/2/2012 4:10:07 PM

Joe Audette

Total Posts 18439

View Posts

Re: Get exception trying to create a new blog after upgrading to 2.3.9.4

Hi Finnur,

Did you visit the /Setup/Default.aspx page?

When you go to Administration > System Information what version does it say?

Are you sure you uploaded all the files to the server?

I would also try recycle the app pool in case somehow the old sql parameter were still cached that should clear the cache.

Hope that helps,

Joe

12/2/2012 5:08:46 PM

Finnur

Total Posts 34

View Posts

Re: Get exception trying to create a new blog after upgrading to 2.3.9.4

Hello Joe,

I did go to the /Setup page (assuming it would go to the /Setup/Default.aspx page. At least I saw a long list of upgrade procedures perform.

In the Features page I get:

System Information

mojoPortal Version 2.3.9.4 MSSQL
Operating System Microsoft Windows NT 6.2.9200.0
ASP.NET Info v4.0.30319 Running in Full Trust
Server Time Zone Central Standard Time
Server Local Time (GMT -6) 2.12.2012 16:45:28
Greenwich Mean Time (GMT/UTC) 2.12.2012 22:45:28

Feature Versions [Help]

Feature Schema Version
blog 2.6.0.0
contactform 0.0.0.6
eventcalendar 0.0.0.6
feed-manager 0.0.1.0
forums 2.2.0.1
imagegallery 0.0.0.8
kdmediaplayer 1.0.0.1
linksmodule 0.0.0.9
pollfeature-byChristianFredh 0.0.0.5
sharedfiles 0.0.1.0
surveyfeature 1.8.0.0
webstore 0.0.7.3

Pretty sure I uploaded everything, I also did another fresh install where the blog feature worked fine.

And then I looked at the features page on another Arvixe install where the blog is working OK and I get:

System Information

mojoPortal Version 2.3.9.4 MSSQL

Operating System Microsoft Windows NT 6.2.9200.0

ASP.NET Info v4.0.30319 Running in Full Trust

Server Time Zone Central Standard Time

Server Local Time (GMT -6) 2.12.2012 16:53:36

Greenwich Mean Time (GMT/UTC) 2.12.2012 22:53:36

Feature Versions

Feature Schema Version blog 2.6.0.7 contactform 0.0.0.6 eventcalendar 0.0.0.6 feed-manager 0.0.1.0 forums 2.2.0.1 imagegallery 0.0.0.8 kdmediaplayer 1.0.0.1 linksmodule 0.0.0.9 pollfeature-byChristianFredh 0.0.0.5 sharedfiles 0.0.1.0 surveyfeature 1.8.0.0 webstore 0.0.7.3

so it seems that only the blog feature has not been upgraded for some reason as it is in v. 2.6.0.0 but not in 2.6.0.7 as it should be.

OK, then I rerun the setup and read more closely what happens and I see:

Running script blog - 2.6.0.1 - 00:00:00.1875047
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) 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:48811829-cd76-4599-a230-37fc5ebf7826 - 00:00:00.2031299

Could there be some problem data in my blog that is preventing the first blog upgrade script from running? The old blog entries were not of any significance so I could throw them away. But I am not sure how I could delete something blog related from the database without doing more problems. There is some icelandic text in these entries that has not been any problem for mojoPortal so far.

regards

-Finnur

12/3/2012 9:49:48 AM

Joe Audette

Total Posts 18439

View Posts

Re: Get exception trying to create a new blog after upgrading to 2.3.9.4

There is one field that could be truncated by the migration. The Name field form the old Blog comments was nvarchar(100) but the one in the the new comment system is nvarchar(50). I did not realize this difference and did not expect names longer than 50 chars.

You could get past this error by editing the script /Setup/applications/blog/SchemaUpgradeScripts/mssql/2.6.0.1.config

Change

bc.[Name],

SUBSTRING(bc.[Name], 0, 50),

Hope that helps,

Joe

12/3/2012 12:30:31 PM

Finnur

Total Posts 34

View Posts

Re: Get exception trying to create a new blog after upgrading to 2.3.9.4

Thanks Joe,

Yes, the substring change did the trick, the website upgraded without errors and is running fine now.

regards

-Finnur

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