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


  • Simon Justesen 74 posts 193 karma points
    Aug 06, 2016 @ 09:23
    Simon Justesen
    0

    [Newsletter Studio] Error after upgrade

    I get this database error after upgrading to 2.1.4 - tried reinstalling to no avail. Anyone knows how to fix this?

    NewsletterStudio, SendNewsletterService: Invalid column name 'CustomData'. : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at NewsletterStudio.Infrastucture.Data.PetaPoco.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco) at NewsletterStudio.Infrastucture.Data.PPDatabaseAdaptor.Insert(String tableName, String primaryKeyName, Object obj) at NewsletterStudio.Infrastucture.Data.EmailTrackingItemRepository.Save(EmailTrackingItem emailTrackingItem) at NewsletterStudio.Services.EmailTrackingItemService.CreateTrackingItems() at NewsletterStudio.Services.SendNewsletterService.SendEmails() You can try to continue to send the newsletter by going to the "Send options" and follow the instructions.

    Thanks,
    Simon

    Copy Link
  • Markus Johansson 1945 posts 5898 karma points MVP 2x c-trib
    Aug 06, 2016 @ 09:35
    Markus Johansson
    100

    Hi!

    Thanks for using the package!

    Something probably went wrong during the install.

    Have a look at this thread, there is a sql-statement that you can use: https://our.umbraco.org/projects/backoffice-extensions/newsletter-studio/comments/57181-CustomData-column-update-v200-to-v210

    Hope this helps!

    / m

    Copy Link
  • Simon Justesen 74 posts 193 karma points
    Aug 11, 2016 @ 00:33
    Simon Justesen
    0

    That helped - thx Markus!

    One thing to note though: When I applied the SQL fix and clicked to send a test mail, the newsletter system decided to send out the mails it had in queue before the error showed up. Maybe it is a good idea to put in some kind of safeguard, so that the mail queue gets deleted if an exception is thrown - if possible?

    Copy Link
  • Markus Johansson 1945 posts 5898 karma points MVP 2x c-trib
    Aug 11, 2016 @ 07:56
    Markus Johansson
    0

    Hi!

    Great to hear!

    Thanks for the feedback. Sorry for your issues, we'll see what we can do about that.

    Cheers!

    // m

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies