I'm currently using the club starter kit, and I'm having trouble sending an email to the members. Whenever I try to send an email I get the error message below. It appears to be trying to pull data from the Member_Info table and bombing when it tries to actually pulls the data. This is kinda mind boggling, because the table is populated, so I'm not sure why it's bombing. Please Advise Server Error in '/' Application. There is no row at position 0. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IndexOutOfRangeException: There is no row at position 0. Source Error: Line 416: Public Default ReadOnly Property Item(ByVal index As Integer) As MemberInfoRow Line 417: Get Line 418: Return CType(Me.Rows(index),MemberInfoRow) Line 419: End Get Line 420: End Property Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\38643b38\a134ec97\App_Code.q6y-0ej9.1.vb Line: 418 Stack Trace: [IndexOutOfRangeException: There is no row at position 0.] System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) +1943315 System.Data.RBTree`1.get_Item(Int32 index) +17 System.Data.DataRowCollection.get_Item(Int32 index) +11 MemberInfoDataTable.get_Item(Int32 index) in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\38643b38\a134ec97\App_Code.q6y-0ej9.1.vb:418 Admin_Email.GetRecipients() in E:\web\greatermtol\htdocs\admin\Email.aspx.vb:170 Admin_Email.btnSend_Click(Object sender, EventArgs e) in E:\web\greatermtol\htdocs\admin\Email.aspx.vb:50 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746 Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
Hi, I found two posts out there related to this: http://www.codeplex.com/ClubStarterKit/Thread/View.aspx?ThreadId=11729 http://forums.asp.net/p/1138790/1826363.aspx#1826363
I looked at the sites but they are irrelevant...what else do you have? 1.) This is not on the same topic - http://www.codeplex.com/ClubStarterKit/Thread/View.aspx?ThreadId=11729 2.) This form doesn't have a conclusion on how to fix the issue - http://forums.asp.net/p/1138790/1826363.aspx#1826363
The way one of us would do it would be to compare the objects with a known good installation. This is typically done after testing locally, then using SQL Server to compare the local and remote objects. At that point there are many discoveries that can be made, i.e. DB object user access. As noticed in one of the links above the wrong user account was used and objects were failing. Are any of your friends SQL Server savvy? It may require getting help at this point. Salute, Mark
Hi, The easiest method, for most of us I guess, would be to use SQL Server Managment Studio. We would open the remote DB and compare objects/tables. You can also generate scripts from the Task wizards. There are professional tools which can compare DBs but I don't have any of them. Salute, Mark
Most of my friends can barley turn on a computer, so to answer question...No, there is no one help me here. Do you have any sample code/ script that I can use to perform this compare? And how exactly do I perform a compare?
