{"action":"closed","issue":{"url":"https://api.github.com/repos/OrchardCMS/OrchardTest/issues/202","labels_url":"https://api.github.com/repos/OrchardCMS/OrchardTest/issues/202/labels{/name}","comments_url":"https://api.github.com/repos/OrchardCMS/OrchardTest/issues/202/comments","events_url":"https://api.github.com/repos/OrchardCMS/OrchardTest/issues/202/events","html_url":"https://github.com/OrchardCMS/OrchardTest/issues/202","id":67719174,"number":202,"title":"Blog module - SqlException when screen scraping","user":{"login":"orchardbot","id":11788683,"avatar_url":"https://avatars.githubusercontent.com/u/11788683?v=3","gravatar_id":"","url":"https://api.github.com/users/orchardbot","html_url":"https://github.com/orchardbot","followers_url":"https://api.github.com/users/orchardbot/followers","following_url":"https://api.github.com/users/orchardbot/following{/other_user}","gists_url":"https://api.github.com/users/orchardbot/gists{/gist_id}","starred_url":"https://api.github.com/users/orchardbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/orchardbot/subscriptions","organizations_url":"https://api.github.com/users/orchardbot/orgs","repos_url":"https://api.github.com/users/orchardbot/repos","events_url":"https://api.github.com/users/orchardbot/events{/privacy}","received_events_url":"https://api.github.com/users/orchardbot/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"bleroy","id":1165609,"avatar_url":"https://avatars.githubusercontent.com/u/1165609?v=3","gravatar_id":"","url":"https://api.github.com/users/bleroy","html_url":"https://github.com/bleroy","followers_url":"https://api.github.com/users/bleroy/followers","following_url":"https://api.github.com/users/bleroy/following{/other_user}","gists_url":"https://api.github.com/users/bleroy/gists{/gist_id}","starred_url":"https://api.github.com/users/bleroy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bleroy/subscriptions","organizations_url":"https://api.github.com/users/bleroy/orgs","repos_url":"https://api.github.com/users/bleroy/repos","events_url":"https://api.github.com/users/bleroy/events{/privacy}","received_events_url":"https://api.github.com/users/bleroy/received_events","type":"User","site_admin":false},"milestone":null,"comments":3,"created_at":"2010-03-29T11:02:22Z","updated_at":"2015-04-11T01:59:03Z","closed_at":"2015-04-11T01:59:03Z","body":"__rdaddis__ created:\r\nhttps://orchard.codeplex.com/workitem/16347\r\n\r\nChangeset #995 (abc25ca6ea8c)\r\nI have seen the following runtime error when I cut & paste text from a webpage (IE8) into a Blog Description and a Blog Post Body.\r\nNOTE: \r\n-\tthis exception occurred when adding and editing a Blog\r\n-\tthis exception occurred when adding a Blog Post\r\n-\tthis exception did not occur when editing a Blog Post\r\n-\tthis exception did not occur when adding a new Page\r\n\r\nSteps to reproduce:\r\n\r\n1 – navigate to the Orchard Admin Dashboard\r\n2 – highlight some text and <ctrl>+<c>\r\n3 – create a blog or blog post, or edit a blog\r\n4 - <ctrl>+<v> in the blog description or blog post body\r\n\r\nException Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.\r\nThe statement has been terminated.\r\n\r\nSource Error: \r\n\r\nLine 43:                 }\r\nLine 44:                 Logger.Debug(\"Final work for transaction being performed\");\r\nLine 45:                 _scope.Dispose();\r\nLine 46:                 Logger.Debug(\"Transaction disposed\");\r\nLine 47:             }\r\n\r\nSource File: X:\\Orchard\\src\\Orchard\\Data\\TransactionManager.cs    Line: 45 \r\n\r\nStack Trace: \r\n\r\n[SqlException (0x80131904): String or binary data would be truncated.\r\nThe statement has been terminated.]\r\n   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274\r\n   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707\r\n   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194\r\n   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392\r\n   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204\r\n   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954\r\n   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162\r\n   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175\r\n   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137\r\n   NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) +303\r\n   NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) +65\r\n   NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) +921\r\n\r\n[GenericADOException: could not insert: [Orchard.Blogs.Models.BlogRecord#16][SQL: INSERT INTO Blogs_BlogRecord (Description, PostCount, Id) VALUES (?, ?, ?)]]\r\n   NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) +1320\r\n   NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) +312\r\n   NHibernate.Action.EntityInsertAction.Execute() +363\r\n   NHibernate.Engine.ActionQueue.Execute(IExecutable executable) +187\r\n   NHibernate.Engine.ActionQueue.ExecuteActions(IList list) +125\r\n   NHibernate.Engine.ActionQueue.ExecuteActions() +34\r\n   NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) +221\r\n   NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) +101\r\n   NHibernate.Impl.SessionImpl.Flush() +297\r\n   NHibernate.Transaction.DistributedTransactionContext.System.Transactions.IEnlistmentNotification.Prepare(PreparingEnlistment preparingEnlistment) +445\r\n\r\n[TransactionAbortedException: The transaction has aborted.]\r\n   System.Transactions.TransactionStateAborted.EndCommit(InternalTransaction tx) +11\r\n   System.Transactions.CommittableTransaction.Commit() +228\r\n   System.Transactions.TransactionScope.InternalDispose() +328\r\n   System.Transactions.TransactionScope.Dispose() +1607\r\n   Orchard.Data.TransactionManager.System.IDisposable.Dispose() in R:\\a\\Orchard\\src\\Orchard\\Data\\TransactionManager.cs:45\r\n   Autofac.Disposer.Dispose(Boolean disposing) in d:\\Projects\\svn\\autofac-1.4\\src\\Source\\Autofac\\Disposer.cs:57\r\n   Autofac.Disposable.Dispose() in d:\\Projects\\svn\\autofac-1.4\\src\\Source\\Autofac\\Disposable.cs:23\r\n   Autofac.Container.Dispose(Boolean disposing) in d:\\Projects\\svn\\autofac-1.4\\src\\Source\\Autofac\\Container.cs:478\r\n   Autofac.Disposable.Dispose() in d:\\Projects\\svn\\autofac-1.4\\src\\Source\\Autofac\\Disposable.cs:23\r\n   Autofac.Integration.Web.ContainerProvider.DisposeRequestContainer() in d:\\Projects\\svn\\autofac-1.4\\src\\Source\\Autofac.Integration.Web\\ContainerProvider.cs:59\r\n   Orchard.Environment.DefaultOrchardHost.EndRequest() in R:\\a\\Orchard\\src\\Orchard\\Environment\\DefaultOrchardHost.cs:90\r\n   Orchard.Environment.DefaultOrchardHost.Orchard.Environment.IOrchardHost.EndRequest() in R:\\a\\Orchard\\src\\Orchard\\Environment\\DefaultOrchardHost.cs:59\r\n   Orchard.Web.MvcApplication.Application_EndRequest() in R:\\a\\Orchard\\src\\Orchard.Web\\Global.asax.cs:44\r\n\r\n[TargetInvocationException: Exception has been thrown by the target of an invocation.]\r\n   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0\r\n   System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71\r\n   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +350\r\n   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29\r\n   System.Web.Util.ArglessEventHandlerProxy.Callback(Object sender, EventArgs e) +42\r\n   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68\r\n   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75\r\n\r\n________________________________________\r\nVersion Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4016\r\n"}}