Closed (fixed)
Project:
Webform
Version:
6.x-3.6
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
1 Nov 2010 at 14:38 UTC
Updated:
10 Mar 2011 at 07:11 UTC
If you have a webform file component that is not required and the user submit the webform a Mysql Duplicate entry will appear.
Ex.
Duplicate entry '87-1274-17-0' for key 'PRIMARY' query: INSERT INTO webform_submitted_data (nid, sid, cid, no, data) VALUES (87, 1274, 17, '_old', '')
Duplicate entry '87-1274-17-0' for key 'PRIMARY' query: INSERT INTO webform_submitted_data (nid, sid, cid, no, data) VALUES (87, 1274, 17, '_fid', '')
That's because it tries to add _old & _fid to the no column that is numeric. Mysql converts them both into 0 and the duplicate entry error appears.
It works when a file is added but not when it's empty. But webform should not try to add _fid and _old to the database or am im wrong?
Comments
Comment #1
quicksketchYeah, _fid and _old should be excluded entirely which should fix that problem.
Comment #2
quicksketchThis has been fixed as a side-effect of #645388: Multistep forms: Save information after each step is completed.