Installing update twice has failed using the directions given for updating the 1.9 to 2.11 and had to revert to previous, but METAR is not updating displayed information in 1.9 version since April.

The following updates returned messages

weather module

Update #7209
Failed: DatabaseSchemaObjectExistsException: Cannot add field weather_places.status: field already exists. in DatabaseSchema_mysql->addField() (line 328 of C:\netin\web\intranet\includes\database\mysql\schema.inc).

Adding Note: the PHP version is 5.5.

Comments

iowatiger08’s picture

Issue summary: View changes
toddy’s picture

Hm, this looks like you need to uninstall the module, so that the database tables of the module get deleted. Afterwards, the installation should succeed again.

Please note that by uninstalling the module, you will loose your custom configuration of the weather module, if there is one.

Regards,
Tobias

runnergirl’s picture

Toddy (Tobias),
I'm in the same office as iowatiger08 was, and having the same issue. I followed your instructions listed below, completely removed the directory Weather from my sites/all/modules folder and then copied the new version into my sites/all/modules folder. I ran update.php with it listing 10 pending updates. It still throws the failed error on Update #7209

Failed: DatabaseSchemaObjectExistsException: Cannot add field weather_places.status: field already exists. in DatabaseSchema_mysql->addField() (line 328 of C:\ipersnetintra\web\ipersnet\includes\database\mysql\schema.inc).

I'm having to restore back to the previous version we were using 7.x-1.9

Any additional suggestions or corrections would be appreciated.
Thank you!

Carla

++++++++++++++++++++++++++++++++
Notes on upgrade from 7.x-1.x version

If you've installed the 7.x-1.x version of the weather module, you can easily upgrade to the new 7.x-2.x version. Most of your custom configuration will be saved and migrated to the 7.x-2.x version.

Please make a backup of your database in case something goes wrong!
•Make sure you've installed the latest version of the 7.x-1.x branch of the module. Upgrades are only supported from that version.
•Enable maintenance mode for your website.
•Make a backup of your database.
•Completely remove the directory "weather" under the directory "sites/all/modules".
•Copy the newly downloaded 7.x-2.x version of weather to your directory "sites/all/modules".
•Run update.php.
•Check that all weather module settings have been migrated as expected.
•Check the names of automatically migrated new locations.
•Disable maintenance mode for your website.

  • toddy committed 7549ffc on 7.x-2.x
    Issue #2542966: Remove double addition of database field
    
toddy’s picture

Assigned: Unassigned » toddy
Status: Active » Fixed

Thanks for reporting again, this should be fixed now.

Regards,
Tobias

runnergirl’s picture

Hi again Toddy,
Thank you for such a quick turn around on my comment. I'm still having trouble getting this Weather module updated. A new error is displaying, occurring on the very first update. I again followed the instructions of removing the Weather module from my sites/all/modules folder and then downloaded the new version (7.x-2.13) and added that Weather module folder to my sites/all/modules. I then ran update.php for our site. It starts/completes the updating process but then returns with the message below. Is it something I'm doing wrong? Or does the module need another fix?
Thanks for your time on this Toddy.

Carla

+++++++++++++++++++++++++++++++
The following updates returned messages

weather module

Update #7200
Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause': DELETE FROM {weather_places} WHERE (status = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => original ) in _weather_data_installation() (line 65 of C:\ipersnetintra\web\ipersnet\sites\all\modules\weather\weather.install).

toddy’s picture

Hi Carla,

thanks for the follow up, there has been indeed an error. It should be fixed now, however.

Regards,
Tobias

runnergirl’s picture

Hello Tobias,

I appreciate your diligence on this. I made it past the pending updates. . .no errors! Thank you for that! But after running the update.php and displaying my site, I don't see the Weather information displaying. I wish there was a way to send you two snipit jpeg files I have, that shows what it looked like with version 1.9 and then with version 2.14. It 'did' retain the navy colored horizontal bar that reads "Current Weather" and it does list a bullet. But there is no longer "Des Moines" displaying in bold, no weather image, no other weather descriptive bullet points such as; Overcast, light rain, mist nor Temperature, nor Wind velocity, nor Visibility. Also no "Reported on:" date with a link to an 'Hourly Forecast'. When I click Configure and look at the options there, the new version seems to have retained "Des Moines, Iowa" and lists it as "Des Moines, Iowa (8.4 km from Des Moines) for the SYSTEM-WIDE DISPLAY(#1) option. With a weight of 0 (just like before). The Directory for custom images is blank, just like before. Number of forecast days was defaulted to two. This option appears new with this latest version, since I didn't have this before. To see if it made a difference to my display, I changed it to "1" but again, nothing displays in the block that houses the Weather module.
Am I doing something wrong?

Thanks,
Carla

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

runnergirl’s picture

Hi Tobias,

I'm unsure why this Bug issue was closed. I didn't see that it was working in my situation. I also tried downloading a plain/vanilla Drupal 7 and installed the module. Still no luck. .. still no weather displaying.

Thanks,
Carla