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.

Comments

bullakio@drupal.org’s picture

StatusFileSize
new11.51 KB
new16.52 KB
new55.56 KB
new43.1 KB

I'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.

yunky’s picture

I 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.

bullakio@drupal.org’s picture

I 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)) to PRIMARY 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...

bullakio@drupal.org’s picture

Status: Active » Closed (fixed)

Now it's ok