cacti can't show the weathermap maps anymore

jjjjjuannnnn · Post by **jjjjjuannnnn** » Wed Oct 28, 2009 11:09 am

hi there guys

i have a little problem
my weahtermap was working fine, and it was great
but after a restart of the server can't see anymore the maps

got this message warning

Warning: Invalid argument supplied for foreach() in /var/www/cacti-0.8.7e/plugins/weathermap/weathermap-cacti-plugin-mgmt.php on line 238

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cacti-0.8.7e/plugins/weathermap/weathermap-cacti-plugin-mgmt.php:238) in /var/www/cacti-0.8.7e/plugins/weathermap/weathermap-cacti-plugin-mgmt.php on line 174

this is what i got in the cacti log

WEATHERMAP: Poller[0] Weathermap 0.96a starting - Normal logging mode. Turn on DEBUG in Cacti for more information
CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select * from weathermap_maps where active='on' order by sortorder,id"
WEATHERMAP: Poller[0] WARNING: No activated maps found. [WMPOLL05]
WEATHERMAP: Poller[0] STATS: Weathermap 0.96a run complete - 0 maps were run in 0 seconds with 0 warnings.

i can see thas is a sql error. don't know what kind of error.

and why is happenng after i restarted the server?

can anyone help me please?

thanks

jjjjjuannnnn · Post by **jjjjjuannnnn** » Wed Oct 28, 2009 12:04 pm

i found some other topics with a similar problems

most of them talk about the the sql tables and about the pa.sql file to copy in mysql.
I checked with phpmyadmin and i found the plugin_config, plugin_realms adn plugin_hooks in there. The plugin_config was empty though.

Howie · Post by **Howie** » Wed Oct 28, 2009 2:46 pm

Error 1146 is 'table doesn't exist'.

Does the weathermap_maps table exist? That's the one that is being checked in that SQL statement...

If it doesn't exist, then you can force weathermap to recreate it's tables by deleting one line from the 'settings' table - remove the record where the name is 'weathermap_db_version', and weathermap will recreate any missing tables. Of course, they will be empty, so restoring from your backups might be better, depending on how many maps you have.

jjjjjuannnnn · Post by **jjjjjuannnnn** » Thu Oct 29, 2009 5:41 am

that was sweet Howie!!!

thanks a lot everything it's runnig fine now, i just removed the record weathermap_db_version in settings and

thanks again

still wondering though what happened? with after i restarted the server got this problem.

Howie · Post by **Howie** » Thu Oct 29, 2009 6:26 am

jjjjjuannnnn wrote:that was sweet Howie!!!

thanks a lot everything it's runnig fine now, i just removed the record weathermap_db_version in settings and

thanks again

still wondering though what happened? with after i restarted the server got this problem.

Yeah... can't help you there. All I'll say is that there's nothing in the weathermap code to delete tables, and I'm pretty sure nothing in the Cacti code either. Sounds like a mysql screwup.