MySQL Connector/Net 5.2.3, a new version of the all-managed .NET driver for MySQL has been released. This release is of GA quality and is suitable for use in production environments. We strongly urge you to review the change log that is shipped with the product for a thorough review of the changes.
Version 5.2.3 works with all versions of MySQL including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon "Preview".
It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/5.2.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)
Changes since 5.2.2
- Increased the speed of MySqlDataReader.GetOrdinal dramatically by using a couple of hashes for lookups
- Fixed problem where some tables that support the web providers used the latin1 character set instead of the database default. (bug #36444)
- Changed how the procedure schema collection is retrieved. If 'use procedure bodies=true' then we select on the mysql.proc table directly as this is up to 50x faster than our current IS implementation. If 'use procedure bodies=false', then the IS collection is queried. (bug #36694)
- Fixed problem with our GetOrdinal speedup where we would attempt to add an already existing key to a hash when a resultset had more than 1 column with the same name. (bug #37239)
- small fix to how we were allowing in/out and out parameters to slide through parameter serialization. Before we were setting the AllowUserVariables connection setting but that had the unfortunate side effect of setting the value for all connections that shared that connection string. This way we isolate it just to our particular command. This may fix bug #37104
- Fixed documentation surrounding use of ? vs @ for parameters (bug #37349)
- Reduced network traffic for the normal case where the web provider schema is up to date (bug #37469)
- Improved error reporting when a timeout occurs. It no longer uses a message like 'reading from stream failed'. (bug #38119)
- fixed problem where adding a non-existent user to a role would not auto-create the user record (bug #38243)
- moved string escaping routine from the MySqlString class to the MySqlHelper class and made it public and static. (bug #36205)
- Fixed problem where column metadata was not being read with the correct character set (bug #38721)
- Fixed problem where the uninstall was not cleaning up the state files (bug #38534)
- Added 'Functions Return String' connection string option
- Several other fixes merged in from 5.0 and 5.1
Reggie,
ReplyDeleteI 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?
Hey, Reggie,
ReplyDeleteI am having the same trouble that Sam reports. I am going to try his solution.
Thanks!
I've fixed this in 5.2.4
ReplyDeletereggie , thanks for fixing the issue ,when we can expect version 5.2.4 out ?
ReplyDeleteHi Reggie,
ReplyDeleteAm 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.
Great thing for this code Connector/Net 5.2.3 GA has been released.
ReplyDeleteGreat tips for fixing the Blogengine.NET realese. Many users are glad to see this
ReplyDeletereggie , thanks for fixing the issue ,when we can expect version coming out ?
ReplyDeleteHey reg. Great post and boy I just wanted to say that I wouldn't know what to do if mySql was never greated.
ReplyDeleteI initially had some MySQL problems when I tried to set up a way to <a href="www.cardaccept.com">accept online payments</a> from my website. Reading your blog helped answer a few of the questions I had and helped me get things sorted out. Thankfully everything is working properly now and I have a bit more knowledge concerning MySQL than I did previously.
ReplyDeleteThank you.
Great article on the codes. Good job. Keep up the great work.
ReplyDelete"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. "
ReplyDeleteGood call...this will help weed out problems and help with smoother procedure.
Thanks for this info.. and really cool codes... thanks
ReplyDeleteanother great news..
ReplyDeletewhat a great info. thanks!
ReplyDeleteThis is good stuff for noobs like me. There are still some parts I don't understand though.
ReplyDeleteI run a travel site so this new development will be useful and hopefully make the buying online insurance experience smoother for customers.
ReplyDeleteVery entertaining site. I've bookmarked your site and added you on my blogroll! Keep up the great work.
ReplyDeleteThis looks like a great upgrade. I've downloaded it to try it out.
ReplyDeleteNice post.
ReplyDeleteGreat article on the codes. Good job. Keep up the great work.
ReplyDeleteHey, Reggie,
ReplyDeleteI am having the same trouble that Sam reports. I am going to try his solution.
Thanks!
when we can expect version 5.2.4 out ?
ReplyDeleteThanks for that usefull post ! it permit me to fix my problem ! Thanks a lot Dude !
ReplyDeleteI put your website in my bookmark ! so helpfull !
Nice Read
ReplyDeleteRegards
bani
Great Work !
ReplyDeleteRegards
paul
Great article as always Raggie!
ReplyDeleteYour fellow reader Matty
Nice Read
ReplyDeleteRegards
Bete
Where can i have more info on this ?
ReplyDeleteRegards
Pari
Nice Read
ReplyDeleteRegards
free mp3
Thanks for such a nice post.
ReplyDeleteRegards
Iqoin
Can i have more info on this ?
ReplyDeleteRegards
Dramae
I got your blog from google.com i am doing a thesis on this niche can i have more info ?
ReplyDeleteRegards
Capton
Great Work !
ReplyDeleteRegards
Gouri
hii
ReplyDeletenice good post
Regards
rocky
Excellent tutorial about SQL
ReplyDeleteI kept getting to following error when attempting to use the 5.2.3 Membership and Role providers in my ASP.Net 2.0 app:
ReplyDeleteHey - nice blog, just looking around some blogengine.net sites, seems a pretty nice platform. I'm currently using Wordpress for a few of my sites but looking to change one of them over to blogengine.net as a trial run. Anything in particular you would recommend about it? Cheers, Matthew
ReplyDeleteIm very glad you made some updates, good job
ReplyDeleteWhere can i have more info on this ?
ReplyDeleteRegards
Harry
I needed this info thanks mate
ReplyDeleteRegards
Huio
Thanks for letting know, will check it out!
ReplyDeleteI bookmarked this already dude great work
ReplyDeleteRegards
K.P Sanu
i'm a very lucky find this blog, hopefully can learn more from this blog
ReplyDeleteGood post.I'm currently using Wordpress for a few of my sites but looking to change one of them over to blogengine.
ReplyDeleteI really feel happy to have this blog.This really put me in a good state.I had an awesome sharing.
ReplyDeleteThanks,
cant be nicer then u r
ReplyDeleteI donno what to do
ReplyDeletei can make it better
ReplyDeleteThis shows me the better way for it.
ReplyDeletegood!
ReplyDeletereview the change log that is shipped with the product for a thorough review of the changes.
ReplyDeleteI am gree with you!
ReplyDeleteGreat article on the codes. Good job. Keep up the great work.
ReplyDeleteGabs
I bookmarked this already dude great work
ReplyDeleteRegards
Anu
Hiiiiiiiiiiiii...........
ReplyDeletei'm a very lucky find this blog, hopefully can learn more from this blog
Thanks.
Thanks for letting know, will check it out!
ReplyDeleteThanks.
thank you for giving us a comment place.
ReplyDeletei support your idea.hope you everying goes well.
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.
ReplyDeleteI apppraciate your comment ,your idea is wonderful.
ReplyDeletewish you everything goes smoothly !
Thanks for the great widget! Going to add it to my installation next week.
ReplyDeleteI've also posted about it on the BlogEngine Forums
Thanks for the great widget! Going to add it to my installation next week.
ReplyDeleteI've also posted about it on the BlogEngine Forums
I want to have additional information using HTML, Java, CSS for my blog site. And finding what themes are applicable to my blog site and choosing what is the best version of blogengine for my blog site.
ReplyDeleteThanks for writing this truely cracking blog post, I enjoyed reading it
ReplyDeleteHello friends.
ReplyDeleteNice blog, just looking around some blogengine.net sites, seems a pretty nice platform.
I apppraciate your comment ,your idea is wonderful.
wish you everything goes smoothly !
Thanks.
James
http://www.hostwaffle.com/
It was a very nice idea! Just wanna say thank you for the information you have shared. Just continue writing this kind of post. I will be your loyal reader. Thanks again.
ReplyDeleteThanks for such a nice post.
ReplyDeletethanks for sharing
ReplyDeletei like it
it is very useful
thanks again
Thanks for writing this truely cracking blog post, I enjoyed reading it
ReplyDeletethanks for sharing
ReplyDeleteCool blog, just bookmarked it for later reference
ReplyDeleteHey I love your style I will subscribe for your feed please keep posting!
ReplyDeleteThats intresting, thanks for sharing. I'm sure others will see things the same way
ReplyDeleteCool post - thanks a lot m8!
ReplyDeleteThank you, for this code :) Cheers!
ReplyDeleteHello people, I have a skimpy problem... I u are running blogengine from ms. I'm using an anxiety and panic disorder blog on wordpress and i am willing to switch. Does it only run on microsoft server?? Thanks, Debra Trotter
ReplyDeleteThanks.. Funny, I actually had this on my mind a few days ago..
ReplyDeleteWell this is a nicely explained article on the new features and fixes incorporated with the new MySQL Connector/Net 5.2.3. Thanks for this essential information.
ReplyDeletegood day, you have a nice blog! I have a little something to add: when you suffer from an agoraphobia attack, you need to look for proven cures rather than looking for untested panic disorder agoraphobia treatment cures
ReplyDeletehello, you have a nice blog! I have a little something to add: when you suffer from an agoraphobia attack, you need to look for tried-and-tested treatments instead of looking for newly discovered panic disorder agoraphobia treatment cures
ReplyDeleteExtra Reading...
ReplyDelete[...]we like to honor other sites on the web, even if they aren't related to us, by linking to them. Below are some sites worth checking out[...]...