Reportit error message

[jcotton]

Hi,

Cacti 0.8.7b
MySQL 4.1
RRDTool 1.2

I just installed ReportIt and I am getting the following error in my Cacti Log File after each polling cycle....

06/23/2008 09:45:31 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SHOW TABLE STATUS WHERE `Name` LIKE 'reportit_tmp_%' AND (UNIX_TIMESTAMP(`Update_time`) + 300) <= UNIX_TIMESTAMP()"

Any ideas?

[browniebraun]

Hi,

Cacti 0.8.7b
MySQL 4.1
RRDTool 1.2

I just installed ReportIt and I am getting the following error in my Cacti Log File after each polling cycle....

06/23/2008 09:45:31 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SHOW TABLE STATUS WHERE `Name` LIKE 'reportit_tmp_%' AND (UNIX_TIMESTAMP(`Update_time`) + 300) <= UNIX_TIMESTAMP()"

Any ideas?

Reportit v0.6.x requires MySQL 5.0.3 or above per default. There's a patch available for 0.6.1 to get it working with lower versions:

• patch_reportit_v061_mysql4.tar.gz
  patch_reportit_v061_mysql4.zip

Best regards
-Andreas-