CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146 -

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
HostMyApple
Posts: 1
Joined: Fri Sep 24, 2010 10:03 am

CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146 -

Post by HostMyApple »

Hello,

I have a fresh install of Cacti. I am not able to see any graphs in Cacti, I also receive this error message in the Cacti log file:


09/24/2010 11:01:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file,
ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook =
'draw_navigation_text' AND ph.name IN ('settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function
FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook =
'draw_navigation_text' AND ph.name NOT IN ('settings', 'boost', 'dsstats') ORDER BY id ASC"

I searched the forum and did not find a proper solution to this issue.
Has anyone seen this before and if so do you know how to resolve it?

Thank You
Brent
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

MySQL error 1146 means the table doesn't exist (thanks google!)

You haven't installed the pa.sql tables yet. please follow the PIA documentation.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests