Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Got the below error while updating Webform configuration.
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'progressbar_page_number' at row 1: INSERT INTO {webform_steps_w3_progressbar} (nid, progressbar_bar, progressbar_page_number, progressbar_percent, progressbar_pagebreak_labels, progressbar_label_first) 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); Array ( [:db_insert_placeholder_0] => 822070 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => Start ) in webform_steps_w3_node_insert() (line 44 of /home/portaladmindevli/public_html/sites/all/modules/webform_steps/webform_steps_w3/webform_steps_w3.module).
To regenerate you should install "webform_steps" and its sub module "webform_steps_w3" as usual any other Drupal contributed module. Then, create a webform and go to its configure page something similar to [node/xxxx/webform/configure].
There on "PROGRESS BAR" section just do not check the "Show page number as number of completed (i.e. Page 1 of 10)" option and submit the configurations.
| Comment | File | Size | Author |
|---|---|---|---|
| #9 | 2856187-convert-boolean-for-db-9.patch | 653 bytes | torotil |
| #2 | fatalerrwhenupdatingwebformconfig-2856187-2.patch | 8.35 KB | shobhit_juyal |
| webform_steps_w3--issue.jpg | 148.73 KB | shobhit_juyal |
Comments
Comment #2
shobhit_juyal CreditAttribution: shobhit_juyal commentedThere on line 44 in "webform_steps_w3.module" if we could change the sequence of parameters then it will fix this issue. Please find the patch as it worked for me.
Comment #3
shobhit_juyal CreditAttribution: shobhit_juyal commentedComment #4
pbattino CreditAttribution: pbattino commentedI had the same problem, but I think it's caused by the webform_steps_w3 which is a "compatibility module", it can be disabled once you have imported progressbar settings stored by it.
I did it: admin/config/content/webform (the section "Progress bar migration" is at the top of the page)
And the problem disappeared.
Comment #5
akash.deep CreditAttribution: akash.deep commentedI faced the same problem. webform_steps_w3 is not required if you dont have to do the migration from W3 to W4, so I just disabled it and it worked well.
Comment #6
pbattino CreditAttribution: pbattino commentedComment #7
M@ster CreditAttribution: M@ster commentedStill have this error. Just open default settings and save.
Invalid datetime format: 1366 Incorrect integer value: '' for column `webform_steps_w3_progressbar`.`progressbar_page_number` at row 1: UPDATE {webform_steps_w3_progressbar} SET ....Comment #8
PetarB CreditAttribution: PetarB commentedSame experience on a clean site.
Tried uninstalling Steps, still got the error, referring to the module.
The Fix:
The only way I could get rid of the issue and configure my Webforms was to remove the module's folder from the codebase entirely.
Comment #9
torotil CreditAttribution: torotil commentedHere is a patch that should resolve the issue.
I’d still recommend to disable webform_steps_w3 soon after upgrading as it is only needed for webform3 backward compatibility.
Comment #10
torotil CreditAttribution: torotil commentedI just released #9 in version 2.4.