12 years ago

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?

12 years ago

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,