Blog archive not working after upgrade

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.
1/14/2010 4:02:58 AM
niccoswe
Gravatar
Total Posts 9
View Posts

Blog archive not working after upgrade

IIS 6.0

MSSQL

Using Mojoportal 2.3.3.4

I just updraded from Mojoportal 2.3.2.9 and everything seem to be working ok except the blog archive. When i click on a month i det the following error:

 

[SqlException (0x80131904): Procedure or function 'mp_Blog_SelectByMonth' expects parameter '@CurrentDate', which was not supplied.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1948826
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +70
mojoPortal.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) +344
mojoPortal.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +123
mojoPortal.Data.SqlParameterHelper.ExecuteReader() +19
mojoPortal.Data.DBBlog.GetBlogEntriesByMonth(Int32 month, Int32 year, Int32 moduleId, DateTime currentTime) +317
mojoPortal.Business.Blog.GetBlogEntriesByMonth(Int32 month, Int32 year, Int32 moduleId) +47
mojoPortal.Web.BlogUI.ArchiveViewControl.Page_Load(Object sender, EventArgs e) +797
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

 Any idea of what i can do to correct this is appreciated!

/Niklas 


 

1/14/2010 4:05:58 AM
niccoswe
Gravatar
Total Posts 9
View Posts

Blog archive not working after upgrade

If anyone know what to do to correct this, i´d appreciate it.

/Niklas

1/14/2010 5:59:26 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Blog archive not working after upgrade

Hi Niklas,

This does appear to be a bug. We are passing in the correct number of parameters but one of them is not named correctly. I'm not sure why it causes an error for you though, on my system SQL doesn't really care if the param name is correct as long as the number of params and the data types are correct. What version of MS SQL are you using?

I will correct this and try to get a patched release out soon.

Best,

Joe

1/15/2010 2:33:36 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Blog archive not working after upgrade

Hi,

I've just uploaded mojoPortal 2.3.3.4.B on our Novell Forge download page. It has the fix for this issue and some other fixes.

Best,

Joe

1/21/2010 1:27:54 AM
niccoswe
Gravatar
Total Posts 9
View Posts

Re: Blog archive not working after upgrade

Sorry for not replying earlier, but i have been buissy. Great work, I must say that you work very fast.

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