CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_time

Error:
12/06/2016 08:23:29 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:"select  poller_output.output,  poller_output.time,
UNIX_TIMESTAMP(poller_output.time) as unix_time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num
from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)
order by poller_output.local_data_id  LIMIT 10000"

Solution:

1. Check the MariaDB for poller_output table in cacti Database. The table was not there.

MariaDB [cacti]> DESCRIBE poller_output;
ERROR 1017 (HY000): Can't find file: 'poller_output' (errno: 2)

2. Tried to Drop the table.

MariaDB [cacti]> DROP TABLE poller_output;
ERROR 1051 (42S02): Unknown table 'poller_output'

3. Checked the cacti.sql file and Picked the Paramater for poller_output table.

4. Created the The table.
MariaDB [cacti]> CREATE TABLE poller_output (
    ->   local_data_id mediumint(8) unsigned NOT NULL default '0',
    ->   rrd_name varchar(19) NOT NULL default '',
    ->   time datetime NOT NULL default '0000-00-00 00:00:00',
    ->   output text NOT NULL,
    ->   PRIMARY KEY (local_data_id,rrd_name,time) /*!50060 USING BTREE */
    -> ) ENGINE=MyISAM;
Query OK, 0 rows affected (0.00 sec)

5. Checked the  poller_time table as it was in Error string, though it was okay. So left it untouched.

MariaDB [cacti]> DESCRIBE poller_time;
+------------+-----------------------+------+-----+---------------------+----------------+
| Field      | Type                  | Null | Key | Default             | Extra          |
+------------+-----------------------+------+-----+---------------------+----------------+
| id         | mediumint(8) unsigned | NO   | PRI | NULL                | auto_increment |
| pid        | int(11) unsigned      | NO   |     | 0                   |                |
| poller_id  | smallint(5) unsigned  | NO   |     | 0                   |                |
| start_time | datetime              | NO   |     | 0000-00-00 00:00:00 |                |
| end_time   | datetime              | NO   |     | 0000-00-00 00:00:00 |                |
+------------+-----------------------+------+-----+---------------------+----------------+
5 rows in set (0.00 sec)

MariaDB [cacti]> exit
Bye

6. The Error Stopped Now. Cheers.