We are using cTools 7.x-1.9 and Form Builder 7.x-1.13 and receive the error below when running the DB updates.
It doesn't seem to impact the site. What should be the best way forward? Any advice on how to get past the error message?

form_builder module
Update #7002
Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'jgPuvUTTrQGj1GYJhQ_ZHNGjvhmfTiUSoXXnNI-maBw-webform:140-form_bui' for key 'PRIMARY': INSERT INTO {ctools_object_cache} (sid, name, obj, updated, data) SELECT sid, 'form_builder_cache', CONCAT(type, ':', form_id), updated, data FROM {form_builder_cache};

Could be related to https://www.drupal.org/node/2543800?

Comments

seanB created an issue. See original summary.

mordonez’s picture

mordonez commented

Same problem here

torotil’s picture

torotil commented

To debug that I'd need a database dump of the form_builder_cache table from before the attempted upgrade.

torotil’s picture

torotil commented
Status: Active » Postponed (maintainer needs more info)
seanb’s picture

seanb
Primary language Dutch
Location Netherlands
commented

I just emptied the form_builder_cache table in the end. This solved the issue. The cache was just rebuilt for the form when you edit them.

  • torotil committed be66c51 on 7.x-1.x 
    Issue #2665706: Make sure there is only one row for each primary key in...
torotil’s picture

torotil commented

I've updated the query in form_builder_update_7002() so we can be sure there is only one entry per sid/type/form_id. The old form_builder_cache table did not have a primary key o_O.

torotil’s picture

torotil commented
Status: Postponed (maintainer needs more info) » Fixed

Status: Fixed » Closed (fixed)

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