Hi Sebastien <[email protected]>, I migrated my blog content from http://weblogs.asp.net/steveschofield into Orchard with no issues. I have a BUNCH of powershell examples which $ is used as a variable. I'll see if I can find $( which is also used in powershell quite a bit. Should I just start over with a fresh Orchard install and start out with SQL Server as my backend db vs. sqlce? This is the one of the things from holding me up in launching my updated site with Orchard.
The other item I want to provide feedback on is being able to change the 'admin' vs to something else. It would be great to have this in configuration vs. hard coded. If someone knows you are running an orchard site, they would automatically know you have an '/admin' exposed. I know there are login and other restrictions we can do so it's not super critical, just a nice to have. Steve On Wed, May 11, 2011 at 10:16 PM, Sebastien Ros <[email protected] > wrote: > You may have some content or comments with “$(“ inside. Even more if you > have ever written about jQuery. This is a WebMatrix bug which takes this as > an internal command an tries to execute it. > > Could you try to find this occurrence in your content ? > > > > *From:* Steve Schofield [mailto:[email protected]] > *Sent:* Wednesday, May 11, 2011 6:27 PM > *To:* [email protected] > *Subject:* migration from web matrix sqlce to sql express / sql server > fails with cryptic error. > > > > I’m trying to migrate my sqlce database and getting this error below. I > tried SQL Server and sql express with no luck. Any advice? > > > > The migration of the database from SQL Server Compact to SQL Server failed. > > > > --------------------------- > > Migration failed > > --------------------------- > > Migration failed > > > > An error occurred during execution of the database script. The error > occurred between the following lines of the script: "5800" and "5812". The > verbose log might have more information about the error. The command started > with the following: > > "INSERT INTO [dbo].[Common_BodyPartRecord]([Id],[Co" > > > > --------------------------- > > OK > > --------------------------- > > > > --------------------------- > > Microsoft.Web.Deployment.DeploymentException: An error occurred during > execution of the database script. The error occurred between the following > lines of the script: "5800" and "5812". The verbose log might have more > information about the error. The command started with the following: > > "INSERT INTO [dbo].[Common_BodyPartRecord]([Id],[Co" > > ---> ManagedBatchParser.ParserException > > at ManagedBatchParser.Parser.Parse() > > at Microsoft.Web.Deployment.SqlBatchParser.ProcessSqlCmdScript(String > sqlCmdScript) > > at > Microsoft.Web.Deployment.SqlScriptToDBProvider.AddHelper(DeploymentObject > source, Boolean whatIf) > > --- End of inner exception stack trace --- > > at > Microsoft.Web.Deployment.SqlScriptToDBProvider.AddHelper(DeploymentObject > source, Boolean whatIf) > > at Microsoft.Web.Deployment.SqlScriptToDBProvider.Add(DeploymentObject > source, Boolean whatIf) > > at Microsoft.Web.Deployment.DeploymentObject.AddChild(DeploymentObject > source, Int32 position, DeploymentSyncContext syncContext) > > at > Microsoft.Web.Deployment.DeploymentSyncContext.HandleAddChild(DeploymentObject > destParent, DeploymentObject sourceObject, Int32 position) > > at > Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject > dest, DeploymentObject source) > > at > Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject > dest, DeploymentObject source) > > at > Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject > dest, DeploymentObject source) > > at > Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject > dest, DeploymentObject source) > > at > Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject > destinationObject, DeploymentObject sourceObject) > > at > Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject > destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, > ContentRootTable contentRootTable) > > at > Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions > providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions > syncOptions) > > at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, > String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions > syncOptions) > > at > Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider > provider, String path, DeploymentBaseOptions baseOptions, > DeploymentSyncOptions syncOptions) > > at > Microsoft.WebMatrix.DatabaseManager.Client.SqlCeHelper.<>c__DisplayClass6.<StartMigrate>b__5(Object > sender, DoWorkEventArgs eventArgs) > > at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) > > at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object > argument) > > --------------------------- > > > > > Thank you, > > Steve Schofield > Windows Server MVP - IIS > http://weblogs.asp.net/steveschofield > > --- > You are currently subscribed to orchard-discuss as: > [email protected]. > To unsubscribe send a blank email to > [email protected]. > > --- > You are currently subscribed to orchard-discuss as: [email protected]. > To unsubscribe send a blank email to > [email protected]. > --- You are currently subscribed to orchard-discuss as: [email protected]. To unsubscribe send a blank email to [email protected].
