Bueno, en mi iNews tengo un problema que me persigue de hace tiempo, consigo crear 3 de 4 tablas, pero esta ultima no se por que no me va :S.
Os dejo el code del install2.php de la versión 1.1 que es la más reciente y funcional.
Código
$mysqlactive = "CREATE TABLE `mensajes` ( `id` INT NOT NULL AUTO_INCREMENT , `autor` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, `mensaje` TEXT NOT NULL , `titulo` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, `tags` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, PRIMARY KEY ( `id` ) ) TYPE = MYISAM ;"; $mysqlactiveusers = "CREATE TABLE `usuarios` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `usuario` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, `password` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, `rango` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, PRIMARY KEY ( `id` ) ) TYPE = MYISAM ;"; $mysqlactivecoments = "CREATE TABLE `comentarios`( `id` INT primary key auto_increment, `ref` INT NOT NULL, `autor` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, `comentario` TEXT CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL ) TYPE = MYISAM ;"; $mysqlactiveboletin = "CREATE TABLE `boletin`( `id` INT primary key auto_increment, `titulo` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, `mensaje` text NOT NULL, PRIMARY KEY ( `id` ) ) TYPE = MYISAM;";
EDIT: Arreglado, un colega me ayudo, falle en que puse multiples veces primary key