as I already wrote in Yaf 3.2.2 the upgrade process is broken. You need to use 3.2.3 if you want to upgrade.

Originally Posted by: tha_watcha 

I tagged the wrong branch. The release did include the YAF 4.0 sample app

I updated the release with the correct version

https://github.com/YAFNET/YAF.SampleWebApplication/releases/tag/v3.2.3 

Originally Posted by: tha_watcha 

Incorrect syntax near ';'.

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: System.Data.SqlClient.SqlException: Incorrect syntax near ';'.

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:

[SqlException (0x80131904): Incorrect syntax near ';'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2586154 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039978 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +997 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +314 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +297 ServiceStack.OrmLite.OrmLiteWriteCommandExtensions.ExecuteSql(IDbCommand dbCmd, String sql, IEnumerable`1 sqlParams, Action`1 commandFilter) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteWriteCommandExtensions.cs:364 ServiceStack.OrmLite.c__DisplayClass2_0.b__0(IDbCommand dbCmd) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteWriteApi.cs:63 ServiceStack.OrmLite.OrmLiteExecFilter.Exec(IDbConnection dbConn, Func`2 filter) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteExecFilter.cs:180 ServiceStack.OrmLite.OrmLiteReadExpressionsApi.Exec(IDbConnection dbConn, Func`2 filter) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteReadExpressionsApi.cs:34 ServiceStack.OrmLite.OrmLiteWriteApi.ExecuteSql(IDbConnection dbConn, String sql) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteWriteApi.cs:63 ServiceStack.OrmLite.OrmLiteSchemaModifyApi.DropForeignKey(IDbConnection dbConn, String foreignKeyName) in C:\YAFNET\yafsrc\ServiceStack\ServiceStack.OrmLite\OrmLiteSchemaModifyApi.cs:439 YAF.Core.Migrations.Migration80.UpgradeTable(IRepository`1 repository, IDbCommand dbCommand) +132 YAF.Core.Migrations.c__DisplayClass2_0.b__1(IDbCommand dbCommand) +1134 YAF.Core.Data.DbAccessBase.Execute(Func`2 execFunc, IDbCommand cmd, IDbTransaction dbTransaction) +144 YAF.Core.Migrations.Migration80.MigrateDatabase(IDbAccess dbAccess) +229 YAF.Core.Services.UpgradeService.Upgrade() +422 YAF.Core.Services.Startup.StartupInitializeDb.RunService() +294 YAF.Core.Services.Startup.BaseStartupService.Run() +28 YAF.Core.Extensions.c.b__0_2(IStartupService service) +10 System.Collections.Generic.List`1.ForEach(Action`1 action) +88 YAF.Core.Extensions.IHaveServiceLocatorExtensions.RunStartupServices(IHaveServiceLocator serviceLocator) +356 YAF.Core.Context.YafHttpApplication.Session_Start(Object sender, EventArgs e) +15 System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) +10082212 System.Web.SessionState.SessionStateModule.CompleteAcquireState() +165 System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +1126 System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +297 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +50 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +163

Post back on how it goes with the upgrade! I'm also using Sample Application. My upgrade would be a little bit more involved as I'd have to re-add the Chat. My members rely on that thing like crazy haha. So I might hold off until v4 and do a big update! 😁

Originally Posted by: eutychus