Forum threads no more sorted by descending datetime of their

Forum threads no more sorted by descending datetime of their last post

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.

4/13/2010 5:37:06 AM

Diego Mora

Total Posts 149

View Posts

mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Forum threads no more sorted by descending datetime of their last post

Server: IIS 7 + MS SQL Server 2008

Client: Windows 7 + IE8

mojoPortal version: 2.3.4.1, upgraded from 2.3.3.9

After upgrading to 2.3.4.1 I have noticed that threads in my forum are no more sorted on the basis of the descending datetime of their last post.

This prevents the most popular threads to float on top the list as they should.

I have noticed that on this site forum sort works correctly and so it does on another site of mine.

Does anyone have the same experience ?

May this be somehow related to the new sticky sort option and a problem in upgrading te database schema ? (By the way all posts were set by default to 100).

Any clues ?

Diego

4/13/2010 6:58:55 AM

Joe Audette

Total Posts 18439

View Posts

Re: Forum threads no more sorted by descending datetime of their last post

Hi Diego,

I would check your copy of the stored procedure mp_ForumThreads_SelectByForumDesc_v2 and make sure it has:

ORDER BY t.SortOrder, t.MostRecentPostDate DESC

Normal threads by default get a SortOrder of 100 so it should not affect the sort by post date descending unless the thread has been made sticky by using a lower sortorder.

Hope it helps,

Joe

4/13/2010 7:22:24 AM

Diego Mora

Total Posts 149

View Posts

mojoPortal Skinning, Custom Development and Support in Italy?
EffectiveWeb.it

Re: Forum threads no more sorted by descending datetime of their last post

Hi Joe,

I had a look on the stored procedure and it does have the correct ORDER BY statement.

I just wonder whether the page cut is anyhow involved, because in my forum, threads have recently exceeded the single page and page 2 contains more recents posts.

Have a look at this URL: http://santadele.effectiveweb.it/Forums/ForumView.aspx?pageid=5&mid=10&ItemID=1

Page 1 and 2 contain threads correctly sorted by descending post date but the sort criteria is applied within the page and not within all threads.

Does this mean anything to you ?

4/13/2010 10:43:51 AM

Joe Audette

Total Posts 18439

View Posts

Re: Forum threads no more sorted by descending datetime of their last post

Hi Diego,

I am able to produce this issue on my local machine using MS SQL. I will figure out a solution asap.

Best,

Joe

4/13/2010 1:31:54 PM

Joe Audette

Total Posts 18439

View Posts

Re: Forum threads no more sorted by descending datetime of their last post

I have patched this with a new script for the forum in the 2.3.4.2 release. This issue only affects MS SQL and SqlAzure, if you downloaded mojoPortal 2.3.4.2 previously and are experiencing this sort issue, you can just get the script at /Setup/Applications/forums/SchemaUpgradeScripts/mssql/0.0.1.4.config

Install this script and visit setup page again, it will correct the sort in the stored procedure.

Best,

Joe

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