Forums

clean install of chronoforms v5 and can't create a table...getting the following error

1103 Incorrect table name 'wrdsw_chronoengine_chronoforms_datatable_CatalyzeConversationsSignup' SQL=CREATE TABLE IF NOT EXISTS `wrdsw_chronoengine_chronoforms_datatable_CatalyzeConversationsSignup` ( `id` INT(11) NOT NULL auto_increment, `uniq_id` VARCHAR(50) NOT NULL, `user_id` INT(11) NOT NULL, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME DEFAULT NULL, `firstname` VARCHAR(255) NOT NULL, `LastName` VARCHAR(255) NOT NULL, `Email` VARCHAR(255) NOT NULL, `Phone` VARCHAR(255) NOT NULL, `captcha` VARCHAR(255) NOT NULL, `button6` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8;

Hello steve@t3living.com,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How can I edit my database table and debug queries?
How do I save form data to a database table?
How can I select 'types' in a database table?
How to load record data from a database table into your form
How can I edit a record from a database table?
How can I add a new column to a database table or change a column type?
How to create a table for my form
P.S: I'm just an automated service😉

Hi steve,

The name is too long - I think that the maximum is 64 characters and that is 69. I'd change it to wrdsw_cf_CatalyzeConversationsSignup

Bob

PS I suggest that you don't use your email as a user name here as it is publicly visible and may be scraped and misused. PM me or use the Contact Us menu above if you want to change it.