Error Post Ugrade to 8.7.290

Update/Migration/Backup issues
Post Reply
Posts: 1
Joined: Sun Mar 06, 2016 2:31 pm

Error Post Ugrade to 8.7.290

Post by aabdullah » Sun Mar 06, 2016 2:43 pm


I'm using OnlyOffice (TeamLab) since it was released as open source and im upgrading same installation each time with the new version with no issues. However, last update to 8.7.290 resulted in my site broken with strange MySQL error dump, you may see below ,, any help

Code: Select all

Server Error in '/' Application.

Unknown column 'p.affiliate_id' in 'field list'

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: Unknown column 'p.affiliate_id' in 'field list'

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): Unknown column 'p.affiliate_id' in 'field list']
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +444
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +474
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +136
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1121
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +2616
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +9
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +23
   ASC.Common.Data.DataExtensions.ExecuteListReader(IDbCommand command) +104
   ASC.Core.Data.DbBaseService.ExecList(ISqlInstruction sql) +87
   ASC.Core.Data.DbTenantService.GetTenants(Exp where) +29
   ASC.Core.Data.DbTenantService.GetTenant(String domain) +215
   ASC.Core.Caching.CachedTenantService.GetTenant(String domain) +221
   ASC.Core.TenantManager.GetTenant(String domain) +125
   ASC.Core.TenantManager.GetCurrentTenant(Boolean throwIfNotFound) +260
   ASC.Web.Studio.Core.WarmUp..ctor() +140
   ASC.Web.Studio.Core.WarmUp..cctor() +84

[TypeInitializationException: The type initializer for 'ASC.Web.Studio.Core.WarmUp' threw an exception.]
   ASC.Web.Studio.MainPage.get_RedirectToStartup() +187
   ASC.Web.Studio.MainPage.Page_PreInit(Object sender, EventArgs e) +80
   ASC.Web.Studio._Default.OnPreInit(EventArgs e) +116
   System.Web.UI.Page.PerformPreInit() +49
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1844

Posts: 700
Joined: Tue Sep 30, 2014 11:04 am

Re: Error Post Ugrade to 8.7.290

Post by Dean » Wed Mar 09, 2016 11:38 am

Please add the field "affiliate_id" to the 'tenants_partners' table manually

Post Reply