Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[solved] error at recreated a database
#1
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?
Ranieri
eCRM Web
Reply
#2
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
Joe
TSolucio
Reply
#3
I opted for redo, sever, BD and recreate all BD.

Works again.

Thanks.
Ranieri
eCRM Web
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)