August 27. 2008 02:44 AM

Reggie,

I kept getting to following error when attempting to use the 5.2.3 Membership and Role providers in my ASP.Net 2.0 app:
Unable to initialize provider. Missing or incorrect schema. (D:\Web\FinderNew\web.config line 52)

I had included autogenerateschema="true" on all of my providers, but it did not seem to want to generate the schema. Couldn't get it to work with the providers installed, or by including them in the Bin directory.

I ended up downloading the source code version and merging the 4 SQL files into one and creating the tables manually (through MySQL Browser). It works now.

Finally, may I recommend adding the MySql.Web dll and the composite SQL script to the binaries zip?

Sam

September 1. 2008 06:42 AM

Hey, Reggie,

I am having the same trouble that Sam reports. I am going to try his solution.

Thanks!

Marvin

September 6. 2008 01:50 AM

reggie , thanks for fixing the issue ,when we can expect version 5.2.4 out ?

Amre Ellafi

September 7. 2008 10:09 PM

Hi Reggie,

Am getting an "Exception: Profile update failed"

Using the ProfileProvider the stack trace is below

[quote]
[Exception: Profile update failed.]
MySql.Web.Profile.MySQLProfileProvider.SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection collection) +619

[ProviderException: Profile update failed.]
MySql.Web.Profile.MySQLProfileProvider.SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection collection) +731
System.Configuration.SettingsBase.SaveCore() +379
System.Configuration.SettingsBase.Save() +77
System.Web.Profile.ProfileBase.SaveWithAssert() +31
System.Web.Profile.ProfileBase.Save() +63
System.Web.Profile.ProfileModule.OnLeave(Object source, EventArgs eventArgs) +2397611
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
[\quote]

Below is the profile section of my web.config

[quote]
<sessionState mode="Off"/>
<anonymousIdentification enabled="true"
cookieName=".ASPXANONYMOUS"
cookiePath="/"
cookieRequireSSL="false"
cookieSlidingExpiration="true"
cookieProtection="All"
cookieless="UseCookies"/>
<profile defaultProvider="MySQLProfileProvider" enabled="true" >
<providers>
<clear/>
<add connectionStringName="FRCN"
name="MySQLProfileProvider"
type="MySql.Web.Profile.MySQLProfileProvider"
applicationName="/"/>
</providers>
<properties>
<add name="FullName" type="System.String" serializeAs="Xml" allowAnonymous="false" provider="MySQLProfileProvider"/>
</properties>
</profile>
[\quote]

Am actually trying to implement a shopping cart, at first I supected my shopping cart type, but after removing the type from the profile and left just only the FullName property am still getting the same error.

Darl

September 7. 2008 10:18 PM

public partial class ShoppingCart : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e )
{
if( !IsPostBack )
{
string itemId = Request.QueryString[ "addItem" ];
if( !string.IsNullOrEmpty( itemId ) )
{
//Product pro = Products.GetProduct( itemId );

//CartItem item = new CartItem( pro.ProductGUID, pro.ProductName, 1, pro.OurPrice );

//Dummy just to test error reoccuring
Profile.FullName = "Webmaster";

//Profile.ShoppingCart.Add( item );
//Profile.WishList.Add( item );

// Redirect to prevent duplictations in the cart if user hits "Refresh"
Response.Redirect( "~/ShoppingCart.aspx", true );
}
}
}

protected void Page_PreInit( object sender, EventArgs e )
{

}
}


Like i said in my prevoius post am doing a shopping cart, all the line commented is because I have removed the wishlist and shopping cart from the profile properties and just added the fullname property to be sure the error is not due to my cart and wishlist type.

Darl