Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: wiz - Tuesday, 13 October 2020 14:39:29
Hello, We have been using Yaf.net for a long time but now I'm having following problem: Today I upgraded the forum from version 2.2.xx to the latest version using this documentation: https://github.com/YAFNET/YAFNET/wiki/Upgrade-(from-Version-1.9.5.5-or-above) Everything went smooth and the Upgrade Wizard says the upgrade was finished successfully. When I go to our forum it seems to work fine indeed: https://xhammerforum.azurewebsites.net/ However when I try to login (or try to retrieve a forgotten password) I get following exception: [color=red][b]"Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'."[/b][/color] I'm assuming this has to do with membership/role providers but honestly I'm lost. How do I fix this ? Our forum is hosted on Azure. Many thanks in advance !

Posted by: wiz - Tuesday, 13 October 2020 14:39:29

Hello, We have been using Yaf.net for a long time but now I'm having following problem: Today I upgraded the forum from version 2.2.xx to the latest version using this documentation: https://github.com/YAFNET/YAFNET/wiki/Upgrade-(from-Version-1.9.5.5-or-above) Everything went smooth and the Upgrade Wizard says the upgrade was finished successfully. When I go to our forum it seems to work fine indeed: https://xhammerforum.azurewebsites.net/ However when I try to login (or try to retrieve a forgotten password) I get following exception: [color=red][b]"Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'."[/b][/color] I'm assuming this has to do with membership/role providers but honestly I'm lost. How do I fix this ? Our forum is hosted on Azure. Many thanks in advance !

Posted by: tha_watcha - Wednesday, 14 October 2020 13:08:01
You might need to run the install of the stored procedure manually... [code=sql]IF (NOT EXISTS (SELECT name FROM sys.objects WHERE (name = N'aspnet_CheckSchemaVersion') AND (type = 'P'))) EXEC('CREATE PROCEDURE [dbo].aspnet_CheckSchemaVersion AS RAISERROR(''Empty aspnet_CheckSchemaVersion Procedure!!'', 16, 1) WITH SETERROR') GO ALTER PROCEDURE [dbo].aspnet_CheckSchemaVersion @Feature nvarchar(128), @CompatibleSchemaVersion nvarchar(128) AS BEGIN IF (EXISTS( SELECT * FROM dbo.aspnet_SchemaVersions WHERE Feature = LOWER( @Feature ) AND CompatibleSchemaVersion = @CompatibleSchemaVersion )) RETURN 0 RETURN 1 END GO[/code]

Posted by: tha_watcha - Wednesday, 14 October 2020 13:08:01

You might need to run the install of the stored procedure manually... [code=sql]IF (NOT EXISTS (SELECT name FROM sys.objects WHERE (name = N'aspnet_CheckSchemaVersion') AND (type = 'P'))) EXEC('CREATE PROCEDURE [dbo].aspnet_CheckSchemaVersion AS RAISERROR(''Empty aspnet_CheckSchemaVersion Procedure!!'', 16, 1) WITH SETERROR') GO ALTER PROCEDURE [dbo].aspnet_CheckSchemaVersion @Feature nvarchar(128), @CompatibleSchemaVersion nvarchar(128) AS BEGIN IF (EXISTS( SELECT * FROM dbo.aspnet_SchemaVersions WHERE Feature = LOWER( @Feature ) AND CompatibleSchemaVersion = @CompatibleSchemaVersion )) RETURN 0 RETURN 1 END GO[/code]

Posted by: wiz - Wednesday, 14 October 2020 15:51:07
Thanks, I executed this and now it seems I'm getting another error when trying to log in: Uncaught Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: Invalid object name 'dbo.aspnet_SchemaVersions'. It seems none of the "dbo.aspnet_xxx" tables exist. They are needed for the membership provider I assume ? How can I generate them afterwards ? Our site & sql database are hosted on Azure.

Posted by: wiz - Wednesday, 14 October 2020 15:51:07

Thanks, I executed this and now it seems I'm getting another error when trying to log in: Uncaught Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: Invalid object name 'dbo.aspnet_SchemaVersions'. It seems none of the "dbo.aspnet_xxx" tables exist. They are needed for the membership provider I assume ? How can I generate them afterwards ? Our site & sql database are hosted on Azure.

Posted by: tha_watcha - Wednesday, 14 October 2020 17:49:57
[quote=wiz;72734]How can I generate them afterwards ?Our site & sql database are hosted on Azure.[/quote] I assume Yaf was not initially installed on azure? At the moment the Sql membership provider scripts are only installed on a new YAF installation. However i uploaded yaf 2.31.10 https://github.com/YAFNET/YAFNET/releases/tag/v2.3.1.10 You need to manually run the ugprade wizard. then the needed Scripts will be installed.

Posted by: tha_watcha - Wednesday, 14 October 2020 17:49:57

[quote=wiz;72734]How can I generate them afterwards ?Our site & sql database are hosted on Azure.[/quote] I assume Yaf was not initially installed on azure? At the moment the Sql membership provider scripts are only installed on a new YAF installation. However i uploaded yaf 2.31.10 https://github.com/YAFNET/YAFNET/releases/tag/v2.3.1.10 You need to manually run the ugprade wizard. then the needed Scripts will be installed.

Important Information: