+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: [solved] error at recreated a database (/showthread.php?tid=1075)
[solved] error at recreated a database - rslemer - 05-05-2018
I moved my database from my default server to another.
But in import, mySQL show error at key in vtoger_cbupdater table
ERROR 1071 (42000) at line 2216: Specified key was too long; max key length is 1000 bytes
At this point
CREATE TABLE `vtiger_cbupdater` (
`cbupdaterid` int(11) NOT NULL DEFAULT '0',
`cbupd_no` varchar(26) DEFAULT NULL,
`author` varchar(83) DEFAULT NULL,
`filename` varchar(218) DEFAULT NULL,
`pathfilename` varchar(218) DEFAULT NULL,
`classname` varchar(183) DEFAULT NULL,
`execstate` varchar(56) DEFAULT NULL,
`systemupdate` varchar(3) DEFAULT NULL,
`blocked` varchar(3) DEFAULT NULL,
`perspective` varchar(3) DEFAULT NULL,
`execdate` date DEFAULT NULL,
`execorder` int(11) DEFAULT NULL,
PRIMARY KEY (`cbupdaterid`),
UNIQUE KEY `findupdate` (`filename`,`classname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
How I can solved that?
RE: error at recreated a database - joebordes - 05-05-2018
See if this helps and let us know:
https://stackoverflow.com/questions/10873870/mysql-error-1071-specified-key-was-too-long-max-key-length-is-1000-bytes-in-s
RE: error at recreated a database - rslemer - 05-14-2018
I opted for redo, sever, BD and recreate all BD.
Works again.
Thanks.