MagisterXero
2012-01-27T20:34:17Z
Hi,

I'm trying to set up a localized version of YAF on my PC and I'm getting this error that keeps occurring when the Database is being set up.

As far as I know, I have everything set up correctly for permissions on the database, and the database installs smoothly up until the point of a certain stored procedure.

Here is the error below that I'm receiving:

Could not find stored procedure 'dbo.yaf_prov_getusernamebyemail'.

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: Could not find stored procedure 'dbo.yaf_prov_getusernamebyemail'.

Source Error:


Line 617: {
Line 618: // no transaction
Line 619: da.Fill(ds);
Line 620: }
Line 621:

Source File: C:\Web Projects\YAF-v1.9.5.5-RTW-SRC\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs Line: 619


The first logical thing to do is to check the database for the stored procedure in question, so I do. Stored proc is there, named exactly the same.

Is there something that I'm doing wrong? Or why isn't this install procedure finding that stored proc, even though it is clearly there?




Sponsor
daveburke
2012-01-27T23:10:51Z
MagisterXero,

The lines in MsSqlDbAccess.cs you displayed are pretty generic and used for serving up legacy DataSets. You need to look further down into the Stack Trace to get a better idea of what was depending on that stored proc, I'd think.

Good luck,
Dave

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

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved