Need to know what this Error means in mysql

Lorddrago
04-16-2004, 12:18 AM
the error I get when trying to set up my database is:

1070 - Too many key parts specified. Max 16 parts allowed

I have 80 fields I need 40 are names c1 - c16, ch17 - ch32, che33 - che40 and 40 are named t1 - t16, te17 - te32, tex33 - tex40. I have one primary field called pr. it is set to VARCHAR and primary

all the c and t fields are set to TEXT and I have checked the full text option on all of them. Below is the full ERROR msg. I get:

Error

SQL-query :

CREATE TABLE `bcontrol` (
`pr` VARCHAR( 2 ) NOT NULL ,
`c1` TEXT NOT NULL ,
`c2` TEXT NOT NULL ,
`c3` TEXT NOT NULL ,
`c4` TEXT NOT NULL ,
`c5` TEXT NOT NULL ,
`c6` TEXT NOT NULL ,
`c7` TEXT NOT NULL ,
`c8` TEXT NOT NULL ,
`c9` TEXT NOT NULL ,
`c10` TEXT NOT NULL ,
`c11` TEXT NOT NULL ,
`c12` TEXT NOT NULL ,
`c13` TEXT NOT NULL ,
`c14` TEXT NOT NULL ,
`c15` TEXT NOT NULL ,
`c16` TEXT NOT NULL ,
`ch17` TEXT NOT NULL ,
`ch18` TEXT NOT NULL ,
`ch19` TEXT NOT NULL ,
`ch20` TEXT NOT NULL ,
`ch21` TEXT NOT NULL ,
`ch22` TEXT NOT NULL ,
`ch23` TEXT NOT NULL ,
`ch24` TEXT NOT NULL ,
`ch25` TEXT NOT NULL ,
`ch26` TEXT NOT NULL ,
`ch27` TEXT NOT NULL ,
`ch28` TEXT NOT NULL ,
`ch29` TEXT NOT NULL ,
`ch30` TEXT NOT NULL ,
`ch31` TEXT NOT NULL ,
`ch32` TEXT NOT NULL ,
`che33` TEXT NOT NULL ,
`che34` TEXT NOT NULL ,
`che35` TEXT NOT NULL ,
`che36` TEXT NOT NULL ,
`che37` TEXT NOT NULL ,
`che38` TEXT NOT NULL ,
`che39` TEXT NOT NULL ,
`che40` TEXT NOT NULL ,
`te1` TEXT NOT NULL ,
`te2` TEXT NOT NULL ,
`te3` TEXT NOT NULL ,
`te4` TEXT NOT NULL ,
`te5` TEXT NOT NULL ,
`te6` TEXT NOT NULL ,
`te7` TEXT NOT NULL ,
`te8` TEXT NOT NULL ,
`te9` TEXT NOT NULL ,
`te10` TEXT NOT NULL ,
`te11` TEXT NOT NULL ,
`te12` TEXT NOT NULL ,
`te13` TEXT NOT NULL ,
`te14` TEXT NOT NULL ,
`te15` TEXT NOT NULL ,
`te16` TEXT NOT NULL ,
`tex17` TEXT NOT NULL ,
`tex18` TEXT NOT NULL ,
`tex19` TEXT NOT NULL ,
`tex20` TEXT NOT NULL ,
`tex21` TEXT NOT NULL ,
`tex22` TEXT NOT NULL ,
`tex23` TEXT NOT NULL ,
`tex24` TEXT NOT NULL ,
`tex25` TEXT NOT NULL ,
`tex26` TEXT NOT NULL ,
`tex27` TEXT NOT NULL ,
`tex28` TEXT NOT NULL ,
`tex29` TEXT NOT NULL ,
`tex30` TEXT NOT NULL ,
`tex31` TEXT NOT NULL ,
`tex32` TEXT NOT NULL ,
`tex33` TEXT NOT NULL ,
`tex34` TEXT NOT NULL ,
`tex35` TEXT NOT NULL ,
`tex36` TEXT NOT NULL ,
`tex37` TEXT NOT NULL ,
`tex38` TEXT NOT NULL ,
`tex39` TEXT NOT NULL ,
PRIMARY KEY ( `pr` ) ,
FULLTEXT (
`c1` ,
`c2` ,
`c3` ,
`c4` ,
`c5` ,
`c6` ,
`c7` ,
`c8` ,
`c9` ,
`c10` ,
`c11` ,
`c12` ,
`c13` ,
`c14` ,
`c15` ,
`c16` ,
`ch17` ,
`ch18` ,
`ch19` ,
`ch20` ,
`ch21` ,
`ch22` ,
`ch23` ,
`ch24` ,
`ch25` ,
`ch26` ,
`ch27` ,
`ch28` ,
`ch29` ,
`ch30` ,
`ch31` ,
`ch32` ,
`che33` ,
`che34` ,
`che35` ,
`che36` ,
`che37` ,
`che38` ,
`che39` ,
`che40` ,
`te1` ,
`te2` ,
`te3` ,
`te4` ,
`te5` ,
`te6` ,
`te7` ,
`te8` ,
`te9` ,
`te10` ,
`te11` ,
`te12` ,
`te13` ,
`te14` ,
`te15` ,
`te16` ,
`tex17` ,
`tex18` ,
`tex19` ,
`tex20` ,
`tex21` ,
`tex22` ,
`tex23` ,
`tex24` ,
`tex25` ,
`tex26` ,
`tex27` ,
`tex28` ,
`tex29` ,
`tex30` ,
`tex31` ,
`tex32` ,
`tex33` ,
`tex34` ,
`tex35` ,
`tex36` ,
`tex37` ,
`tex38` ,
`tex39`
)
)

MySQL said:
#1070 - Too many key parts specified. Max 16 parts allowed

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum