Details
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']"]
)