MySQL error: Warning: Invalid argument supplied for foreach

[randybnl]

Hi guys,

Yesterday I installed the whole Cacti package. Also apache, PHP and stuff. Cacti is working but the tabs Monitor and Weathermap are acting strange. When I open there's a error its showed in the attachment. And also if I click another link the link is changing from http://localhost/cacti/plugins/weatherm ... plugin.php to http://localhost/cacti/plugins/weatherm ... plugin.php.

Does anybody know what this could be?

[Howie]

Install 0.97a instead - there are plenty of bugfixes in that 'a'.

[randybnl]

Install 0.97a instead - there are plenty of bugfixes in that 'a'.

Did tried it, but it won't work. Could it be something with Linked-Tables Infrastructure?

[Howie]

Did you set url_path in global.php? Does it end with a / ?
I noticed that all your tabs are borken - that's usually a sign that url_path is wrong. The links growing makes me think that, too.

There might be something else, to cause the foreach() error, but I think that might be part of it.

[randybnl]

Solved the broken links but still MySQL errors.

[Howie]

I don't see any MySQL error - please could you post that error message?

[randybnl]

I don't see any MySQL error - please could you post that error message?

Sure..


( ! ) Warning: Invalid argument supplied for foreach() in C:\wamp\www\cacti\plugins\weathermap\weathermap-cacti-plugin.php on line 824
Call Stack
# Time Memory Function Location
1 0.0031 621080 {main}( ) ..\weathermap-cacti-plugin.php:0
2 0.1132 7323824 weathermap_get_valid_tabs( ) ..\weathermap-cacti-plugin.php:260

Network Weathermaps automatically cycle between full-size maps)

Click on thumbnails for a full view (or you can automatically cycle between full-size maps)

( ! ) Warning: Invalid argument supplied for foreach() in C:\wamp\www\cacti\plugins\weathermap\weathermap-cacti-plugin.php on line 824
Call Stack
# Time Memory Function Location
1 0.0031 621080 {main}( ) ..\weathermap-cacti-plugin.php:0
2 0.1141 7323480 weathermap_thumbview( ) ..\weathermap-cacti-plugin.php:269
3 0.1158 7324560 weathermap_tabs( ) ..\weathermap-cacti-plugin.php:419
4 0.1158 7324560 weathermap_get_valid_tabs( ) ..\weathermap-cacti-plugin.php:838

[Howie]

(that's not a SQL error)

Does the weathermap_maps table exist in the database? Do any weathermap_* tables exist in the database?

[randybnl]

Uhm... no but i thought i added them.

It's this, right?

CREATE TABLE weathermap_maps (
id int(11) NOT NULL auto_increment,
sortorder int(11) NOT NULL default 0,
group_id int(11) NOT NULL default 1,
active set('on','off') NOT NULL default 'on',
configfile text NOT NULL,
imagefile text NOT NULL,
htmlfile text NOT NULL,
titlecache text NOT NULL,
filehash varchar (40) NOT NULL default '',
warncount int(11) NOT NULL default 0,
config text NOT NULL,
thumb_width int(11) NOT NULL default 0,
thumb_height int(11) NOT NULL default 0,
schedule varchar(32) NOT NULL default '*',
archiving set('on','off') NOT NULL default 'off',
PRIMARY KEY (id)
);

Could you please give me the right code?

[Howie]

You shouldn't need to add anything - the plugin is supposed to create it's own tables.

So... did you import the pa.sql when you installed the plugin architecture?

[randybnl]

You shouldn't need to add anything - the plugin is supposed to create it's own tables.

So... did you import the pa.sql when you installed the plugin architecture?

Yes, I did. But know I'm adding the tables manually and know its working, I think

I added auth, data, groups, maps, setting. With titles ofc