mysql - 为什么我的网站在我的 Web.config 中崩溃？

Question

我遇到的错误...

Server Error in '/' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. 

Parser Error Message: Unable to initialize provider.  Missing or incorrect schema.

Source Error: 


Line 60:       <providers>
Line 61:         <remove name="MySQLMembershipProvider" />
Line 62:         <add name="MySQLMembershipProvider" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"
Line 63:              connectionStringName="InncZone_CS"
Line 64:              enablePasswordRetrieval="false"

Source File: C:\Users\Clayton\Coding\Innczone\web.config    Line: 62 

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34248

该网站在其他所有页面上都运行良好，但出现此错误的是注册页面。

我尝试加载的网站。

<%@ Page Title="Register" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Register.aspx.cs" Inherits="Register" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" Runat="Server">
    <br />
    <asp:CreateUserWizard ID="cuwNewUser" runat="server">
        <CreateUserButtonStyle CssClass="btn btn-info btn-lg" />
        <WizardSteps>
            <asp:CreateUserWizardStep ID="CreateUserWizardStep1" runat="server" Title="Enter your details">
            </asp:CreateUserWizardStep>
            <asp:CompleteWizardStep ID="CompleteWizardStep1" runat="server">
            </asp:CompleteWizardStep>
        </WizardSteps>
        <FinishCompleteButtonStyle CssClass="btn btn-info btn-lg" />
    </asp:CreateUserWizard>
</asp:Content>

我已经尝试了十几次寻找答案。请帮忙。

Web.config

<!--MySql.Web-->
  <membership defaultProvider="MySQLMembershipProvider" enabled="true" >
      <providers>
        <remove name="MySQLMembershipProvider" />
        <add name="MySQLMembershipProvider" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"
             connectionStringName="InncZone_CS"
             enablePasswordRetrieval="false"
             enablePasswordReset="true"
             requiresQuestionAndAnswer="false"
             applicationName="/"
             requiresUniqueEmail="true"
             passwordFormat="Clear"
             maxInvalidPasswordAttempts="3"
             minRequiredPasswordLength="7"
             minRequiredNonalphanumericCharacters="1"
             passwordAttemptWindow="3"             
             userTableName="web_user"
             userIdColumn="web_userid"
             userNameColumn="web_username"
             autoGenerateTables="True"
             autogenerateschema="true"/>
      </providers>
    </membership>

    <!--passwordStrengthRegularExpression=""-->

    <profile defaultProvider="MySQLProfileProvider" enabled="true" >
      <providers>
        <remove name="MySQLProfileProvider" />
        <add name="MySQLProfileProvider" type="MySql.Web.Profile.MySQLProfileProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="InncZone_CS" applicationName="/" />
      </providers>
      <properties>
        <add name="FirstName" />
        <add name="Surname" />
        <add name="Email" />
        <add name="DateOfBirth" type="System.DateTime" />
        <add name="ProfilePicture" type="System.Drawing.Image" />
      </properties>
    </profile>

    <roleManager defaultProvider="MySQLRoleProvider" enabled="true" >
      <providers>
        <remove name="MySQLRoleProvider" />
        <add name="MySQLRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="InncZone_CS" applicationName="/" />
      </providers>
    </roleManager>

    <siteMap defaultProvider="MySqlSiteMapProvider">
      <providers>
        <remove name="MySqlSiteMapProvider" />
        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="InncZone_CS" applicationName="/" />
      </providers>
    </siteMap>

    <webParts>
      <personalization defaultProvider="MySQLPersonalizationProvider">
        <providers>
          <remove name="MySQLPersonalizationProvider" />
          <add name="MySQLPersonalizationProvider" type="MySql.Web.Personalization.MySqlPersonalizationProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="InncZone_CS" applicationName="/" />
        </providers>
      </personalization>
    </webParts>

我安装了 MySql.Web 并使用包管理器安装了 MySql.Data。我遵循了 mysql 教程网站上的每条说明。

Answer 1

我认为问题出在您的提供商中的 type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.9.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" 部分配置键。它的模式结构不正确。

您应该只尝试使用 type="MySql.Web.Security.MySQLMembershipProvider" 而不是全部。