I am using Commerce Kickstart 2.x. It seems that they are not using body_summary in field_data_body and field_revision_body, which makes provision fail on migration or restore task in deploy_d7.inc, because it tries to update the field without checking whether it is present.

Related to #1681570: No column body_summary in Kickstart v2?

Comments

lsolesen’s picture

lsolesen CreditAttribution: lsolesen commented
Status: Active » Fixed

Seems to be fixed in HEAD, but just not included with BOA.

lsolesen’s picture

lsolesen CreditAttribution: lsolesen commented
Project: Provision » Barracuda
Version: 6.x-1.9 »
Category: bug » feature
Status: Fixed » Active

Moving to Barracuda to get the latest provision included, so this error will disappear.

omega8cc’s picture

omega8cc CreditAttribution: omega8cc commented
Category: feature » support
Status: Active » Postponed (maintainer needs more info)

Not sure what you mean? I think this code was never included in Provision, only in the Provision fork we are using in BOA. Anyway, please provide more details, with errors reported in tasks and please follow bug submission guidelines.

omega8cc’s picture

omega8cc CreditAttribution: omega8cc commented
Project: Barracuda » Octopus
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

We have tested this from Commerce Kickstart 1.0-rc7 to Commerce 1.9.1 and there are no issues like reported, so closing.

7wonders’s picture

7wonders CreditAttribution: 7wonders commented
Status: Closed (cannot reproduce) » Active

I just got this problem with commerce_kickstart-7.x-2.x-dev on my test environment. Basically if trying to migrate (i was just trying to rename my dev site) it fails with:

WD php: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'body_summary' in 'field list': UPDATE {field_data_body} SET body_summary = REPLACE(body_summary, :old, :new); Array ( [:old] => sites/$old_url [:new] => sites/$new_url ) in include_once() (line 31 of /data/disk/o1/.drush/provision/platform/drupal/deploy_7.inc).

Ive put back to active as it may not be a major problem now as commerce_kickstart 2 isnt an official package yet but im sure it will be :)

lsolesen’s picture

lsolesen CreditAttribution: lsolesen commented

I altered deploy_7.inc manually checking whether the field is available before making changes to it:

if (db_table_exists('field_data_body')) {
  db_query("UPDATE {field_data_body} SET body_value = REPLACE(body_value, :old, :new)", array(':old' => 'sites/$old_url', ':new' => 'sites/$new_url'));
  db_query("UPDATE {field_data_body} SET body_value = REPLACE(body_value, :old, :new)", array(':old' => 'sites/default', ':new' => 'sites/$new_url'));
  if (db_field_exists('field_data_body', 'body_summary')) {
    db_query("UPDATE {field_data_body} SET body_summary = REPLACE(body_summary, :old, :new)", array(':old' => 'sites/$old_url', ':new' => 'sites/$new_url'));
    db_query("UPDATE {field_data_body} SET body_summary = REPLACE(body_summary, :old, :new)", array(':old' => 'sites/default', ':new' => 'sites/$new_url'));
  }
}

if (db_table_exists('field_revision_body')) {
  db_query("UPDATE {field_revision_body} SET body_value = REPLACE(body_value, :old, :new)", array(':old' => 'sites/$old_url', ':new' => 'sites/$new_url'));
  db_query("UPDATE {field_revision_body} SET body_value = REPLACE(body_value, :old, :new)", array(':old' => 'sites/default', ':new' => 'sites/$new_url'));
  if (db_field_exists('field_revision_body', 'body_summary')) {
    db_query("UPDATE {field_revision_body} SET body_summary = REPLACE(body_summary, :old, :new)", array(':old' => 'sites/$old_url', ':new' => 'sites/$new_url'));
    db_query("UPDATE {field_revision_body} SET body_summary = REPLACE(body_summary, :old, :new)", array(':old' => 'sites/default', ':new' => 'sites/$new_url'));
  }
}
omega8cc’s picture

omega8cc CreditAttribution: omega8cc commented
Category: support » bug
Status: Active » Fixed

Fix committed in http://drupalcode.org/sandbox/omega8cc/1074910.git/commit/7daaed3

Thanks!

Status: Fixed » Closed (fixed)

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

fhdrupal’s picture

fhdrupal CreditAttribution: fhdrupal commented

Get this error when saving products, PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'body_summary' in 'field list'. I have got latest Commerce Kickstart, it happened when I enabled a few fields modules came with it. any help please.

fhdrupal’s picture

fhdrupal CreditAttribution: fhdrupal commented

Has anyone got the solution for that yet?

omega8cc’s picture

omega8cc CreditAttribution: omega8cc commented

@fhdrupal As far as I know, this issue has been fixed a long time ago. Please open new issue with proper report and all required details *if* you experience it on the latest BOA version.

omega8cc’s picture

omega8cc CreditAttribution: omega8cc commented

@fhdrupal Also, your issue sounds completely unrelated here.

fhdrupal’s picture

fhdrupal CreditAttribution: fhdrupal commented

I am sorry, it may not be exactly the same issue but, I am getting the same error when I save products contents. I checked the deploy_7.inc given in the patch but, cant find where it is.

fhdrupal’s picture

fhdrupal CreditAttribution: fhdrupal commented
Issue summary: View changes

Added related issue.