Upgrade 4.1.6 to 4.2.14 Mailing groups not saved

[Neil Adair]

Upgrading a Drupal 7 site to CiviCRM 4.2.14 has resulted in CiviMail "Include Groups" not being saved when "Save and Continue Later" is used.

Errors
Undefined index: civicrm_group in CRM_Mailing_Form_Group->setDefaultValues() (line 114 of /sites/all/modules/civicrm/CRM/Mailing/Form/Group.php).

Undefined variable: composeParams in CRM_Mailing_Form_Upload->postProcess() (line 418 of /sites/all/modules/civicrm/CRM/Mailing/Form/Upload.php).

Mailings which are completed and queued for sending are sent to the Include Group so it's not a show stopper but annoying. It seems something was missed during the upgrade although there were no errors at the time.

[Shai]

Neil,

Can you get access to the database. Of course backup before you do anything.

In the civicrm_group table the "id" field is the primary key.

The "name" and "title" fields are both unique keys.

See what is there. Try setting the ID field as a primary key (if it isn't already) and see if you still get the error.

Best,

Shai

[Eileen]

4.2.14 seems an odd choice - the latest LTS is 4.2.16  - but actually I think if you are upgrading from 4.1 you should go to 4.4 - I would recommend the LTS for people on 4.2 who aren't able to upgrade at this stage.

[Neil Adair]

Shai

The "id" field is indeed the primary key for civicrm_group table, "name" is a unique key and "title" has 2 title_en_US and title_fr_CA

Wouldn't this error be in the civicrm_mailing tables? I'm not seeing any problems with groups themselves.

Eileen

I inherited this and it was a Drupal 6 to 7 upgrade with CiviCRM 4.1.5 which I upgraded to 4.1.6 with no issues.
The CiviCRM 4.2 upgrade posed issues with schema integrity and duplicate contribution/membership data which I needed to resolve before the upgrade script would run.
It is a multilingual install. I intend to go to 4.2.16 once this issue is resolved but I won't upgrade further until the next LTS version is set. 4.4 or 4.5?

Thanks

Neil