Comments

DanChadwick’s picture

Status: Active » Fixed

The teaser column was removed as part of update 7410. It therefore appears that you have not successfully restored your backup, or your backup does not contain SQL drop commands to cause the tables to be recreated.

If your goal is to end up with webform 7.x-3.x, then I would:
drush dis webform
drush pm-uninstall webform
drush dl webform-7.x-3.21
Make sure that you have ONLY one webform folder in all the various places that a module can be.
drush en webform
Restore your backup.

Anonymous’s picture

Thank you for spending so much time on this.

Actually I would much rather be at webform 4 and I wasn't too far off, just trashed my old webforms, was all.

I will try your recommendation to roll back again. The drush dl webform-7.x-3.21 did not work, it kept snapping back to 4.1 so I had to download and copy 3.21 to my contrib folder manually.

DanChadwick’s picture

With 4.x, make sure webform functionality is enabled for your desired content type(s) eg webform.

Anonymous’s picture

Thanks all your advice. i am going to swing through the webform 4 process one more time. What have I got to lose. If it fails again, I will go back to restoring 3.21

Status: Fixed » Closed (fixed)

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

Behzad’s picture

Issue summary: View changes

I have the same issue with webform-7.x-4.10 in mine Unknown column is 'progressbar_label_first'
I can't add new webform anymore.. Is this a upgrade path issue?

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'progressbar_label_first' in 'field list': INSERT INTO {webform} (nid, next_serial, confirmation, confirmation_format, redirect_url, status, block, allow_draft, auto_save, submit_notice, confidential, submit_text, submit_limit, submit_interval, total_submit_limit, total_submit_interval, progressbar_bar, progressbar_page_number, progressbar_percent, progressbar_pagebreak_labels, progressbar_include_confirmation, progressbar_label_first, progressbar_label_confirmation, preview, preview_next_button_label, preview_prev_button_label, preview_title, preview_message, preview_message_format, preview_excluded_components) 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, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29); Array ( [:db_insert_placeholder_0] => 4236 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => <confirmation> [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => [:db_insert_placeholder_12] => -1 [:db_insert_placeholder_13] => -1 [:db_insert_placeholder_14] => -1 [:db_insert_placeholder_15] => -1 [:db_insert_placeholder_16] => 1 [:db_insert_placeholder_17] => 0 [:db_insert_placeholder_18] => 0 [:db_insert_placeholder_19] => 1 [:db_insert_placeholder_20] => 1 [:db_insert_placeholder_21] => Start [:db_insert_placeholder_22] => Complete [:db_insert_placeholder_23] => 0 [:db_insert_placeholder_24] => [:db_insert_placeholder_25] => [:db_insert_placeholder_26] => [:db_insert_placeholder_27] => [:db_insert_placeholder_28] => [:db_insert_placeholder_29] => ) in drupal_write_record() (line 7327 of public_html/includes/common.inc).
DanChadwick’s picture

Yes. Some update didn't run properly. Are you sure you ran drush updatedb or visited update.php?

If you have, then at this point, your database is inconsistent. You will have to read all the update functions in install.php and either hand apply them or rewind your schema as stored in the system table so that you can run the updates.

Or restore the database to a consistent one and run update.

This will require some knowledge of PHP and the tables, columns, and indices in the database and how to adjust them.

joemcl’s picture

So I'm getting a very similar error and guessing the fix is the same as above. Error message is below.

Below is the complete error message I'm getting using Webform 7.x-4.10 with CiviCRM 4.6.8, Drupal 7. Trying to figure out what exactly is going on. I've created webforms successfully previously.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confidential' in 'field list': UPDATE {webform} SET next_serial=:db_update_placeholder_0, confirmation=:db_update_placeholder_1, confirmation_format=:db_update_placeholder_2, redirect_url=:db_update_placeholder_3, status=:db_update_placeholder_4, block=:db_update_placeholder_5, allow_draft=:db_update_placeholder_6, auto_save=:db_update_placeholder_7, submit_notice=:db_update_placeholder_8, confidential=:db_update_placeholder_9, submit_text=:db_update_placeholder_10, submit_limit=:db_update_placeholder_11, submit_interval=:db_update_placeholder_12, total_submit_limit=:db_update_placeholder_13, total_submit_interval=:db_update_placeholder_14, progressbar_bar=:db_update_placeholder_15, progressbar_page_number=:db_update_placeholder_16, progressbar_percent=:db_update_placeholder_17, progressbar_pagebreak_labels=:db_update_placeholder_18, progressbar_include_confirmation=:db_update_placeholder_19, progressbar_label_first=:db_update_placeholder_20, progressbar_label_confirmation=:db_update_placeholder_21, preview=:db_update_placeholder_22, preview_next_button_label=:db_update_placeholder_23, preview_prev_button_label=:db_update_placeholder_24, preview_title=:db_update_placeholder_25, preview_message=:db_update_placeholder_26, preview_message_format=:db_update_placeholder_27, preview_excluded_components=:db_update_placeholder_28 WHERE (nid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => 1501 [:db_update_placeholder_1] => Thanks for submitting the form! [:db_update_placeholder_2] => plain_text [:db_update_placeholder_3] => [:db_update_placeholder_4] => 1 [:db_update_placeholder_5] => 0 [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => 0 [:db_update_placeholder_8] => 1 [:db_update_placeholder_9] => 0 [:db_update_placeholder_10] => [:db_update_placeholder_11] => -1 [:db_update_placeholder_12] => -1 [:db_update_placeholder_13] => -1 [:db_update_placeholder_14] => -1 [:db_update_placeholder_15] => 1 [:db_update_placeholder_16] => 1 [:db_update_placeholder_17] => 1 [:db_update_placeholder_18] => 1 [:db_update_placeholder_19] => 1 [:db_update_placeholder_20] => Start [:db_update_placeholder_21] => Complete [:db_update_placeholder_22] => 0 [:db_update_placeholder_23] => [:db_update_placeholder_24] => [:db_update_placeholder_25] => [:db_update_placeholder_26] => [:db_update_placeholder_27] => filtered_html [:db_update_placeholder_28] => [:db_condition_placeholder_0] => 33 ) in drupal_write_record() (line 7316 of /var/www/[my website]/includes/common.inc).

joemcl’s picture

So running drush updatedb fixed the error. Thanks Dan for the post!