SmartCJ Support Forum

Code: Select all

Mysql error:: 1071 (Specified key was too long; max key length is 1000 bytes) (db_link) in query ALTER TABLE `links` CHANGE `link` `link` VARCHAR( 255 ) NOT NULL .

Code: Select all

mysql> select * from links;
+------------+----------------------------------------------------+-----+--------+
| trader     | link                                               | num | hour   |
+------------+----------------------------------------------------+-----+--------+
| overclicks | overclick_from_noref                               |   1 | 385279 |
| overclicks | overclick_from_noref                               |   1 | 385280 |
| noref      | lp_in_/photo/nesty-on-21naturals-com-melody/index. |   2 | 385280 |
| noref      | lp_in_/?skip_cache=1                               |   2 | 385284 |
| overclicks | overclick_from_noref                               |   7 | 385284 |
| noref      | lp_in_/photo/nesty-on-21naturals-com-melody/       |   1 | 385284 |
| overclicks | overclick_from_noref                               |  13 | 385285 |
| noref      | lp_in_/teens/ctr/1/?skip_cache=1                   |   1 | 385285 |
| noref      | lp_in_/photo/dido-angel-on-21naturals-com/         |   2 | 385285 |
| noref      | lp_in_/photo/dido-angel-on-21naturals-com/?skip_ca |   1 | 385285 |
| overclicks | overclick_from_noref                               |  65 | 385286 |
| noref      | lp_in_/photo/dido-angel-on-21naturals-com/?skip_ca |  11 | 385286 |
| overclicks | overclick_from_noref                               |  27 | 385287 |
| overclicks | overclick_from_noref                               |  18 | 385288 |
| overclicks | overclick_from_noref                               |  14 | 385289 |
+------------+----------------------------------------------------+-----+--------+
15 rows in set (0.00 sec)

Code: Select all

DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `trader` char(100) NOT NULL,
  `link` char(50) NOT NULL,
  `num` int(11) NOT NULL DEFAULT '0',
  `hour` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`trader`,`link`,`hour`)
) ENGINE=MyISAM ;
/*!40101 SET character_set_client = @saved_cs_client */;

Code: Select all

ALTER TABLE `links` CHANGE `link` `link` VARCHAR( 255 ) NOT NULL;