Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: CiviMail
    • Labels:
      None

      Description

      After updating from 1.8 to 1.9 stable I had the error below in step 3 (send) of CiviMail.
      I noticed that the column 'resubscribe_id' was missing in field civicrm_mailing. I made the setup by hand.
      I checked the update script 1.8->1.9 , there is no 'resubscribe_id' for civicrm_mailing.

      The error is gone, but I have another problem, wich I discus in the forum because I am not sure it is related to CiviCRM 1.9 (uodate).

      Error Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => UPDATE civicrm_mailing SET domain_id = 1 , reply_id = 7 , unsubscribe_id = 5 , resubscribe_id = 8 , optout_id = 6 , url_tracking = 1 , forward_replies = 1 , auto_responder = 1 , open_tracking = 1 WHERE ( civicrm_mailing.id = 82 ) [nativecode=1054 ** Unknown column 'resubscribe_id' in 'field list']
      [type] => DB_Error
      [user_info] => UPDATE civicrm_mailing SET domain_id = 1 , reply_id = 7 , unsubscribe_id = 5 , resubscribe_id = 8 , optout_id = 6 , url_tracking = 1 , forward_replies = 1 , auto_responder = 1 , open_tracking = 1 WHERE ( civicrm_mailing.id = 82 ) [nativecode=1054 ** Unknown column 'resubscribe_id' in 'field list']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_mailing SET domain_id = 1 , reply_id = 7 , unsubscribe_id = 5 , resubscribe_id = 8 , optout_id = 6 , url_tracking = 1 , forward_replies = 1 , auto_responder = 1 , open_tracking = 1 WHERE ( civicrm_mailing.id = 82 ) [nativecode=1054 ** Unknown column 'resubscribe_id' in 'field list']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              rupam Rupam Jaiswal
              Reporter:
              msn Martin Niewzwaag
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: