error message when trying to create table

Hi Im getting the following error message when tring to create a table for my form:


Check table query below:

CREATE TABLE IF NOT EXISTS `#__chronoforms_data_Booking ` ( `cf_id` INT(11) auto_increment, `cf_uid` VARCHAR(255), `cf_created` DATETIME, `cf_modified` DATETIME, `cf_ipaddress` VARCHAR(255), `cf_user_id` VARCHAR(255), `Name` VARCHAR(255), `input_text_1` VARCHAR(255), `input_checkbox_group_2` VARCHAR(255), `input_datetime_3` VARCHAR(255), `input_text_4` VARCHAR(255), `input_text_6` VARCHAR(255), `input_text_7` TEXT(255), `input_submit_8` VARCHAR(255), PRIMARY KEY (`cf_id`) );

also when i go to create table i dont see the option to 'create column box'

any help would be great,

David

Hi David,

It's probably here `input_text_7` TEXT(255), I think that text TEXT(255) isn't valid, you need to remove the 255 from the length column for anything except VARCHAR and maybe INT.

Bob

Hi Bob,

Changed that but still got an error:
Check table query below:

CREATE TABLE IF NOT EXISTS `jos__chronoforms_data_Booking ` ( `cf_id` INT(11) auto_increment, `cf_uid` VARCHAR(255), `cf_created` DATETIME, `cf_modified` DATETIME, `cf_ipaddress` VARCHAR(255), `cf_user_id` VARCHAR(255), `Name` VARCHAR(255), `input_text_1` VARCHAR(255), `input_checkbox_group_2` VARCHAR(255), `input_datetime_3` VARCHAR(255), `input_text_4` VARCHAR(255), `input_text_6` VARCHAR(255), `input_text_7` VARCHAR(255), `input_submit_8` VARCHAR(255), PRIMARY KEY (`cf_id`) );

regards

Hi DaveL123,

That query fails because there is a space after the table name before the closing ` `jos__chronoforms_data_Booking ` Also it should probably be jos_ as the prefix i.e. `jos_chronoforms_data_Booking`

Bob