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


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

    [Newsletter Studio] Error after upgrade

    Comments
    Umbraco 7

    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 1911 posts 5757 karma points MVP 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 1911 posts 5757 karma points MVP 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
Please Sign in or register to post replies

Write your reply to:

Draft