Duplicate key error, but no record in database

1. Created table using phpMyAdmin
2. Created ChronoForm
3. Set DB connection to table, but failed to Enable Data Storage.
4. Tested Form
5. Checked phpMyAdmin - no records
6. Enabled Data Storage on form
7. Tested Form
Result: mySQL Duplicate Key error message. No records appear in phpMyAdmin, but a record appears with no data under Forms Management - Tables Connected.

Tried: Turned Enable Data Storage on/off/on, Connected to a different table, Changed primary key field in table.

Suggestions?

Many thanks.

Hi blindman,

try to create a new table wit ha new name, don't change any thing in the table creation screen except the new name, now connect o the new table and ignore the old one, what happens?

Regards
Max

Thanks, Max. I had already tried creating another table and connecting to it, but I see now that I left out a chrono-required field.

For those of you following along with large tables to create manually, be sure to include all of the following fields:
`cf_id` int(11) NOT NULL auto_increment,
`uid` varchar(255) NOT NULL,
`recordtime` text NOT NULL,
`ipaddress` text NOT NULL,
`cf_user_id` text NOT NULL,

Thanks again. This is an excellent tool and I would encourage newbies (like me) to hang in there.

great!

Regards
Max