Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 15:46
    Brian Thomson
    0

    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.

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 15:50
    Brian Thomson
    0

    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()

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 16:23
    Charles Afford
    0

    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. :)

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 19:41
    Brian Thomson
    0

    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

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 19:55
    Charles Afford
    0

    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.

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 19:57
    Charles Afford
    0

    When you get to step three in the install what connection string are you entering?.  No problem :).  Charlie

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 20:09
    Brian Thomson
    0

    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

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 20:12
    Charles Afford
    0

    Ok so go to the address www.rubberit.com/install :)  That sould take you to the install screen.  

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 20:22
    Brian Thomson
    0

    It now just takes me to an error:

    [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

    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>


    Thanks for your help.

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 20:28
    Charles Afford
    0

    Hi just to be completly clear.  This was a clean install of umbraco?  What version was it?    

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 20:29
    Charles Afford
    0

    also what does event manager say?

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 20:33
    Brian Thomson
    0

    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

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 20:34
    Charles Afford
    0

    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.

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 20:42
    Brian Thomson
    0

    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:

    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.

     

    Cheers

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 20:48
    Charles Afford
    0

    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 :)

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 21:03
    Brian Thomson
    0

    Hi Charles

     

    I'm using mySQL - not sure if this makes a difference.

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 21:07
    Charles Afford
    0

    It might do i have always used sql express hmmmm

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 21:08
    Charles Afford
    0

    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?

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 21:09
    Brian Thomson
    0

    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

     

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 21:11
    Charles Afford
    0

    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 :)

  • Brian Thomson 15 posts 45 karma points
    Apr 21, 2013 @ 22:15
    Brian Thomson
    0

    Hi there

     

    Just installed version 4.11.6 using the exact same DB settings and it worked perfectly.

    Thanks again for your time!

  • Charles Afford 1163 posts 1709 karma points
    Apr 21, 2013 @ 22:24
    Charles Afford
    0

    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.

Please Sign in or register to post replies

Write your reply to:

Draft