[SOLVED]superlinks issuse

[bacon]

Click the console tab when i installed the superlinks addons, and the cacti log display error:

Code: Select all

10/09/2011 09:23:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONT' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
10/09/2011 09:23:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONTTOP' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
10/09/2011 09:23:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONT' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
10/09/2011 09:23:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONTTOP' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
10/09/2011 09:23:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONT' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id"
10/09/2011 09:23:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISINCT id,title,contentfile FROM superlinks_pages, superlinks_auth WHERE superlinks_pages.id=superlinks_auth.pageid AND style='FRONTTOP' AND (userid=1 OR userid=0) AND disabled='' ORDER BY sortorder, id" 

It's a bug?

ps:
cacti:Version 0.8.7h
Plugin Architecture Version: 3.0
superlinks:superlinks-v1.2-1

[bacon]

Oh yeah ,it's working for me!

fix SQL issuse:

vi PREFIX/cacti/plugins/superlinks/setup.php

LINE 257:change "DISINCT" to "DISTINCT".

[TheWitness]

Great...