This project is read-only.

Orchard 1.7.1, problem with installing the theme



I setup clean Orchard 1.7.1 version with database on SqlServer 2008. Tried to install the theme and the message "Some features need to be upgraded: TheMetroTheme" appeared in the Themes section in Orchard Dashboard.
Also there is an error in the log file:

,228 [369] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 1 for TheMetroTheme System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'set'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Orchard.Data.Migration.Interpreters.DefaultDataMigrationInterpreter.RunPendingStatements() in d:\Builds\OrchardFull\src\Orchard\Data\Migration\Interpreters\DefaultDataMigrationInterpreter.cs:line 336 at Orchard.Data.Migration.Interpreters.DefaultDataMigrationInterpreter.Visit(AlterTableCommand command) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\Interpreters\DefaultDataMigrationInterpreter.cs:line 141 at Orchard.Data.Migration.Interpreters.AbstractDataMigrationInterpreter.Visit(ISchemaBuilderCommand command) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\Interpreters\AbstractDataMigrationInterpreter.cs:line 17 at Orchard.Data.Migration.Schema.SchemaBuilder.AlterTable(String name, Action`1 table) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\Schema\SchemaBuilder.cs:line 38 at TheMetroTheme.Migrations.UpdateFrom1() --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object tar"

Any ideas ?

file attachments


DilyanDimitrov wrote Oct 30, 2013 at 9:46 PM

Tried the theme with Orchard 1.7.1 with Sql Server Compact and everything was fine....

DilyanDimitrov wrote Nov 12, 2013 at 10:18 PM


I worked around the issue by creating the table for the theme manually and set in the Migration table that all migrations are passed.
INSERT INTO [db_name].[db_schema].Orchard_Framework_DataMigrationRecord
Hope this helps to someone.

wrote Apr 28, 2014 at 6:04 AM

tinystudio wrote Apr 28, 2014 at 6:04 AM

Meet the same problem too. I got a solution from

and I changed some code of orchard framework and it works with no problem. hope it can help you.

wrote Feb 8, 2015 at 9:01 AM