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

    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

  • 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?

  • 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

Please Sign in or register to post replies

Write your reply to:

Draft