Incompatibility with Modal Forms [#2824728]

Trying to use WPD with Bounce Convert which uses Modal Forms and when hitting the submit button, it throws an error:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /modal_forms/ajax/webform/133
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry &#039;9&#039; for key &#039;PRIMARY&#039;: INSERT INTO {wpd_access_hashes} (sid, hash, processed, expires, used) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array
(
[:db_insert_placeholder_0] =&gt; 9
[:db_insert_placeholder_1] =&gt; 937b90f6267bfde63ff57e7f5872e4d3
[:db_insert_placeholder_2] =&gt; 1478200354
[:db_insert_placeholder_3] =&gt; 1478805154
[:db_insert_placeholder_4] =&gt; 0
)
in drupal_write_record() (line 7376 of /home/XXXXXX/public_html/includes/common.inc).

Comment	File	Size	Author
#11	webform_protected_downloads_2824728_2.patch	1.9 KB	dtamajon
#10	webform_protected_downloads_2824728.patch	1.97 KB	dtamajon
#4	wpd_modal_form_fix.patch	1.06 KB	LChun

Comments

Comment #1

3 November 2016 at 19:11

marty.true created an issue. See original summary.

Comment #2

marty.true commented 3 November 2016 at 19:13

Issue summary:

View changes

Comment #3

solardog commented 21 March 2017 at 21:51

I am having the same issue. I did not change anything on my end and the error has seemingly come out of the blue. Greengeeks shared hosting suggested an issue with my PHP version (currently 5.6). I tried PHP 7 but no joy.

Anyone have any idea what might be causing this issue?

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /modal_forms/ajax/webform/45
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry &#039;1101&#039; for key &#039;PRIMARY&#039;: INSERT INTO {wpd_access_hashes} (sid, hash, processed, expires, used) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array
(
[:db_insert_placeholder_0] =&gt; 1101
[:db_insert_placeholder_1] =&gt; a1490ac40caf43fb4014cd6b5aeaa09d
[:db_insert_placeholder_2] =&gt; 1490104829
[:db_insert_placeholder_3] =&gt; 1490364029
[:db_insert_placeholder_4] =&gt; 0
)
in drupal_write_record() (line 7383 of /home/xxxxxxx/public_html/includes/common.inc).

Comment #4

LChun commented 4 July 2017 at 11:39

Status	File	Size
new	wpd_modal_form_fix.patch	1.06 KB

I've had the same problem with this module and modal forms. I'm not sure where the true issue lies, but I created a workaround patch.

It seems that somehow the submission process for this module is being run twice, creating the duplicate entry. I've added a function to stop it running the second time.