I'm getting an error when trying to upgrade from 1.30 to 1.32: nuke_wthr_cache gets deleted, but when a new table should be created, there is an error:

Code

_CREATETABLEFAILED table : nuke_wthr_cache error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(20) DEFAULT '' NOT NULL, nuke_wthr_cache.pressure var 

I'm using MySQL 4.0.18. I tried to comment out the corresponding code in pninit, but my PHP is rather poor, so I probably got the wrong lines - it still happened. Is there a workaround?

Hello,
this is funny because 1.32 was just created for that purpose because 1.30 and 1.31 had a problem with the fact that a field was named "real" in the cache table wich caused some trouble with some recent versions of MySQL. But I was assuming that people concerned by this problem will be doing a fresh install not an upgrade because as the module had a problem o­n this setup I wasn't thinking it could be installed and running !!
So to solve your problem :
either
1) inactivate, remove, refresh, initialize and activate the module in Administration -> Modules but you will loose all the users prefs and have to reinstall any previously installed city
or
2) open pninit.php and look for the word "real" and replace it with "flike" (well in fact you can replace it with any other non reserved word because it will be replaced by flike during the 1.31>1.32 upgrade !!). The avantage of this solution is that you won't loose anything.
You will have to search and replace 4 occurences of the word "real" in pninit.php.
Be sure also to revert back any change you have tried to make to pninit.php or to start with a fresh pninit.php from weather 1.32 download.

Hmm, strange... In the end I made a clean (de-)install, after that there were no problems. I guess most of my users (students of our department) have never changed their weather settings anyway - and I had "warned" them about modifications I would make during their vacation.

Thanks for the new version! Now I'm again a bit closer to the upgrade to 0.75...

Hmm, strange... In the end I made a clean (de-)install, after that there were no problems. I guess most of my users (students of our department) have never changed their weather settings anyway - and I had "warned" them about modifications I would make during their vacation.

Thanks for the new version! Now I'm again a bit closer to the upgrade to 0.75...