Updating an installation and have received this error. I was able to replicate (twice) with an import of the database and site files prior to the update.

heartbeat_plugins module

Update #7003
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'in_group' doesn't exist in table: ALTER TABLE {heartbeat_activity} ADD INDEX `group_language_timestamp` (`in_group`, `language`, `timestamp`); Array ( ) in db_add_index() (line 2912 of /home/xxxxxxx/public_html/xxxxxxx.com/xxxxx/includes/database/database.inc).

Drupal version 2.12 (encountered this before updating to 2.22).

I'm not familiar with the syntax of the error. Is this telling me to modify the database in order to repair the issue? Also, should I not update to 1.1 until a better fix is offered?

And please let me know any extra information I can provide. I currently have two sites set up: one with the before and one after the upgrade.

Comments

dweade’s picture

dweade CreditAttribution: dweade commented

Update: Updated to Drupal 7.22 and all modules, leaving only Heartbeat not updated. Applied update and received same error when updating database:

Update #7003
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'in_group' doesn't exist in table: ALTER TABLE {heartbeat_activity} ADD INDEX `group_language_timestamp` (`in_group`, `language`, `timestamp`); Array ( ) in db_add_index() (line 2941 of /home/xxxxxx/public_html/xxxxxxx.com/xxxxxx/includes/database/database.inc).