Error on creating event. Sitefinity Version=5.0.2533.0
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 : localhost:3366/.../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)