Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Mar 22, 2019 11:29 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Interesting Error or Anomaly
PostPosted: Thu Mar 07, 2019 2:04 pm 
Offline
Cacti User

Joined: Mon Oct 01, 2018 10:09 am
Posts: 103
Hello Again,
I have discovered an unusual error that show up in my cacti log.
I get these errors every time I go to Management,Devices, select a device, then select the datasource list,
then select a datasoure, and turn on the datasource info mode:

2019/03/07 18:18:40 - CMDPHP SQL Backtrace: (/data_sources.php: 77 ds_edit)(/data_sources.php: 1065 rrdtool_cacti_compare)(/lib/rrd.php: 2459 db_fetch_assoc_prepared)(/lib/database.php: 402 cacti_debug_backtrace)

2019/03/07 18:18:40 - DBCALL ERROR: SQL Assoc Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS ds' at line 1
2019/03/07 18:18:40 - DBCALL ERROR: SQL Assoc Failed!, Error:1064, SQL:'SELECT dspc.consolidation_function_id AS cf, dsp.x_files_factor AS xff, dspr.steps AS steps, dspr.rows AS rows FROM data_source_profiles AS dsp INNER JOIN data_source_profiles_cf AS dspc ON dsp.id=dspc.data_source_profile_id INNER JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id WHERE dsp.id = ? ORDER BY dspc.consolidation_function_id, dspr.steps'

The CMDPHP error is in blue in the logs display, and DBCALL ERROR is shown as red.

Any ideas on this one?
I am using cacti-1.1.38,mariadb10.2,redhat 6.10, and php 5.3.3, apache 2.0

Thanks
eholz1


Top
 Profile  
 
 Post subject: Re: Interesting Error or Anomaly
PostPosted: Thu Mar 07, 2019 6:06 pm 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2285
You need to either downgrade your version of MySQL/MariaDB or upgrade to Cacti 1.2.2

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Interesting Error or Anomaly
PostPosted: Mon Mar 11, 2019 3:53 pm 
Offline
Cacti User

Joined: Mon Oct 01, 2018 10:09 am
Posts: 103
Thanks Again,

I will downgrade the db, and see what happens

Thank,

eholz1


Top
 Profile  
 
 Post subject: Re: Interesting Error or Anomaly
PostPosted: Mon Mar 11, 2019 4:16 pm 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2285
tbh, you are better downgrading PHP

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: cigamit and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group