More in this section

Forums / Bugs & Issues / Error on creating event. Sitefinity Version=5.0.2533.0

Error on creating event. Sitefinity Version=5.0.2533.0

1 posts, 0 answered
  1. Onur
    Onur avatar
    9 posts
    Registered:
    30 Jul 2012
    26 Apr 2012
    Link to this post
    I have an issue when I tried to create event.
    I'am using Windows 7 64 bit and MySql 5.2.39 also I have import turkish language package.
    When I tried to click on event menu, it gaves me database issue. It's known mysql issue I think but I have not so much experience about mysql :(
    I'am using turkish language pack. I tried to create column city_tr in sf_event table but no chance issue occurs again.
    You have said that MySQL: Multilingual is not supported on
    http://www.sitefinity.com/devnet/forums/sitefinity-4-x/bugs-issues/row-size-too-large-the-maximum-row-size-for-the-used-table-type-not-counting-blobs-is-65535.aspx 

    But this issue occurs only when I was tried to create event.

    Here is the log above Thanks for your help

    04/26/2012 09:32:27
    Type : System.Exception, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
    Message : Unable to upgrade database schema metadataSource provided by 'Telerik.Sitefinity.Modules.Events.Data.OpenAccessEventProvider': Telerik.OpenAccess.OpenAccessException: SQL exception on 'ALTER TABLE `sf_events` ADD COLUMN `city_tr` NVARCHAR(255) NULL' : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
    Source : 
    Help link : 
    Data : System.Collections.ListDictionaryInternal
    TargetSite : 
    Stack Trace : The stack trace is unavailable.
    Additional Info:


    MachineName : T1LPRVT1357
    TimeStamp : 26.04.2012 06:32:27
    FullName : Telerik.Sitefinity.Utilities, Version=5.0.2533.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
    AppDomainName : /LM/W3SVC/3/ROOT-1-129798940198458767
    ThreadIdentity : admin
    WindowsIdentity : IIS APPPOOL\SoftTechCMS
    Requested URL : http://localhost:3366/Sitefinity/Content/Ethinlikler
    Inner Exception
    ---------------
    Type : Telerik.OpenAccess.OpenAccessException, Telerik.OpenAccess, Version=2011.3.1320.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
    Message : Telerik.OpenAccess.OpenAccessException: SQL exception on 'ALTER TABLE `sf_events` ADD COLUMN `city_tr` NVARCHAR(255) NULL' : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
    Source : Telerik.Sitefinity
    Help link : 
    InnerExceptions : System.Exception[]
    FailedObject : 
    BackendError : 
    Reason : Runtime
    CanRetry : True
    Data : System.Collections.ListDictionaryInternal
    TargetSite : Void UpgradeDatabase(Telerik.OpenAccess.Database)
    Stack Trace :    at Telerik.Sitefinity.Data.OA.OpenAccessConnection.UpgradeDatabase(Database database)
       at Telerik.Sitefinity.Data.OA.OpenAccessConnection.UpdateMetadata(MetadataSource metadataSource, String moduleName, List`1 dynamicTypesToRegister, IOpenAccessMetadataProvider provider)


    Inner Exception
    ---------------
    Type : Telerik.OpenAccess.OpenAccessException, Telerik.OpenAccess, Version=2011.3.1320.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
    Message : SQL exception on 'ALTER TABLE `sf_events` ADD COLUMN `city_tr` NVARCHAR(255) NULL' : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
    Source : Telerik.OpenAccess.Runtime
    Help link : 
    InnerExceptions : System.Exception[]
    FailedObject : 
    BackendError : Telerik.OpenAccess.RT.sql.SQLException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql)
       at OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder)
    Reason : Runtime
    CanRetry : True
    Data : System.Collections.ListDictionaryInternal
    TargetSite : System.Exception Throw()
    Stack Trace :    at OpenAccessRuntime.ExceptionWrapper.Throw()
       at OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e)
       at OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder)
       at OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.runScript(String script)
       at OpenAccessRuntime.DataObjects.tools.ant.ExecuteScriptTask.execute()


    Inner Exception
    ---------------
    Type : Telerik.OpenAccess.RT.sql.SQLException, Telerik.OpenAccess.Runtime, Version=2011.3.1320.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
    Message : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
    Source : Telerik.OpenAccess.Runtime
    Help link : 
    ErrorCode : 1118
    Number : 1118
    ObjectId : 
    Description : SQLState=;Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
    Data : System.Collections.ListDictionaryInternal
    TargetSite : Int32 executeUpdate(System.String)
    Stack Trace :    at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql)
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql)
       at OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder)
1 posts, 0 answered