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
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.
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.
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.The statement has been terminated.
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:
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
Here's my config
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
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?
it may be related to the datepicker problems with 4.0.3. After applying the fix things are much smoother now
is working on a reply...