Posted by freakalis on November 1, 2010 at 2:38pm
3 followers
Jump to:
| Project: | Webform |
| Version: | 6.x-3.6 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
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
#1
Yeah, _fid and _old should be excluded entirely which should fix that problem.
#2
This has been fixed as a side-effect of #645388: Multistep forms: Save information after each step is completed.
#3
Automatically closed -- issue fixed for 2 weeks with no activity.