Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Reportit error message

 
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General
Author Message
jcotton



Joined: 27 Jun 2005
Posts: 25
PostPosted: Mon Jun 23, 2008 11:50 am    Post subject: Reportit error message Reply with quote
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?
Back to top
browniebraun
Cacti User


Joined: 13 Jun 2006
Posts: 329
Location: Cologne, Germany
PostPosted: Mon Jun 23, 2008 1:24 pm    Post subject: Re: Reportit error message Reply with quote
jcotton wrote:
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:

Best regards
-Andreas-
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group