Error on duplication of graph template

[Rno]

I try to duplicate the Interface - Traffic (bits/sec) to Interface - Traffic (bits/sec) plus/minus
and i have this error:
Sorry we could not process your last action
SQL save on table 'snmp_query_graph' Column 'snmp_query_graph_id' does not exist unable to save

but the copy did succeed

[netniV]

Is this reproducible? Can you list the steps that you took when ensuring it's reproducible?

[netniV]

Also, which server is this on as I noticed your signature has two vastly different versions?

[Rno]

Well on betta discussion, it's done on 1.2 beta

Yes it's reproducible take a graph from graph template, then do the action duplicate
and :
Sorry, we could not process your last action.

SQL Save on table 'snmp_query_graph': Column 'snmp_query_graph_id' does not exist, unable to save!

[netniV]

Is there a stack trace with the SQL error?

[Rno]

I got that in the log:
2018/10/29 09:05:14 - CMDPHP SQL Backtrace: (/graph_templates.php[49]:form_actions(), /graph_templates.php[261]:api_duplicate_graph(), /lib/api_graph.php[390]:sql_save())
2018/10/29 09:05:14 - DBCALL ERROR: SQL Save on table 'snmp_query_graph': Column 'snmp_query_graph_id' does not exist, unable to save!

[netniV]

Is this logged on GitHub? If not, open one up whilst I'm looking into it.

[netniV]

Can you do me a favour though, try describing the SQL table:

Code: Select all

desc snmp_query_graph;
+-------------------+-----------------------+------+-----+---------+----------------+
| Field             | Type                  | Null | Key | Default | Extra          |
+-------------------+-----------------------+------+-----+---------+----------------+
| id                | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| hash              | varchar(32)           | NO   |     |         |                |
| snmp_query_id     | mediumint(8) unsigned | NO   | MUL | 0       |                |
| name              | varchar(100)          | NO   |     |         |                |
| graph_template_id | mediumint(8) unsigned | NO   | MUL | 0       |                |
+-------------------+-----------------------+------+-----+---------+----------------+

It should look like that.

[Rno]

Code: Select all

MariaDB [cacti]> desc snmp_query_graph;
+-------------------+-----------------------+------+-----+---------+----------------+
| Field             | Type                  | Null | Key | Default | Extra          |
+-------------------+-----------------------+------+-----+---------+----------------+
| id                | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| hash              | varchar(32)           | NO   |     |         |                |
| snmp_query_id     | mediumint(8) unsigned | NO   | MUL | 0       |                |
| name              | varchar(100)          | NO   |     |         |                |
| graph_template_id | mediumint(8) unsigned | NO   | MUL | 0       |                |
+-------------------+-----------------------+------+-----+---------+----------------+

And bug open on github