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


Messages In This Thread
[solved] error at recreated a database - rslemer - 05-05-2018, 02:46 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)