CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064',

[adnanmir]

Hi All, I am experiencing these below mentioned errors in my weather map installation on windows 7 machine, Please help me in rectifying these problems : 19:23 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select distinct id,title,imagecache from superlinks_pages, superlinks_auth where superlinks_pages.id=superlinks_auth.pageid and style='TAB' and (userid=1 or userid=0) order by sortorder,id"

3/17/2012 04:19:23 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE quicktree_graphs ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL, local_graph_id mediumint(8) unsigned NOT NULL default '0', rra_id smallint(8) unsigned NOT NULL default '0', title varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;'

Cacti Version 0.8.7i Cacti OS win32 SNMP Version NET-SNMP version: 5.5 RRDTool Version RRDTool 1.4.x PHP Version 5.3.8 PHP OS WINNT PHP uname Windows NT HOME-PC 6.1 build 7601 (Windows 7 Ultimate Edition Service Pack 1) i586 PHP SNMP Installed max_execution_time 60 memory_limit 128M

[gandalf]

Moving to weathermap forum
R.

[adnanmir]

Hi gandalf , i would be very happy if you can please resolve my query.
Regards
A.M

[gandalf]

I can't, else I had done it already
So the best I can do by now is to make the plugin owner and the community aware of your question.
R.

[adnanmir]

That would be great to know, thanks for heaps i am waiting for some one to respond to me , desperate.

[msaum]

Try looking for that CREATE TABLE statement in the setup.php, and change TYPE=MyISAM to ENGINE=MyISAM

I think some recent version of MySQL deprecated the older keyword.(This actually came from howie@thingy.com after I emailed him.)
Worked for me..table was built after I uninstalled and reinstalled/enabled the plugin...
Cacti: 0.8.8a
PIA: 3.1
Ubuntu Server 12.04

[thomaslam]

Try looking for that CREATE TABLE statement in the setup.php, and change TYPE=MyISAM to ENGINE=MyISAM

I think some recent version of MySQL deprecated the older keyword.(This actually came from howie@thingy.com after I emailed him.)
Worked for me..table was built after I uninstalled and reinstalled/enabled the plugin...
Cacti: 0.8.8a
PIA: 3.1
Ubuntu Server 12.04

Hi,

I've just upgraded to ubuntu server 12.04, Cacti 8.8a-3 and PIA 3.1 having the same problem with superlinks 1.4.2

can you show me how you fix yours?

bregards.

08/20/2012 02:16:30 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT id, title, imagecache FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='TAB' AND (userid=77 OR userid=0) AND disabled='' ORDER BY sortorder, id"
08/20/2012 02:16:17 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT id, title, imagecache FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='TAB' AND (userid=77 OR userid=0) AND disabled='' ORDER BY sortorder, id"

[msaum]

Hi thomaslam,
Did you edit the setup.php file?

[alieen12]

Cacti Version 0.8.7i Cacti OS win32 SNMP Version NET-SNMP version: 5.5 RRDTool Version RRDTool 1.4.x PHP Version 5.3.8 PHP OS WINNT PHP uname Windows NT HOME-PC 6.1 build 7601 (Windows 7 Ultimate Edition Service Pack 1) i586 PHP SNMP Installed max_execution_time 60 memory_limit 128M