Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Paul Fowles 75 posts 184 karma points
    May 23, 2012 @ 13:01
    Paul Fowles
    0

    Unsubscribe users not working?

    Hi owen,

    Whenever, I try to unsubcribe a user from a subscription group using the campaign letter api methods I get an error telling me one of the tables in the database doesn't have the column UniqueId.   

    Copy Link
  • Paul Fowles 75 posts 184 karma points
    May 23, 2012 @ 13:05
    Paul Fowles
    0

    Invalid column name 'UniqueID'.

    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: Invalid column name 'UniqueID'.

    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): Invalid column name 'UniqueID'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073486
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064444
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) +299
   NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) +232

[GenericADOException: could not execute native bulk manipulation query:DELETE uwz_SubscribeItem WHERE UniqueID = :id AND EmailAddress=:email[SQL: DELETE uwz_SubscribeItem WHERE UniqueID = @p0 AND EmailAddress=@p1]]
   NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session) +368
   NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters) +287
   NHibernate.Impl.SqlQueryImpl.ExecuteUpdate() +109
   uWebZone.CampaignLetters.Services.library.UnSubscribe(String email, Guid subscribeType) +239
   uWebZone.CampaignLetters.Services.library.UnSubscribe(String email) +372
   umbracoUserControl.unsubscribeWebUserControl.Button1_Click(Object sender, EventArgs e) +52
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
   System.Web.UI.WebControls.Button.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) +5563

    Copy Link
  • Paul Fowles 75 posts 184 karma points
    May 23, 2012 @ 13:18
    Paul Fowles
    0

    It failing on this line in the stack trace

    [GenericADOException: could not execute native bulk manipulation query:DELETE uwz_SubscribeItem WHERE UniqueID=:id AND EmailAddress=:email[SQL: DELETE uwz_SubscribeItem WHERE UniqueID=@p0 AND EmailAddress=@p1]]

    However uwz_SubscribeItem table doesn't have a column named UniqueId but one named SubscribeTypeUniqueId with the relevant data which is needed for both subscribe methods(which work perfectly) and to view the TestGroup data in the backend of umbraco in the Campaign leter tab.

    I'm using the current downloaded beta version of Campaign letter on here with umbraco 4.7.1.1

    Am I using the unsubscribe methods wrong? 

    Regards

     Paul Fowles


    Copy Link
  • Paul Fowles 75 posts 184 karma points
    May 23, 2012 @ 15:51
    Paul Fowles
    0

    I've come up with a  solution with adding a computed column specification called UniqueId which takes the data from SubscribeTypeUniqueId to uwz_SubscribeItem table

    Regards

    Paul 

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft