IndexOutOfRangeException: FeedName

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.

8/24/2009 9:03:11 PM

mknauer

Total Posts 29

View Posts

IndexOutOfRangeException: FeedName

Joe,

I was doing some more testing and added a feed manager to a site. I had some feeds working about a week ago but since deleted them in testing. Now I'm starting fresh and I'm getting this error no matter what feeds I try to add to the feature:

[IndexOutOfRangeException: FeedName]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +4839010
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +67
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +15
   mojoPortal.Business.RssFeed.GetEntries(Guid moduleGuid) +472
   mojoPortal.Web.FeedUI.FeedCache.GetRssFeedEntries(Int32 moduleId, Guid moduleGuid, Int32 entryCacheTimeout, Int32 maxDaysOld, Int32 maxEntriesPerFeed, Boolean enableSelectivePublishing) +315
   mojoPortal.Web.FeedUI.FeedManagerModule.GetEntriesTable() +88
   mojoPortal.Web.FeedUI.FeedManagerModule.BindRepeater() +29
   mojoPortal.Web.FeedUI.FeedManagerModule.Page_Load(Object sender, EventArgs e) +75
   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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

OS - Windows
DB - MSSQL 2000
MojoPortal - 2.3.1.5 MSSQL

I tried deleting all entries manually from tables: mp_RSSFeedEntries and mp_RSSFeeds and re-added a feed and the error still shows up.

Any ideas?

Thanks,
Mike

8/25/2009 5:56:12 AM

Joe Audette

Total Posts 18439

View Posts

Re: IndexOutOfRangeException: FeedName

Hi,

There is an upgrade script for the feed manager it should have run when you visited the setup page.

Does the file exist?

/Setup/applications/feed-manager/SchemaUpgradeScripts/0.0.0.6

If all else fails run this from query analyzer:

ALTER PROCEDURE [dbo].[mp_RssFeedEntries_SelectByModule]

Author: Joe Audette

Created: 2008-10-01

Last Modified: 2009-08-04

@ModuleGuid uniqueidentifier

SELECT f.Author As FeedName,

e.*

FROM

[dbo].[mp_RssFeedEntries] e

JOIN [dbo].[mp_RssFeeds] f

ON e.FeedId = f.ItemID

WHERE

e.[ModuleGuid] = @ModuleGuid

ORDER BY e.[PubDate] DESC

btw, please use the paste as text toolbar when pasting errors or code. Previously this was forced in FCKeditor, now I need to see how to do it in TinyMCE.

Best,

Joe

8/25/2009 7:06:09 PM

mknauer

Total Posts 29

View Posts

Re: IndexOutOfRangeException: FeedName

Joe,

For some reason the last version of the source code I downloaded did not have that script 0.0.0.6

I manually ran the proc update and everything works fine now.

Thanks,

Mike

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