Copied to clipboard

Flag this post as spam?

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


  • Michéle Johl 1 post 71 karma points
    Mar 01, 2016 @ 13:17
    Michéle Johl
    0

    Unable to Install > ALTER TABLE ALTER COLUMN Email failed because one or more objects access this column.

    We are using Umbraco 7.3 and after loading the package for Newsletter Studio 2.1 the studio displays errors.

    As we will be using this package for all our clients we require to resolve this issue rather urgently.

    From the Log: 2016-03-01 09:21:17,836 [P6484/D6/T13] ERROR umbraco.DataLayer.SqlHelper1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query ALTER TABLE ns_TrackingItems ALTER COLUMN Email nvarchar(MAX) NOT NULL System.Data.SqlClient.SqlException (0x80131904): The index 'NCI_TrackingItems_Email1' is dependent on column 'Email'. ALTER TABLE ALTER COLUMN Email failed because one or more objects access this column. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelper1.ExecuteNonQuery(String commandText, IParameter[] parameters)

Please Sign in or register to post replies

Write your reply to:

Draft