Getting JInstaller error in the sandbox. I'm not using anything complex - just basic tables and form fields. Happened after changing the form. I think JCook gui has gotten confused?? (Like me
)
Help!
V2.0 Beta,
JS Framework: jQUERY
Embed Framework: No
Form style: Condensed
Features: JDom complete
TODO: No
JInstaller: :Install: Error SQL DB function failed with error number 1071
Specified key was too long; max key length is 1000 bytes SQL=CREATE TABLE IF NOT EXISTS `[PREFIX]demo6062_members` ( `id` int(11) NOT NULL auto_increment, `params` text NOT NULL DEFAULT '', `membership_number` VARCHAR(255) , `joomla_user` INT(11) , `username` VARCHAR(255) NOT NULL , `member_name` VARCHAR(255) NOT NULL , `password` VARCHAR(255) , `email` VARCHAR(255) NOT NULL , `company_id` INT(11) , `address` VARCHAR(255) , `state` VARCHAR(255) , `postcode` VARCHAR(255) , `phone` VARCHAR(255) , `mobile` VARCHAR(255) , `notes` TEXT , `ordering` INT(11) , `access` INT(11) DEFAULT 1 , `created_by` INT(11) , `created_date` DATE , `modified_by` INT(11) , `modification_date` DATE , `checked_out` INT(11) NOT NULL DEFAULT 0 , `checked_out_time` DATETIME , `published` TINYINT , PRIMARY KEY (`id`), UNIQUE(username, email) );
SQL =
CREATE TABLE IF NOT EXISTS `#__demo6062_members` (
`id` int(11) NOT NULL auto_increment,
`params` text NOT NULL DEFAULT '',
`membership_number` VARCHAR(255) ,
`joomla_user` INT(11) ,
`username` VARCHAR(255) NOT NULL ,
`member_name` VARCHAR(255) NOT NULL ,
`password` VARCHAR(255) ,
`email` VARCHAR(255) NOT NULL ,
`company_id` INT(11) ,
`address` VARCHAR(255) ,
`state` VARCHAR(255) ,
`postcode` VARCHAR(255) ,
`phone` VARCHAR(255) ,
`mobile` VARCHAR(255) ,
`notes` TEXT ,
`ordering` INT(11) ,
`access` INT(11) DEFAULT 1 ,
`created_by` INT(11) ,
`created_date` DATE ,
`modified_by` INT(11) ,
`modification_date` DATE ,
`checked_out` INT(11) NOT NULL DEFAULT 0 ,
`checked_out_time` DATETIME ,
`published` TINYINT ,
PRIMARY KEY (`id`),
UNIQUE(username, email)
);
