Closed (fixed)
Project:
Webform
Version:
7.x-3.18
Component:
Miscellaneous
Priority:
Major
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
3 Aug 2012 at 11:04 UTC
Updated:
18 Jun 2013 at 03:07 UTC
It is impossible to fill out forms after upgrading from 7.x-3.13 to 7.x-3.18 due to maximum submission limits.
Upgrades executed by drupal:
Result:
Notice: Undefined variable: output in ctools_var_export() (line 837 of /sites/all/modules/contrib/ctools/includes/export.inc).node/[nid]/webform/configure and setting the TOTAL SUBMISSIONS LIMIT to 'unlimited' (as it is set to an emtpty limit by default) a PHP notices are displayed and a PDO exception is thrown:Notice: Undefined index: total_submit_limit in webform_configure_form() (line 96 of /sites/all/modules/contrib/webform/includes/webform.pages.inc).
Notice: Undefined index: total_submit_limit in webform_configure_form() (line 103 of /sites/all/modules/contrib/webform/includes/webform.pages.inc).
Notice: Undefined index: total_submit_limit in webform_configure_form() (line 103 of /sites/all/modules/contrib/webform/includes/webform.pages.inc).
Notice: Undefined index: total_submit_interval in webform_configure_form() (line 114 of /sites/all/modules/contrib/webform/includes/webform.pages.inc).
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'total_submit_limit' in 'field list': UPDATE {webform} SET confirmation=:db_update_placeholder_0, confirmation_format=:db_update_placeholder_1, redirect_url=:db_update_placeholder_2, status=:db_update_placeholder_3, block=:db_update_placeholder_4, teaser=:db_update_placeholder_5, allow_draft=:db_update_placeholder_6, auto_save=:db_update_placeholder_7, submit_notice=:db_update_placeholder_8, submit_text=:db_update_placeholder_9, submit_limit=:db_update_placeholder_10, submit_interval=:db_update_placeholder_11, total_submit_limit=:db_update_placeholder_12, total_submit_interval=:db_update_placeholder_13 WHERE (nid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => [:db_update_placeholder_1] => page_content [:db_update_placeholder_2] => <confirmation> [:db_update_placeholder_3] => 1 [:db_update_placeholder_4] => 0 [:db_update_placeholder_5] => 0 [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => 0 [:db_update_placeholder_8] => 1 [:db_update_placeholder_9] => [:db_update_placeholder_10] => -1 [:db_update_placeholder_11] => -1 [:db_update_placeholder_12] => -1 [:db_update_placeholder_13] => -1 [:db_condition_placeholder_0] => 53 ) in drupal_write_record() (line 6868 of /includes/common.inc).webform_update_7316() does somehow not get executed properly since the two new columns in there are not added to the webform table!Solution to fix your immediate problem if you have this case, is executing these SQL queries:
alter table webform add column total_submit_limit int default -1;
alter table webform add column total_submit_interval int default -1;
Solution to fix the module:
To be determined
Comments
Comment #1
quicksketchThanks. I can't see any problem with our existing code and testing the upgrade works fine for me. The code is quite clear:
Are you just using MySQL (not PostGres or something else)?
Had you tried at a previous time to upgrade Webform module to a newer version previously? Perhaps the 7316 update had been run previously but not entirely reverted.
Comment #2
Dirt2274 commentedhelp, I am a noob, and having the above issue that one of my webforms says "You may not submit another entry at this time." can't figure out why? can someone help,PLEASE
Comment #3
parrapa commentedThe same problem for me.
Comment #4
parrapa commentedWebform >> Form settings >> Per user submission limit (Change from 0 to 10 per day)
This is what I did and now is ok.
Comment #5
quicksketchThe original poster hasn't posted back here and subsequent users seem to have figured this issue out. I'm marking this fixed.