#1 Mysql error on install v.1.1 j25

[Valerio Capoccia]

Trying to install on joomla 2.5 the last distributed package.

JInstaller: :Install: Error SQL DB function failed with error number 1071
Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE IF NOT EXISTS jos_manta_registry ( id int(11) NOT NULL auto_increment, params text NOT NULL DEFAULT '', auth_name VARCHAR(150) NOT NULL , qualif VARCHAR(150) NOT NULL , name VARCHAR(200) , surname VARCHAR(200) , gender TINYINT , paral_name TEXT , stand_name TEXT , other_name TEXT , auth_qualif VARCHAR(300) , identifier VARCHAR(250) , PRIMARY KEY (id), KEY idx_auth_qualif (auth_name,qualif), UNIQUE(auth_qualif) );
SQL =
CREATE TABLE IF NOT EXISTS #__manta_registry (
id int(11) NOT NULL auto_increment,
params text NOT NULL DEFAULT '',
auth_name VARCHAR(150) NOT NULL ,
qualif VARCHAR(150) NOT NULL ,
name VARCHAR(200) ,
surname VARCHAR(200) ,
gender TINYINT ,
paral_name TEXT ,
stand_name TEXT ,
other_name TEXT ,
auth_qualif VARCHAR(300) ,
identifier VARCHAR(250) ,

PRIMARY KEY  (`id`),
KEY `idx_auth_qualif` (`auth_name`,`qualif`),
UNIQUE(auth_qualif)

);
Component Install: SQL error file DB function failed with error number 1071
Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE IF NOT EXISTS jos_manta_registry ( id int(11) NOT NULL auto_increment, params text NOT NULL DEFAULT '', auth_name VARCHAR(150) NOT NULL , qualif VARCHAR(150) NOT NULL , name VARCHAR(200) , surname VARCHAR(200) , gender TINYINT , paral_name TEXT , stand_name TEXT , other_name TEXT , auth_qualif VARCHAR(300) , identifier VARCHAR(250) , PRIMARY KEY (id), KEY idx_auth_qualif (auth_name,qualif), UNIQUE(auth_qualif) );
SQL =
CREATE TABLE IF NOT EXISTS #__manta_registry (
id int(11) NOT NULL auto_increment,
params text NOT NULL DEFAULT '',
auth_name VARCHAR(150) NOT NULL ,
qualif VARCHAR(150) NOT NULL ,
name VARCHAR(200) ,
surname VARCHAR(200) ,
gender TINYINT ,
paral_name TEXT ,
stand_name TEXT ,
other_name TEXT ,
auth_qualif VARCHAR(300) ,
identifier VARCHAR(250) ,

PRIMARY KEY  (`id`),
KEY `idx_auth_qualif` (`auth_name`,`qualif`),
UNIQUE(auth_qualif)

);
Package Install: There was an error installing an extension: com_manta.zip

but i got this error.
Tables on db where partially created.
Yesterday (maybe with the previous release of component) everything works really fine.

Any update?
Thanks in advance

[Elena Cenacchi]

Hi,

I have not loaded any updated version during the week-end.
Have you tried uninstalling and doing a fresh installation ?

Let me know.

[Valerio Capoccia]

Tryed everything.
Fresh install. Install on new joomla 2.5 fresh installed.
Delete partial table and reinstall.
Nothing to do. It seems something related to key lenght on mysql.

CREATE TABLE IF NOT EXISTS #__manta_registry (
id int(11) NOT NULL auto_increment,
params text NOT NULL DEFAULT '',
auth_name VARCHAR(150) NOT NULL ,
qualif VARCHAR(150) NOT NULL ,
name VARCHAR(200) ,
surname VARCHAR(200) ,
gender TINYINT ,
paral_name TEXT ,
stand_name TEXT ,
other_name TEXT ,
auth_qualif VARCHAR(300) ,
identifier VARCHAR(250) ,

PRIMARY KEY  (`id`),
KEY `idx_auth_qualif` (`auth_name`,`qualif`),
UNIQUE(auth_qualif)

);

auth_name and qualif are 2 keys, each of 150 char.
2bytes for key and we're at (i.e.) 300bytes for each key.

so the error

Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE IF NOT EXISTS jos_manta_registry ( id int(11) NOT NULL auto_increment, params text NOT NULL DEFAULT '', auth_name VARCHAR(150) NOT NULL , qualif VARCHAR(150) NOT NULL , name VARCHAR(200) , surname VARCHAR(200) , gender TINYINT , paral_name TEXT , stand_name TEXT , other_name TEXT , auth_qualif VARCHAR(300) , identifier VARCHAR(250) , PRIMARY KEY (id), KEY idx_auth_qualif (auth_name,qualif), UNIQUE(auth_qualif) );

i'm trying to do some debug (with one of our sysadmin).
It's really strange, due to the perfect install and working component of yesterday.

(we can follow in pvt and in italian if you prefer)

Valerio

[Elena Cenacchi]

Ok, send me a pm (italian is fine :-)) !

Elena

[Valerio Capoccia]

How to pm here on sf?
anyway valerio.capoccia at gmail dot com

[Valerio Capoccia]

Solved. fast clean and effective.