[Solved] superlinks 1.4.2

[thomaslam]

Hi,

I just couldn't get the superlinks to work, can anyone help?

here's the logs.
08/31/2012 04:29:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', 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/31/2012 04:29:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', 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"


Cacti Version 0.8.8a
Cacti OS unix
SNMP Version NET-SNMP version: 5.4.3
RRDTool Version RRDTool 1.4.x
Hosts 351
Graphs 4475

[thomaslam]

I know one of the solution is to drop the superlinks database?

how do i do that? mysql> drop database superlinks; ?

[thomaslam]

Finally solved.

mysql> drop table superlinks_auth;
mysql> drop table superlinks_pages;

and recreate the table manually to work

CREATE TABLE superlinks_pages(
id int(11) NOT NULL auto_increment,
sortorder int(11) NOT NULL default 0,
disabled char(2) NOT NULL default '',
contentfile text NOT NULL,
title text NOT NULL,
style varchar(10) NOT NULL DEFAULT 'TAB',
extendedstyle varchar(50) NOT NULL DEFAULT '',
imagecache varchar(60) NOT NULL DEFAULT '',
PRIMARY KEY (id)
) ENGINE=MyISAM;

CREATE TABLE superlinks_auth (
userid mediumint(9) NOT NULL default '0',
pageid int(11) NOT NULL default '0'
) ENGINE=MyISAM;

[Rich88]

Thanks so much!
Glad to see the issue solved, it kept me worried for a while.