I allready installed reportit. But it seems confusing for me . I got the following messages from cacti log file
07/26/2009 07:32:50 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT a.id, a.template_id FROM reportit_reports as a INNER JOIN reportit_templates as b ON b.locked = 0 AND a.template_id = b.id WHERE a.scheduled = 1 AND a.frequency = 'daily'"
My system info is as follows:
O.S Red Hat Enterprise Linux Server release 5.1 (Tikanga)
Mysql 5.0.22
PHP 5.1.6
Apache/2.2.3
Cacti 0.8.7e
Plugin Architecture 2.4
reportit 0.7.1
0 0 * * * root /usr/bin/php /var/www/html/cacti/plugins/reportit/runtime.php -d > /dev/null 2>&1
This is added at crontab
Please advice me . Thanks in advance.
Br
Hasan
REPORTIT: SQL Error
Moderators: Developers, Moderators
Who is online
Users browsing this forum: No registered users and 6 guests