I get this error when ever i save products. Products won't save due to this error. Please help.
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'body_summary' in 'field list':
INSERT INTO {field_revision_body} (entity_type, entity_id, revision_id, bundle, delta, language, body_value, body_summary, body_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 30 [:db_insert_placeholder_2] => 30 [:db_insert_placeholder_3] => tops [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => text [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => full_html ) in field_sql_storage_field_storage_write()
(line 452 of /home/mysite/public_html/subfolder/modules/field/modules/field_sql_storage/field_sql_storage.module).

Comments

bojanz’s picture

I just closed your issue: #1905410: Undefined property $body_summary, why are you opening another one?
One of the modules / features you installed is causing this error by relying on a non-existent field.

fhdrupal’s picture

I haven’t installed any new modules, just enabled a few fields modules provided by kickstart. What might have caused that? But now I uninstalled them but the problem still exist now. Any help would be appreciated.

fhdrupal’s picture

Is there no solution for that error? Because I cant save products at all. Can I add a field to the database manually? Is that no issue at with someone? Because I installed kickstart twice but, when I start to make new products types, and enable a few core modules I get this error and application stop working. what should I do, any suggestion, Please?

bojanz’s picture

Which modules did you enable? I can't reproduce the problem, so it's hard for me to help.
I need a detailed list of steps you took.

fhdrupal’s picture

Thanks for response. What happened that, I created new product type, but products added to new type won't show summery and read more button. I changed some of the fields display settings, but didn't work. Checked modules and enabled all fields modules, I thought may be that will help. Don't remember exactly which modules caused that issue.

fhdrupal’s picture

I installed it from the scratch, but again after creating product types I got the same problem.

fhdrupal’s picture

It was very much disappointed that no one actually tried to find any solution or suggest anything from commerce guys. I found a kind of manual solution which did worked form me. I could have done that long before, but I was hesitating for future updates could be affected with manual action. Now I wanted to share that with community.

The problem comes, when you install some other core modules for additional functionality mostly related to fields. Some of these additional modules require having "body_summary" column be added to "field_data_body and field_revision_body" tables. I added the column to these tables, following this format "type=longtext Null=yes" and it worked for me at the movement. Sorry went long a bit, but the explanation is long.

This seems to me is a bug in the commerce kickstart package, that need to be address in new versions, to allow installation of core modules.

Related to : No column body_summary in Kickstart v2?

bojanz’s picture