Database Table Save Fails - Duplicate Entry

Resolve duplicate entry errors when saving form submissions to a database.

Overview

The issue occurs because the form is incorrectly reusing the same primary key ID for multiple submissions.
Adjust the form's database save action settings to ensure the primary key field is set to auto-increment or is generated uniquely for each submission.

Answered
ly lydianp18 10 Jul, 2015
Ok - for some reason it will only save the first submission to the database, any others we get the following message:

Duplicate entry '98' for key 'PRIMARY' SQL=INSERT INTO `j25_chronoengine_chronoforms_datatable_ktside_july` (`id`, `first_name`, `last_name`, `mail`, `phone`, `message`, `captcha`, `list`, `button9`, `user_id`, `uniq_id`, `created`) values ('98', 'Test', 'case2', 'me@lydianp.com', '555-555-1212', 'test', '', '2089398730', 'Submit', '0', '1227c24c16960ab090b91ccd7757b147e5ad80ef', '2015-07-10 02:56:12');



The table was created through chronoforms. I've never had a problem before in any other version of Chronoforms.

The settings are below:
Gr GreyHead 10 Jul, 2015
Answer
Hi lydianp18,

Please see this FAQ - looks like a problem with the article id

Bob
This topic is locked and no more replies can be posted.