2.6 Fresh installation mysql error

Topics: Business Logic Layer
May 23, 2012 at 3:19 PM

I have a fresh install of 2.6 and followed the instructions for using the mysql provider.  I have copied the mysqlweb.config to the root folder and changed the connection information and now I'm getting the following errors:

 

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.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.

Source Error: 




An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace: 





[ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.]
   System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow) +2224714
   BlogEngine.Core.Providers.DbConnectionHelper..ctor(String providerName, String connectionString) in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Providers\DbConnectionHelper.cs:55
   BlogEngine.Core.Providers.DbBlogProvider.FillBlogs() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Providers\DbBlogProvider.cs:461
   BlogEngine.Core.Blog.get_Blogs() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Blog.cs:412
   BlogEngine.Core.Blog.get_CurrentInstance() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Blog.cs:489
   BlogEngine.Core.Right.EnsureBlogInstanceDataLoaded() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Security\Right.cs:542
   BlogEngine.Core.Right..cctor() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Security\Right.cs:113

[TypeInitializationException: The type initializer for 'BlogEngine.Core.Right' threw an exception.]
   BlogEngine.Core.Right..ctor() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Security\Right.cs:534

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +117
   System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +247
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +106
   System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +12738733
   System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture) +28
   System.Web.HttpRuntime.CreateNonPublicInstance(Type type, Object[] args) +83
   System.Web.HttpApplication.BuildIntegratedModuleCollection(List`1 moduleList) +299
   System.Web.HttpApplication.GetModuleCollection(IntPtr appContext) +1356
   Microsoft.Web.Infrastructure.DynamicModuleHelper.DynamicModuleReflectionUtil.GetIntegratedModuleCollection(HttpApplication target, IntPtr appContext) +34
   Microsoft.Web.Infrastructure.DynamicModuleHelper.CriticalStatics.Init(HttpApplication context) +233
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +575
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +352
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +407
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +375

[HttpException (0x80004005): Exception has been thrown by the target of an invocation.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11700896
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +141
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4869125
 
Is there anything else other than the connection information I need to edit? 

May 23, 2012 at 3:30 PM

Okay, I needed to install the 6.5.4 version of the mysql .net connector.  But bow I have a different error:

Unknown column 'IsSiteAggregation' in 'field list' 
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: MySql.Data.MySqlClient.MySqlException: Unknown column 'IsSiteAggregation' in 'field list'

Source Error: 




An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace: 





[MySqlException (0x80004005): Unknown column 'IsSiteAggregation' in 'field list']
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +517
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) +450
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +131
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1261
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +2431
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +9
   BlogEngine.Core.Providers.DbBlogProvider.FillBlogs() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Providers\DbBlogProvider.cs:465
   BlogEngine.Core.Blog.get_Blogs() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Blog.cs:412
   BlogEngine.Core.Blog.get_CurrentInstance() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Blog.cs:489
   BlogEngine.Core.Right.EnsureBlogInstanceDataLoaded() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Security\Right.cs:542
   BlogEngine.Core.Right..cctor() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Security\Right.cs:113

[TypeInitializationException: The type initializer for 'BlogEngine.Core.Right' threw an exception.]
   BlogEngine.Core.Right..ctor() in J:\Projects\BlogEngine_2_6_0_5\Source\BlogEngine\BlogEngine.Core\Security\Right.cs:534

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +117
   System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +247
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +106
   System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +12738733
   System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture) +28
   System.Web.HttpRuntime.CreateNonPublicInstance(Type type, Object[] args) +83
   System.Web.HttpApplication.BuildIntegratedModuleCollection(List`1 moduleList) +299
   System.Web.HttpApplication.GetModuleCollection(IntPtr appContext) +1356
   Microsoft.Web.Infrastructure.DynamicModuleHelper.DynamicModuleReflectionUtil.GetIntegratedModuleCollection(HttpApplication target, IntPtr appContext) +34
   Microsoft.Web.Infrastructure.DynamicModuleHelper.CriticalStatics.Init(HttpApplication context) +233
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +575
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +352
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +407
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +375

[HttpException (0x80004005): Exception has been thrown by the target of an invocation.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11700896
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +141
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4869125
 

Coordinator
May 24, 2012 at 8:15 AM

Did you run the MySQL setup script with the file name MySQLSetup2.6.0.sql?  Here's what that file looks like:

http://blogengine.codeplex.com/SourceControl/changeset/view/6813f09ac137#BlogEngine%2fBlogEngine.NET%2fsetup%2fMySQL%2fMySQLSetup2.6.0.sql

The very top part of it creates the be_Blogs table, and it includes the column "IsSiteAggregation" which your error message seems to indicate is not there.

If you check the be_Blogs table in MySQL, do you see a column named IsSiteAggregation?  If not, then you may not have run the correct MySQL script.  If you do see that column in your be_Blogs table, then make sure your connection string in the web.config file is pointing to the right MySQL BlogEngine DB (in case you happen to have more than one DB setup).