Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL.......

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
fsantiago1979
Posts: 1
Joined: Fri Aug 03, 2012 3:34 pm

Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL.......

Post by fsantiago1979 »

my cacti log is full of line after line consisting of:
'CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:........'

i'm running centos 6.3 on a Linode VPS.
as far as i can tell, i have the latest versions of apache, mysql, php, rrdtool, cacti, spine poller, net-snmp, etc...... and all prerequisites according to the online docs.

so far, i've tried both the cmd.php poller as well as spine to see if that made any difference but i see none. i don't really think that's the issue but i had no clue where else to look. i've gone over my sql tables and made some changes as noted in other forum topics, but with no luck.

when i look around the settings pages and make changes followed by a save, it all seems to work fine (no errors on web gui), but my logs are full of the above mentioned errors. needless to say, i have no graphs being presented to me. just a blank page with the graph navigation buttons but nothing more.

any help would be greatly appreciated and I am able to provide any requested information. thanks.

Fabe S.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL...

Post by gandalf »

You surely googled the mysql error code; it's an "unknown column". So I fear that code and db layout do not match. Which Cacti version are you at?
R.
Maximeva
Posts: 17
Joined: Mon Oct 08, 2012 9:49 am

Re: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL...

Post by Maximeva »

Same problem here.. I used the package windows ( I use Windows 7 )
Post Reply

Who is online

Users browsing this forum: manuelx89 and 1 guest