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;
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😉
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.
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.
This topic is locked and no more replies can be posted.