+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / ysql Error :Specified key was too long; max key length is 1000 bytes

ysql Error :Specified key was too long; max key length is 1000 bytes

2 posts, 0 answered
  1. anta
    anta avatar
    1 posts
    Registered:
    16 Apr 2009
    20 Apr 2009
    Link to this post
    I try to install sitefinity v 3.6 with mysql database. Instalation was success until I fill admin, password admin and email address. I click button "I'am done". process was so long, and I get error message like this:

    Specified key was too long; max key length is 1000 bytes

    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: Specified key was too long; max key length is 1000 bytes

    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): Specified key was too long; max key length is 1000 bytes]
       Telerik.DataAccess.MySQLProvider.ExecSchemaChange(String change) +330
       Nolics.ORMapper.Base.OdbDataProvider.Upgrade() +97
       Telerik.Security.Data.DefaultSecurityProvider.Initialize(String name, NameValueCollection config) +544
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +848
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings) +133
       Telerik.ManagerBase`1.SetProvider(String providerName) +351
       Telerik.ManagerBase`1..ctor(String providerName) +173
       Telerik.ManagerBase`1..ctor() +30
       Telerik.Security.SecurityManager..ctor() +23
       Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +1216
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +848
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings) +133
       Telerik.ManagerBase`1.SetProvider(String providerName) +351
       Telerik.ManagerBase`1..ctor(String providerName) +173
       Telerik.ManagerBase`1..ctor() +30
       Telerik.Cms.CmsManager..ctor() +24
       Telerik.Cms.Web.UrlHelper.Initialize() +35
       Telerik.Cms.Web.CmsHttpModule.Init(HttpApplication context) +118
       System.Web.HttpApplication.InitModulesCommon() +66
       System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1006
       System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +259
       System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +114
       System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +350
    

    What should I do ?

    thx
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    22 Apr 2009
    Link to this post
    Hello anta,

    We released a SP1 two days ago. Could you try using the SP1 of version 3.6.Also, there is a bug in MySql 4 related to the problem you have. Try using version 5.1 or later if you have an old one instead.

    If you need further assistance, please let us know.

    Kind regards,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
2 posts, 0 answered