Trying to update the metatag module and I'm getting an error in the DB Update process, which prevents the other updates from running:

Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'revision_id' in 'where clause': UPDATE {metatag} SET revision_id = 0 WHERE revision_id IS NULL; Array ( ) in metatag_update_7016()

Looking in the table {metatag}, I don't have a revision_id column. The only columns that exist are entity_type, entity_id, data, and language.

CommentFileSizeAuthor
#3 metatag-n2175843-3.patch1.49 KBdamienmckenna
#2 metatag-n2175843-2.patch1.39 KBdamienmckenna

Comments

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

What version of Metatag were you using before you upgraded?

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Version: 7.x-1.0-beta8 » 7.x-1.x-dev
Status: Active » Needs review
StatusFileSize
new metatag-n2175843-2.patch1.39 KB

Does this solve the problem?

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
StatusFileSize
new metatag-n2175843-3.patch1.49 KB

Oopsie, the field should be added if it does not already exist. Duh.

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Status: Needs review » Fixed

Committed.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

Machiaveliant’s picture

Machiaveliant commented

Hey guys,

I am also having this error when updating to 7.x-1.0-beta9 from 7.x-1.0-beta7. The update for creating the 'revision_id' column is not being run.

Cheers

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

@Machiaveliant: Lets continue this discussion in #2177455: Updates not running correctly when updating to beta9