Error on creating event. Sitefinity Version=5.0.2533.0

Posted by Community Admin on 04-Aug-2018 08:01

Error on creating event. Sitefinity Version=5.0.2533.0

All Replies

Posted by Community Admin on 26-Apr-2012 00:00

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)

This thread is closed