search

Cacti / plugin_gexport

Cacti Graph Export Plugin
GNU General Public License v2.0
12 stars 9 forks source link

SQL Assoc Failed #18

Closed dsclassen closed 7 years ago

dsclassen commented 7 years ago

I'm getting this error during graph export since pulling latest code.


2017/08/07 12:37:19 - CMDPHP SQL Backtrace: (/plugins/gexport/poller_export.php: 101 graph_export)(/plugins/gexport/functions.php: 118 run_export)(/plugins/gexport/functions.php: 160 exporter)(/plugins/gexport/functions.php: 353 export_graphs)(/plugins/gexport/functions.php: 707 get_associated_rras)(/lib/functions.php: 2863 db_fetch_assoc_prepared)(/lib/database.php: 386 cacti_debug_backtrace)
--
2017/08/07 12:37:19 - DBCALL ERROR: SQL Assoc Failed!, Error: Unknown column 'dspr.timespan' in 'field list'
2017/08/07 12:37:19 - DBCALL ERROR: SQL Assoc Failed!, Error:1054, SQL:'SELECT DISTINCT SQL_NO_CACHE dspr.id, dsp.step, dspr.steps, dspr.rows, dspr.name, dtd.rrd_step, dspr.timespan FROM graph_templates_item AS gti LEFT JOIN data_template_rrd AS dtr ON gti.task_item_id=dtr.id LEFT JOIN data_template_data AS dtd ON dtr.local_data_id = dtd.local_data_id LEFT JOIN data_source_profiles AS dsp ON dtd.data_source_profile_id=dsp.id LEFT JOIN data_source_profiles_rra AS dspr ON dsp.id=dspr.data_source_profile_id AND dtd.local_data_id != 0 WHERE gti.local_graph_id = ? AND dspr.id IS NOT NULL ORDER BY dspr.steps'
cigamit commented 7 years ago

You need to upgrade fully to 1.1.17. You took a few files from develop without updating your schema.