Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • dandrayne 1138 posts 2262 karma points
    Mar 18, 2010 @ 18:32
    dandrayne
    0

    Many nested folders created

    General

    Hi Chris

    I'm using autofolders in a site that we're working on at the minute, and seem to have misconfigured something along the way.  Basically, when create a news item many nested folders get created until I get the following error message

    Server Error in '/' Application.

    String or binary data would be truncated.
    The statement has been terminated.

    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: String or binary data would be truncated.
    The statement has been terminated.

    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): String or binary data would be truncated.
    The statement has been terminated.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
       System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +56
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +83
       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:64
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:217

    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:221
       umbraco.cms.businesslogic.CMSNode.set_Path(String value) +108
       umbraco.cms.businesslogic.CMSNode.Move(Int32 NewParentId) +299
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +187
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.businesslogic.web.Document.Publish(User u) +4
       AutoFolders.ApplicationBase.Document_New(Document sender, Object e) +205
       umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) +27
       umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +1108
       umbraco.cms.presentation.editContent.Publish(Object sender, EventArgs e) +177
       System.EventHandler.Invoke(Object sender, EventArgs e) +0
       umbraco.controls.ContentControl.savePublish(Object Sender, ImageClickEventArgs e) +46
       System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +108
       System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +118
       System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

    Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082

     

    Here's my config

       <folderProvider alias="DateFolderProviderNews"
                assembly="/bin/AutoFolders"
                type="AutoFolders.Providers.DateFolderProvider">
          <property alias="MonthFormat">MMMM</property>
          <property alias="YearFormat">yyyy</property>
        <property alias="DateField">newsDate</property>
        </folderProvider>

       <autoFolder docType="NewsItem"
                 folderProviderAlias="DateFolderProviderNews"
                 folderDocType="DateFolder" 
                 />


    And here's a screenshot http://imgur.com/YUvJO

    Have you seen anything like this before? The configuration is using pretty simple settings so I'm not entirely sure where it could have gone amiss

    Setup :  umb 4.0.3, IIS 6, .net 3.5, autofolders 2.0.2

    Cheers,
    Dan

    Copy Link
  • dandrayne 1138 posts 2262 karma points
    Mar 22, 2010 @ 11:20
    dandrayne
    0

    THere also seems to be some confusion between UK and US date formats?  When using uk date format in the admin (e.g. 2010-02-12 as 12th February 2010) autofolders actually created two copies of my node, placing one in both the "December" folder and the "February" folder.

    Any idea as to why this might be happening?

    Copy Link
  • dandrayne 1138 posts 2262 karma points
    Mar 22, 2010 @ 17:35
    dandrayne
    0

    it may be related to the datepicker problems with 4.0.3.  After applying the fix things are much smoother now

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft