Creating a Table

Resolve a ChronoForms table creation error.

Overview

The issue occurs when saving a new table in CF, often due to an incorrect primary key setting.
First, ensure the primary key is set to the default 'cf_id'. If the error persists, copy the MySQL query from CF into PHPMyAdmin, replace the table prefix, and execute it there to identify and fix the specific database error.

Answered
ha hayes121 19 Jun, 2014
Hi there, I have been trying to make a table for one of my forms, I have made two tables already without any problems but when i do the same steps and clickt save table i get the following error, Does anyone know what im doing wrong?
Gr GreyHead 20 Jun, 2014
Hi hayes121,

The only possible problem I can see is the Primary Key `name` at the end, I'd suggest you try leaving the Primary Key as the default `cf_id`.

Bob
ha hayes121 23 Jun, 2014
Even after leaving the primary key to 'cf_id' i tstill get the same problem
Gr GreyHead 23 Jun, 2014
Answer
1 Likes
Hi hayes121,

Then I would copy and paste the MySQL query into PHPMyAdmin to see if it succeeds there or if you get a more helpful error message.

Note: you need to replace #_ in the table name with the correct prefix in PHPMyAdmin.

Bob
ha hayes121 24 Jun, 2014
Thanks Bob! I got it to work, took a little while to get it through PHPMyAdmin but all sorted now!
This topic is locked and no more replies can be posted.