Code: Alles auswählen
/setup/dbupdate.php?step=37 MySQL error 1071: Specified key was too long; max key length is 1000 bytes\n\nALTER TABLE con_properties ADD INDEX (idclient, itemtype , itemid , type, name)
Code: Alles auswählen
/setup/dbupdate.php?step=37 MySQL error 1071: Specified key was too long; max key length is 1000 bytes\n\nALTER TABLE con_properties ADD INDEX (idclient, itemtype , itemid , type, name)
Code: Alles auswählen
CREATE TABLE `con_properties` (
`idproperty` int(10) NOT NULL default '0',
`idclient` int(10) NOT NULL default '0',
`itemtype` varchar(64) NOT NULL,
`itemid` varchar(255) NOT NULL,
`type` varchar(96) NOT NULL,
`name` varchar(96) NOT NULL,
`value` text NOT NULL,
`author` varchar(32) NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modifiedby` varchar(32) NOT NULL,
PRIMARY KEY (`idproperty`),
KEY `idclient` (`idclient`,`itemtype`,`itemid`,`type`,`name`),
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Code: Alles auswählen
CREATE TABLE IF NOT EXISTS `con_properties` (
`idproperty` int( 10 ) NOT NULL DEFAULT '0',
`idclient` int( 10 ) NOT NULL DEFAULT '0',
`itemtype` varchar( 64 ) NOT NULL ,
`itemid` varchar( 255 ) NOT NULL ,
`type` varchar( 96 ) NOT NULL ,
`name` varchar( 96 ) NOT NULL ,
`value` text NOT NULL ,
`author` varchar( 32 ) NOT NULL ,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modifiedby` varchar( 32 ) NOT NULL ,
PRIMARY KEY ( `idproperty` ) ,
KEY `idclient` ( `idclient` , `itemtype` , `itemid` , `type` , `name` ) ,
KEY `index_client` ( `idclient` ) ,
KEY `index_itemtype` ( `itemtype` ) ,
KEY `index_itemid` ( `itemid` ) ,
KEY `index_type` ( `type` )
) TYPE = MYISAM ;
MySQL meldet: Dokumentation
#1071 - Specified key was too long. Max key length is 500