When I tried to install give the warnings:
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE weather_es_data ( `did` SMALLINT NOT NULL auto_increment, `cod_pro` INT unsigned NOT NULL DEFAULT 0, `cod_loc` INT unsigned NOT NULL DEFAULT 0, `day` VARCHAR(15) DEFAULT '', `ampm` VARCHAR(2) DEFAULT '', `sky_txt1` VARCHAR(50) DEFAULT '', `sky_txt2` VARCHAR(50) DEFAULT '', `sky_img1` VARCHAR(25) DEFAULT 'nodata', `sky_img2` VARCHAR(25) DEFAULT 'nodata', `rain` INT unsigned DEFAULT 999, `snow` INT unsigned DEFAULT 9999, `tmax` INT DEFAULT 99, `tmin` INT DEFAULT 99, `win_dir1` VARCHAR(50) DEFAULT '', `win_dir2` VARCHAR(50) DEFAULT '', `win_spd1` INT unsigned DEFAULT 999, `win_spd2` INT unsigned DEFAULT 999, `iv_max` INT unsigned DEFAULT 99, `rsk` VARCHAR(50) DEFAULT '', PRIMARY KEY (cod_pro, cod_loc, did) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\wamp\www\drupal-6.15\includes\database.inc on line 529.
* user warning: Table 'drupal2.weather_es_data' doesn't exist query: ALTER TABLE weather_es_data CHANGE cod_pro cod_pro INT(2) ZEROFILL DEFAULT 0 NOT NULL in C:\wamp\www\drupal-6.15\sites\all\modules\weather_es\weather_es.install on line 269.
* user warning: Table 'drupal2.weather_es_data' doesn't exist query: ALTER TABLE weather_es_data CHANGE cod_loc cod_loc INT(3) ZEROFILL DEFAULT 0 NOT NULL in C:\wamp\www\drupal-6.15\sites\all\modules\weather_es\weather_es.install on line 270.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | bd-antes.png | 43.1 KB | bullakio@drupal.org |
| #1 | bd-despues.png | 55.56 KB | bullakio@drupal.org |
| #1 | modulos.png | 16.52 KB | bullakio@drupal.org |
| #1 | instalado.png | 11.51 KB | bullakio@drupal.org |
Comments
Comment #1
bullakio@drupal.org commentedI'm sorry... but I don't have this problems... I have just installed from scratch (uninstall and install) the last version, 6.x-1.9, in my Drupal-6.15. Like you can see in the images everything was ok during the installation and the module is working ok. Please check the md5sum of the module.
Comment #2
yunky commentedI Chek the md5sum and it´s correct.
I try to install the module in two machines and I have the same warning in both of them:
* user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: CREATE TABLE weather_es_data ( `did` SMALLINT NOT NULL auto_increment, `cod_pro` INT unsigned NOT NULL DEFAULT 0, `cod_loc` INT unsigned NOT NULL DEFAULT 0, `day` VARCHAR(15) DEFAULT '', `ampm` VARCHAR(2) DEFAULT '', `sky_txt1` VARCHAR(50) DEFAULT '', `sky_txt2` VARCHAR(50) DEFAULT '', `sky_img1` VARCHAR(25) DEFAULT 'nodata', `sky_img2` VARCHAR(25) DEFAULT 'nodata', `rain` INT unsigned DEFAULT 999, `snow` INT unsigned DEFAULT 9999, `tmax` INT DEFAULT 99, `tmin` INT DEFAULT 99, `win_dir1` VARCHAR(50) DEFAULT '', `win_dir2` VARCHAR(50) DEFAULT '', `win_spd1` INT unsigned DEFAULT 999, `win_spd2` INT unsigned DEFAULT 999, `iv_max` INT unsigned DEFAULT 99, `rsk` VARCHAR(50) DEFAULT '', PRIMARY KEY (cod_pro, cod_loc, did) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\wamp\www\drupal-6.15\includes\database.inc on line 529.
* user warning: Table 'drupal2.weather_es_data' doesn't exist query: ALTER TABLE weather_es_data CHANGE cod_pro cod_pro INT(2) ZEROFILL DEFAULT 0 NOT NULL in C:\wamp\www\drupal-6.15\sites\all\modules\weather_es\weather_es.install on line 269.
* user warning: Table 'drupal2.weather_es_data' doesn't exist query: ALTER TABLE weather_es_data CHANGE cod_loc cod_loc INT(3) ZEROFILL DEFAULT 0 NOT NULL in C:\wamp\www\drupal-6.15\sites\all\modules\weather_es\weather_es.install on line 270.
The machines are:
- windows XP with wamp, drupal 6.15
- windows with IIS and mysql, drupal 6.16
In both the problem is to create the table weather_es_data, the other tables: weather_es_aemet and weather_es_config was created sucesfull.
Comment #3
bullakio@drupal.org commentedI need to know your both MySQL versions. Mine is MySQL 5.1.30.
Try to change into wheather_es.install the line
PRIMARY KEY(cod_pro, cod_loc, did))toPRIMARY KEY(did, cod_pro, cod_loc))If it doesn't work you can googling this "user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query"
Please, let us know if you are successful.
No sé qué más hacer...
Comment #4
bullakio@drupal.org commentedNow it's ok