Código SQL:
Ver original
Executing SQL script IN server ERROR: Error 1170: BLOB/TEXT COLUMN 'article' used IN KEY specification WITHOUT a KEY LENGTH SQL Code: CREATE TABLE IF NOT EXISTS `mydb`.`articles` ( `idarticles` INT(11) NOT NULL AUTO_INCREMENT COMMENT '', `title` VARCHAR(45) NOT NULL COMMENT '', `article` TEXT(255) NOT NULL COMMENT '', `summary` TINYTEXT NULL DEFAULT NULL COMMENT '', `tags` TINYTEXT NULL DEFAULT NULL COMMENT '', `idcategories` INT(11) NULL DEFAULT NULL COMMENT '', INDEX `idarticles` (`idarticles` ASC) COMMENT '', INDEX `title` (`title` ASC) COMMENT '', INDEX `article` (`article` ASC) COMMENT '', INDEX `idcategories_idx` (`idcategories` ASC) COMMENT '', CONSTRAINT `idcategories` FOREIGN KEY (`idcategories`) REFERENCES `mydb`.`categories` (`idcategories`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci SQL script execution finished: statements: 3 succeeded, 1 failed Fetching back VIEW definitions IN final form. Nothing TO fetch
Eso es lo que me aparece en el log.
¿Alguien puede ayudarme a identificar el problema?
Saludos.