Hi to All, i am not able to install the module under winXP since i receive three errors - when i tick the weather 5.x-5.1. afterwards the http page gives error 500 and the module is not loaded. anybody can help me? thanks indeed

user warning: Table 'weather' already exists query: CREATE TABLE weather ( icao VARCHAR(4) DEFAULT '' NOT NULL, next_update_on INTEGER DEFAULT 0 NOT NULL, metar_raw VARCHAR(255) DEFAULT '' NOT NULL, PRIMARY KEY (icao) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\includes\database.mysql.inc on line 172.
user warning: Table 'weather_config' already exists query: CREATE TABLE weather_config ( uid INTEGER DEFAULT 0 NOT NULL, cid INTEGER DEFAULT 0 NOT NULL, icao VARCHAR(4) DEFAULT '' NOT NULL, real_name VARCHAR(255) DEFAULT '' NOT NULL, units VARCHAR(255) DEFAULT 'a:4:{s:11:\"temperature\";s:7:\"celsius\";s:9:\"windspeed\";s:3:\"kmh\";s:8:\"pressure\";s:3:\"hpa\";s:10:\"visibility\";s:10:\"kilometers\";}' NOT NULL, settings VARCHAR(255) DEFAULT 'a:3:{s:22:\"show_unconverted_metar\";i:0;s:27:\"show_abbreviated_directions\";i:0;s:22:\"show_directions_degree\";i:0;}' NOT NULL, weight INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY (uid, cid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\includes\database.mysql.inc on line 172.
user warning: Table 'weather_icao' already exists query: CREATE TABLE weather_icao ( icao VARCHAR(4) DEFAULT '' NOT NULL, country VARCHAR(255) DEFAULT '' NOT NULL, name VARCHAR(255) DEFAULT '' NOT NULL, latitude DOUBLE PRECISION DEFAULT 0.0 NOT NULL, longitude DOUBLE PRECISION DEFAULT 0.0 NOT NULL, PRIMARY KEY (icao) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\includes\database.mysql.inc on line 172.

Comments

pramudya81’s picture

pramudya81 commented

Yes,

I am facing an exact problem.

Is it anything to do with XP?

Regards

toddy’s picture

toddy commented

Unfortunately, I cannot reproduce this error, because I don't have access to a Windows system. There have been issues with MS Windows in the past, so maybe this is related to XP, yes. Sorry, but I cannot give any more advice. If you discover the cause of the error, I'll be happy to accept patches.

Regards,
Tobias

pramudya81’s picture

pramudya81 commented

Unfortunately, also do not know the reason behind this error.

What happened was this:
1. copy the module to drupal home
2. enable the module via administer->module
3. nothing happens
4. the chexbox remains unticked (not installed yet)
5. retry to tick the checkbox and submit to reinstall the module
6. produce the errors above

I might need tracing / debug module to find out the reason behind.
I'm still newbie to Drupal so I cant promise when I would be able to do this

Regards

vm’s picture

vm commented

not that it has anything to do with your error but contrib modules should be uploaded to sites/all/modules and remain seperated from core modules. That said, maybe this is what you meant when you state "copy the module to drupal home"

My suggestion is to uninstall the module using the uninstall tab. Not sure if this module usese the uninstall hook. if it does then the tables will be removed from the DB when you use the uninstall tab. Double check the DB and insure all entries have been remobved and try to install again, though do so on a test site where you won't further risk your prouction DB.

toddy’s picture

toddy commented

Yes, this module uses the uninstall hook and removes all associated tables.

pramudya81’s picture

pramudya81 commented

Yes. It has the uninstall tab.

But the problem is when the first time to enable the module.
Nothing happened, blank screen on browser showed up.

2 options:
1. try to re-enable the module thus giving us the errors. (duplicate table)
2. try to uninstall then enable the module again. (giving the same point as first installation) nothing happened.

Regards

toddy’s picture

toddy commented
Assigned: Unassigned » toddy
Status: Active » Postponed (maintainer needs more info)

Could you upgrade to Drupal 6.x and see if the error persists with the weather module?

toddy’s picture

toddy commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Closing, as there's no more input.

SuperContraXTC’s picture

SuperContraXTC commented

I can't seem to intall it,
Can you tell me the database information so I can remove it from there and try again?

Thanks

vm’s picture

vm commented

as previously mentioned this module has an uninstall hook.

therefore you go to administer -> modules
click on the uninstall tab

and remove the modules tables using the uninstall hook.

to do so you have to still have the files uploaded to your server. If you've already removed the files, you have to put them back.