Forums » Community Server Archive (read only) » Bugs & Issues » SpamScore related error when clicking Email Alerts on CS 2.1 Beta 1

SpamScore related error when clicking Email Alerts on CS 2.1 Beta 1

rated by 0 users
This post has 3 Replies | 3 Followers

Top 75 Contributor
Male
Posts 276
Points 4,210
Reply
SuperJMN Posted: Mon, Jul 17 2006 3:36 AM
Hello! I think I've found a bug in CS 2.1 Beta 1.

When I click Email alerts (the right common side bar) to subscribe to e-mail notifications for that blog, it appears an error page telling me this (I've translated the title since my server uses the Spanish language). It only happens on BLOG not galleries.

Server error on the application '/'.

SpamScore


Stack trace: 

[IndexOutOfRangeException: SpamScore]
     System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +1358391
     System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +102
     System.Data.SqlClient.SqlDataReader.get_Item(String name) +12
     CommunityServer.Blogs.Components.WeblogDataProvider.PopulateWeblogEntryFromIDataReader(IDataReader reader, Boolean isTopLevel) +1482
     CommunityServer.Blogs.Components.WeblogDataProvider.PopulateWeblogEntryFromIDataReader(IDataReader reader) +6
     CommunityServer.Data.WeblogSqlDataProvider.GetThreadsTrackedByUser(Int32 SectionID, Int32 UserID) +322
     CommunityServer.Blogs.Controls.EmailSubscriptionList.DataBind() +85
     CommunityServer.Blogs.Controls.EmailSubscriptionList.OnLoad(EventArgs e) +39
     System.Web.UI.Control.LoadRecursive() +47
     System.Web.UI.Control.AddedControl(Control control, Int32 index) +2065589
     System.Web.UI.ControlCollection.Add(Control child) +146
     System.Web.UI.Control.AddParsedSubObject(Object obj) +38
     System.Web.UI.Control.System.Web.UI.IParserAccessor.AddParsedSubObject(Object obj) +7
     ASP.themes_blogs_default_views_view_emailsubscriptions_ascx.__BuildControl__control3(Control __ctrl) +98
     System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container) +12
     CommunityServer.Controls.LayoutTemplate.AttachChildControls() +93
     CommunityServer.Controls.TemplatedWebControl.CreateChildControls() +90
     System.Web.UI.Control.EnsureChildControls() +87
     System.Web.UI.Control.PreRenderRecursiveInternal() +41
     System.Web.UI.Control.PreRenderRecursiveInternal() +161
     System.Web.UI.Control.PreRenderRecursiveInternal() +161
     System.Web.UI.Control.PreRenderRecursiveInternal() +161
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

José Manuel Nieto
Translator of the Spanish Language Pack for Community Server 2008
Developer of CS Writer

Top 25 Contributor
Posts 2,243
Points 44,790
CS Developers
Reply
Scott Watermasysk replied on Mon, Jul 17 2006 8:00 AM

I opened a bug for this and we will look into it.

-Scott

Follow Me On Twitter Simpable

  • | Post Points: 20
Top 10 Contributor
Posts 5,284
Points 49,035
CS Developers
Reply
Ken Robertson replied on Tue, Jul 18 2006 12:15 AM
Fixed this.  To fix it on your own site, you can just edit the cs_weblog_TrackedThreadsByUser sproc and after "HasRead = 0", change it to "HasRead = 0, P.PostStatus,P.SpamScore".
  • | Post Points: 20
Top 75 Contributor
Male
Posts 276
Points 4,210
Reply
SuperJMN replied on Tue, Jul 18 2006 10:58 AM
Done and working! Totally fixed.

I've made the change using the SQL Server Management Studio Express. I went to the Programmabily/Stored Procedures and searched the table:
dbo.cs_weblog_TrackedThreadsByUser. Context menu, modify went to the code, looked for HasRead and added the required code. Then I executed the query and it said done.

Now it is solved. I hope the other people having this error could solve it too using these instructions.

Thanks!

José Manuel Nieto
Translator of the Spanish Language Pack for Community Server 2008
Developer of CS Writer

  • | Post Points: 5
Page 1 of 1 (4 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com