Hi thereApologies if this has been answered elsewhere but I have not been able to find an answer or any tips on my problem to point me in the right direction. My installation has went well until I get to Step 3 - Database.I get the error: The database configuration failed with the following message: Arithmetic operation resulted in an overflow. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')I am using shared hosting and it is Server version: 5.1.56-community for the MySql database.
2013-04-21 14:48:42,814 [67] INFO Umbraco.Core.DatabaseContext - [Thread 317] Configured a new ConnectionString using the 'MySql.Data.MySqlClient' provider. 2013-04-21 14:48:43,313 [185] INFO Umbraco.Core.CoreBootManager - [Thread 513] Umbraco application starting 2013-04-21 14:48:43,344 [67] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 52] Error executing query delete from umbracoLog where datestamp < @oldestPermittedLogEntry and logHeader in ('open','system') System.OverflowException: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms) at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteNonQuery(String commandText, MySqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2013-04-21 14:48:43,344 [67] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 52] Application shutdown. Reason: ConfigurationChange 2013-04-21 14:48:43,360 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Hash determined (took 8ms) 2013-04-21 14:48:43,375 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 12ms) 2013-04-21 14:48:43,406 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 1ms) 2013-04-21 14:48:43,406 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms) 2013-04-21 14:48:43,406 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms) 2013-04-21 14:48:43,422 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 1ms) 2013-04-21 14:48:43,422 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 0ms) 2013-04-21 14:48:43,531 [185] INFO Umbraco.Core.CoreBootManager - [Thread 513] Umbraco application startup complete (took 203ms) 2013-04-21 14:48:43,672 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 513] Error executing query select distinct alias from cmsPropertyType order by alias System.OverflowException: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) 2013-04-21 14:48:43,703 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 513] Error executing query select distinct alias from cmsPropertyType order by alias System.OverflowException: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) 2013-04-21 14:48:43,718 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 513] Error executing query select distinct alias from cmsPropertyType order by alias System.OverflowException: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) 2013-04-21 14:48:43,734 [185] INFO Umbraco.Core.ApplicationContext - [Thread 513] CurrentVersion different from configStatus: '6.0.3','' 2013-04-21 14:48:43,750 [185] INFO Umbraco.Core.ApplicationContext - [Thread 513] CurrentVersion different from configStatus: '6.0.3','' 2013-04-21 14:48:43,750 [185] INFO Umbraco.Core.ApplicationContext - [Thread 513] CurrentVersion different from configStatus: '6.0.3','' 2013-04-21 14:48:43,765 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 200] Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment) System.OverflowException: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms) at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteNonQuery(String commandText, MySqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) 2013-04-21 14:48:43,765 [185] ERROR umbraco.BusinessLogic.Log - [Thread 200] An error occurred adding an audit trail log to the umbracoLog table umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.OverflowException: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms) at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteNonQuery(String commandText, MySqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at umbraco.BusinessLogic.Log.AddSynced(LogTypes type, Int32 userId, Int32 nodeId, String comment) 2013-04-21 14:48:43,765 [185] INFO umbraco.BusinessLogic.Log - [Thread 200] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] Adding examine event handlers for index providers: 3 2013-04-21 14:48:44,030 [185] INFO Umbraco.Core.ApplicationContext - [Thread 252] CurrentVersion different from configStatus: '6.0.3','' 2013-04-21 14:48:44,030 [185] INFO umbraco.presentation.install.utills.p - [Thread 252] Running 'installOrUpgrade' service 2013-04-21 14:48:44,030 [185] INFO Umbraco.Core.DatabaseContext - [Thread 252] Database configuration status: Started 2013-04-21 14:48:44,046 [185] ERROR Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider - [Thread 252] Error querying for lower_case support System.OverflowException: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at Umbraco.Core.Persistence.Database.OpenSharedConnection() at Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider.SupportsCaseInsensitiveQueries(Database db) 2013-04-21 14:48:44,124 [185] INFO Umbraco.Core.DatabaseContext - [Thread 252] Database configuration failed with the following error and stack trace: Arithmetic operation resulted in an overflow. at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at Umbraco.Core.Persistence.Database.OpenSharedConnection() at Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider.GetTablesInSchema(Database db) at Umbraco.Core.Persistence.Migrations.Initial.DatabaseSchemaCreation.ValidateSchema() at Umbraco.Core.DatabaseContext.ValidateDatabaseSchema() at Umbraco.Core.DatabaseContext.CreateDatabaseSchemaAndDataOrUpgrade()
Have you ensured the connection is correct and that the database name is correct and the user you are specfying has access to that database. Login into SQL using SQL auth and try and create a blank table in the blank database you created for your umbraco instance. Then remove this table of course. :)
Thanks for your reply - everything seems to be ok with the database - I can connect to it and create tables no problem. Now when I try to visit the site I get the error below. I downloaded the web.config file and it has the DB connection info in it. When I change this to something I know is wrong I still get the error below. Do you think this could be database connection/permission related?
I can't get back into the install site anymore it just takes me to a page with the error above.
I can get to the login screen if i visit www.rubberit.com/umbraco/ but I have not set up any users yet as I think this is step4 which I havent managed to get to.
With regards to the URL above - this currently points to a different site I have edited my local host file to point to the server where it resides on 85.234.146.230
In the web.config it has updated the connection string to
<connectionStrings> <remove name="umbracoDbDSN" /> <add name="umbracoDbDSN" connectionString="Server=localhost; Database=xxx;Uid=xxx;Pwd=xxx;" providerName="MySql.Data.MySqlClient" /> <!-- Important: If you're upgrading Umbraco, do not clear the connection string / provider name during your web.config merge. --> </connectionStrings>
Yeah completley clear. the xxx's above I removed it does actually have values. I was wondering if it was worth restoring the web.config file to the original that comes with the package?
Yea you could do. In your log near the bottom you have:
at Umbraco.Core.Persistence.Database.OpenSharedConnection() at Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider.SupportsCaseInsensitiveQueries(Database db)
2013-04-21 14:48:44,124 [185] INFO Umbraco.Core.DatabaseContext - [Thread 252] Database configuration failed with the following error and stack trace: Arithmetic operation resulted in an overflow.
So the problem would appear to be permissions.
Just saw you are using shared hosting. Do you have the correct read write permissions.
I replaced the web.config file and it let me into the installation wizard again. As before get to step 3 and then it stops at 90% with the message The database configuration failed with the following message:
Arithmetic operation resulted in an overflow. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
With regards to permissions, the database user can create and edit tables and queries. I have tested this by logging into the database itself and this all seems to work ok.
Other permissions I have granted, originally there was a couple that were not set corretly but I also amended these as the wizard highighted each of the folders. I also gave permissions to the web.config file.
it should not be. In the umbraco install you should just choose MySql, enter the connection, user and password and away you go. Did the stuff i said above help?
Can you just tell me what you are entering for the server and database name?. And please do. I would like to know if you find a solution. You should not have any more difficulty from 4.0 and 6.0+ install as far as i am aware :). Charlie :)
6.0.3 Fresh Manual Install MYSQL Database Problem
Hi thereApologies if this has been answered elsewhere but I have not been able to find an answer or any tips on my problem to point me in the right direction. My installation has went well until I get to Step 3 - Database.I get the error: The database configuration failed with the following message: Arithmetic operation resulted in an overflow. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')I am using shared hosting and it is Server version: 5.1.56-community for the MySql database.
This is the contents of the tracelog -
2013-04-21 14:48:42,814 [67] INFO Umbraco.Core.DatabaseContext - [Thread 317] Configured a new ConnectionString using the 'MySql.Data.MySqlClient' provider.
2013-04-21 14:48:43,313 [185] INFO Umbraco.Core.CoreBootManager - [Thread 513] Umbraco application starting
2013-04-21 14:48:43,344 [67] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 52] Error executing query delete from umbracoLog where datestamp < @oldestPermittedLogEntry and logHeader in ('open','system')
System.OverflowException: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteNonQuery(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
2013-04-21 14:48:43,344 [67] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 52] Application shutdown. Reason: ConfigurationChange
2013-04-21 14:48:43,360 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Hash determined (took 8ms)
2013-04-21 14:48:43,375 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 12ms)
2013-04-21 14:48:43,406 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 1ms)
2013-04-21 14:48:43,406 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms)
2013-04-21 14:48:43,406 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms)
2013-04-21 14:48:43,422 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 1ms)
2013-04-21 14:48:43,422 [185] INFO Umbraco.Core.PluginManager - [Thread 513] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 0ms)
2013-04-21 14:48:43,531 [185] INFO Umbraco.Core.CoreBootManager - [Thread 513] Umbraco application startup complete (took 203ms)
2013-04-21 14:48:43,672 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 513] Error executing query select distinct alias from cmsPropertyType order by alias
System.OverflowException: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
2013-04-21 14:48:43,703 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 513] Error executing query select distinct alias from cmsPropertyType order by alias
System.OverflowException: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
2013-04-21 14:48:43,718 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 513] Error executing query select distinct alias from cmsPropertyType order by alias
System.OverflowException: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
2013-04-21 14:48:43,734 [185] INFO Umbraco.Core.ApplicationContext - [Thread 513] CurrentVersion different from configStatus: '6.0.3',''
2013-04-21 14:48:43,750 [185] INFO Umbraco.Core.ApplicationContext - [Thread 513] CurrentVersion different from configStatus: '6.0.3',''
2013-04-21 14:48:43,750 [185] INFO Umbraco.Core.ApplicationContext - [Thread 513] CurrentVersion different from configStatus: '6.0.3',''
2013-04-21 14:48:43,765 [185] ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 200] Error executing query insert into umbracoLog (userId, nodeId, logHeader, logComment) values (@userId, @nodeId, @logHeader, @comment)
System.OverflowException: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteNonQuery(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
2013-04-21 14:48:43,765 [185] ERROR umbraco.BusinessLogic.Log - [Thread 200] An error occurred adding an audit trail log to the umbracoLog table
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.OverflowException: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms)
at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteNonQuery(String commandText, MySqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
at umbraco.BusinessLogic.Log.AddSynced(LogTypes type, Int32 userId, Int32 nodeId, String comment)
2013-04-21 14:48:43,765 [185] INFO umbraco.BusinessLogic.Log - [Thread 200] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] Adding examine event handlers for index providers: 3
2013-04-21 14:48:44,030 [185] INFO Umbraco.Core.ApplicationContext - [Thread 252] CurrentVersion different from configStatus: '6.0.3',''
2013-04-21 14:48:44,030 [185] INFO umbraco.presentation.install.utills.p - [Thread 252] Running 'installOrUpgrade' service
2013-04-21 14:48:44,030 [185] INFO Umbraco.Core.DatabaseContext - [Thread 252] Database configuration status: Started
2013-04-21 14:48:44,046 [185] ERROR Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider - [Thread 252] Error querying for lower_case support
System.OverflowException: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Umbraco.Core.Persistence.Database.OpenSharedConnection()
at Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider.SupportsCaseInsensitiveQueries(Database db)
2013-04-21 14:48:44,124 [185] INFO Umbraco.Core.DatabaseContext - [Thread 252] Database configuration failed with the following error and stack trace: Arithmetic operation resulted in an overflow.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet)
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Umbraco.Core.Persistence.Database.OpenSharedConnection()
at Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider.GetTablesInSchema(Database db)
at Umbraco.Core.Persistence.Migrations.Initial.DatabaseSchemaCreation.ValidateSchema()
at Umbraco.Core.DatabaseContext.ValidateDatabaseSchema()
at Umbraco.Core.DatabaseContext.CreateDatabaseSchemaAndDataOrUpgrade()
Have you ensured the connection is correct and that the database name is correct and the user you are specfying has access to that database. Login into SQL using SQL auth and try and create a blank table in the blank database you created for your umbraco instance. Then remove this table of course. :)
Hi there
Thanks for your reply - everything seems to be ok with the database - I can connect to it and create tables no problem. Now when I try to visit the site I get the error below. I downloaded the web.config file and it has the DB connection info in it. When I change this to something I know is wrong I still get the error below. Do you think this could be database connection/permission related?
Thanks again for your help.
[OverflowException: Arithmetic operation resulted in an overflow.]
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) +75
MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) +390
MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) +92
MySql.Data.MySqlClient.NativeDriver.Open() +1045
MySql.Data.MySqlClient.Driver.Open() +22
MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +210
MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +289
MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() +113
MySql.Data.MySqlClient.MySqlPool.GetConnection() +72
MySql.Data.MySqlClient.MySqlConnection.Open() +555
Umbraco.Core.Persistence.Database.OpenSharedConnection() +51
Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider.GetTablesInSchema(Database db) +43
Umbraco.Core.Persistence.Migrations.Initial.DatabaseSchemaCreation.ValidateSchema() +341
Umbraco.Core.DatabaseContext.ValidateDatabaseSchema() +184
umbraco.presentation.install.welcome.Page_Load(Object sender, EventArgs e) +31
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Control.LoadRecursive() +146
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207
When you said you downloaded it? Is this your local machine? Also which url are you trying to access? Can you get into the umbraco backend?
Charlie.
When you get to step three in the install what connection string are you entering?. No problem :). Charlie
Hi there
I can't get back into the install site anymore it just takes me to a page with the error above.
I can get to the login screen if i visit www.rubberit.com/umbraco/ but I have not set up any users yet as I think this is step4 which I havent managed to get to.
With regards to the URL above - this currently points to a different site I have edited my local host file to point to the server where it resides on 85.234.146.230
Ok so go to the address www.rubberit.com/install :) That sould take you to the install screen.
It now just takes me to an error:
In the web.config it has updated the connection string to
Thanks for your help.
Hi just to be completly clear. This was a clean install of umbraco? What version was it?
also what does event manager say?
Hi
Yeah completley clear. the xxx's above I removed it does actually have values. I was wondering if it was worth restoring the web.config file to the original that comes with the package?
It is version 6.0.3 downloaded this afternoon from http://umbraco.codeplex.com/releases
Thanks
Yea you could do. In your log near the bottom you have:
at Umbraco.Core.Persistence.Database.OpenSharedConnection()
at Umbraco.Core.Persistence.SqlSyntax.MySqlSyntaxProvider.SupportsCaseInsensitiveQueries(Database db)
2013-04-21 14:48:44,124 [185] INFO Umbraco.Core.DatabaseContext - [Thread 252] Database configuration failed with the following error and stack trace: Arithmetic operation resulted in an overflow.
So the problem would appear to be permissions.
Just saw you are using shared hosting. Do you have the correct read write permissions.
Sorry, not sure what you mean by Event Manager.
I replaced the web.config file and it let me into the installation wizard again. As before get to step 3 and then it stops at 90% with the message The database configuration failed with the following message:
With regards to permissions, the database user can create and edit tables and queries. I have tested this by logging into the database itself and this all seems to work ok.
Other permissions I have granted, originally there was a couple that were not set corretly but I also amended these as the wizard highighted each of the folders. I also gave permissions to the web.config file.
Cheers
Sorry i meant Event Viewer :).
Ok. With the user you are using for SQL, you can log into management studio with SQL authentication.
What are you using in the connection bit (sorry i forgot the field name) It's where you enter something like ./sqlexpress
Have you given IIS_ISURS permission on the root directory? Charlie :)
Hi Charles
I'm using mySQL - not sure if this makes a difference.
It might do i have always used sql express hmmmm
it should not be. In the umbraco install you should just choose MySql, enter the connection, user and password and away you go. Did the stuff i said above help?
LOL :)
I have a version 4 of Umbraco which uses mySQL - i might try and get hold of an older version and try that.
Thanks for your help - I will let you know how I get on.
Brian
Can you just tell me what you are entering for the server and database name?. And please do. I would like to know if you find a solution. You should not have any more difficulty from 4.0 and 6.0+ install as far as i am aware :). Charlie :)
Hi there
Just installed version 4.11.6 using the exact same DB settings and it worked perfectly.
Thanks again for your time!
No problem, glad you got it to work. If it is a bug with 6.0 + then you might want to raise it here :).
http://issues.umbraco.org/issues
Charlie.
is working on a reply...