YAFLogo

AndyLL
  • AndyLL
  • 59% (Neutral)
  • YAF Forumling Topic Starter
15 years ago
Running 1.93 Final.

I converted over my roles from my current forums. I did not have any of the roles set as the starting group. When I registered a user they had no groups. I went to delete that user and this is what I got:

Invalid object name 'dbo.yaf_IgnoredUser'. 
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.Data.SqlClient.SqlException: Invalid object name 'dbo.yaf_IgnoredUser'.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[SqlException (0x80131904): Invalid object name 'dbo.yaf_IgnoredUser'.]
   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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
   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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   YAF.Classes.Data.DBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction) +144
   YAF.Classes.Data.DB.user_delete(Object userID) +97
   YAF.Classes.Utils.UserMembershipHelper.DeleteUser(Int32 userID) +59
   YAF.Pages.Admin.users.UserList_ItemCommand(Object source, RepeaterCommandEventArgs e) +790
   System.Web.UI.WebControls.Repeater.OnItemCommand(RepeaterCommandEventArgs e) +108
   System.Web.UI.WebControls.Repeater.OnBubbleEvent(Object sender, EventArgs e) +68
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.RepeaterItem.OnBubbleEvent(Object source, EventArgs e) +123
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118
   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

 
Sponsor

continienzo
15 years ago
Hi, already segnaled here from me, with the solution!
:wink:
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
15 years ago
Bug... Fixed. Will re-release here today.

EDIT: Re-released.
gedavies
  • gedavies
  • 57.2% (Neutral)
  • YAF Forumling
14 years ago
Hi, I know this is probably the stupidest question you've ever had. But here goes anyway...

I have the same problem, in this post you have said that their is a fix for this bug, and that it will be re-leased here today. All I'd like to know is re-released where? As I have no idea where to get the fix from.
imukai
  • imukai
  • 100% (Exalted)
  • YAF Commander
14 years ago
Well, "today" was April 25, and he's likely referring to the 1.9.3 "final" release available for download.

If you download the latest and install from that, you shouldn't have the problem.
gedavies
  • gedavies
  • 57.2% (Neutral)
  • YAF Forumling
14 years ago
Hello, I installed from the 1.9.3 FINAL as a brand new clean install, as we have not used YAF before. But I am still receiving the error when trying to delete users from the admin.
gedavies
  • gedavies
  • 57.2% (Neutral)
  • YAF Forumling
14 years ago
Here is the error I am receiving

Quote:

Server Error in '/' Application.



Invalid object name 'dbo.yaf_IgnoredUser'.
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.Data.SqlClient.SqlException: Invalid object name 'dbo.yaf_IgnoredUser'.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:







Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[SqlException (0x80131904): Invalid object name 'dbo.yaf_IgnoredUser'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +149
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
YAF.Classes.Data.DBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction) +147
YAF.Classes.Data.DB.user_delete(Object userID) +280
YAF.Classes.Utils.UserMembershipHelper.DeleteUser(Int32 userID) +56
YAF.Pages.Admin.users.UserList_ItemCommand(Object source, RepeaterCommandEventArgs e) +817
System.Web.UI.WebControls.Repeater.OnItemCommand(RepeaterCommandEventArgs e) +105
System.Web.UI.WebControls.Repeater.OnBubbleEvent(Object sender, EventArgs e) +66
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.RepeaterItem.OnBubbleEvent(Object source, EventArgs e) +117
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +132
System.Web.UI.WebControls.LinkButton.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) +177
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

gedavies
  • gedavies
  • 57.2% (Neutral)
  • YAF Forumling
14 years ago
Has anybody got any suggestions? Not being able to delete users is a big problem for the company I work for.
imukai
  • imukai
  • 100% (Exalted)
  • YAF Commander
14 years ago
I don't know if it will help but can you enable debugging and post the full error page?

Add the compilation debug=true to the web.config as shown in the bit you pasted.

Offhand I'm not sure why you'd get that error when deleting a user - I'm using 1.9.3 and can create/delete users at my whim.
imukai
  • imukai
  • 100% (Exalted)
  • YAF Commander
14 years ago
Tho I see the problem (I think)..

The table name is yaf_IgnoreUser

The error references yaf_IgnoredUser

note the extra D.
imukai
  • imukai
  • 100% (Exalted)
  • YAF Commander
14 years ago
Looking through existing code, seems the problem would lie within one of the stored procs.

I looked through the .sql scripts for 1.9.3 and do not see any misspellings of Ignore versus Ignored when referencing the tables, so I'm wondering if you modified the database after installation?

To help you track it down, load up SQL Studio and run this against your YAF database:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%yaf_IgnoredUser%' 
    AND ROUTINE_TYPE='PROCEDURE'

It will bring up all stored procs that might reference that table. From that list, open them up individually and take a look around - you're looking for references to the table itself that might have been misspelled accidentally.

If you see any that reference the table as Ignored, fix them to Ignore instead of Ignored and you should be good.
gedavies
  • gedavies
  • 57.2% (Neutral)
  • YAF Forumling
14 years ago
Thanks Imukai! I did make the changes you suggested and I am now able to delete users. So thanks again, everything seems to be working fine now...
imukai
  • imukai
  • 100% (Exalted)
  • YAF Commander
14 years ago
Any idea how the misspelling snuck its way into your DB procs?
gedavies
  • gedavies
  • 57.2% (Neutral)
  • YAF Forumling
14 years ago
I installed from the newest 1.9.3 FINAL version. But I did run a script from another post in this forum that fixed an issue where I was unable to add a new board, but I wouldn't have thought this would have made the changes :roll:
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button