I keep getting this error when i install the extension.
Index column size too large. The maximum column size is 767 bytes. SQL=CREATE TABLE IF NOT EXISTS #__js_res_record_values (id int(10) unsigned NOT NULL AUTO_INCREMENT, field_id INT(10) NOT NULL DEFAULT '0' COMMENT '', field_key VARCHAR(45) NOT NULL DEFAULT '' COMMENT '', field_type VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', field_label VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', field_value LONGTEXT NOT NULL DEFAULT '' COMMENT '', record_id INT(11) NOT NULL DEFAULT '0' COMMENT '', user_id INT(11) NOT NULL DEFAULT '0' COMMENT '', type_id INT(11) NOT NULL DEFAULT '0' COMMENT '', section_id INT(11) NOT NULL DEFAULT '0' COMMENT '', params TEXT NULL DEFAULT NULL COMMENT '', ip VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', ctime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', value_index VARCHAR(40) NOT NULL DEFAULT '0' COMMENT '', value_num INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (id), KEY idx_values (field_value(333)), KEY idx_key (field_key), KEY idx_record (record_id), KEY idx_field (field_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Question
Announcement
Conversation
Idea
Praise
Problem
Reviewed
Open
I keep getting this error when i install the extension.
Index column size too large. The maximum column size is 767 bytes. SQL=CREATE TABLE IF NOT EXISTS
#__js_res_record_values(idint(10) unsigned NOT NULL AUTO_INCREMENT,field_idINT(10) NOT NULL DEFAULT '0' COMMENT '',field_keyVARCHAR(45) NOT NULL DEFAULT '' COMMENT '',field_typeVARCHAR(100) NOT NULL DEFAULT '' COMMENT '',field_labelVARCHAR(100) NOT NULL DEFAULT '' COMMENT '',field_valueLONGTEXT NOT NULL DEFAULT '' COMMENT '',record_idINT(11) NOT NULL DEFAULT '0' COMMENT '',user_idINT(11) NOT NULL DEFAULT '0' COMMENT '',type_idINT(11) NOT NULL DEFAULT '0' COMMENT '',section_idINT(11) NOT NULL DEFAULT '0' COMMENT '',paramsTEXT NULL DEFAULT NULL COMMENT '',ipVARCHAR(100) NOT NULL DEFAULT '' COMMENT '',ctimeDATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '',value_indexVARCHAR(40) NOT NULL DEFAULT '0' COMMENT '',value_numINT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (id), KEYidx_values(field_value(333)), KEYidx_key(field_key), KEYidx_record(record_id), KEYidx_field(field_id)) ENGINE=MyISAM DEFAULT CHARSET=utf8;