[ZBX-11200] SQL error when adding a link between elements in maps Created: 2016 Sep 13 Updated: 2017 May 30 Resolved: 2016 Sep 14 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Frontend (F) |
Affects Version/s: | 3.0.3 |
Fix Version/s: | None |
Type: | Incident report | Priority: | Trivial |
Reporter: | Ilya Rudometov | Assignee: | Unassigned |
Resolution: | Won't fix | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
web-server ubuntu 16.04 Client ubuntu 16.04 |
Attachments: |
![]() |
Description |
map update fails, after adding connection |
Comments |
Comment by Aleksandrs Saveljevs [ 2016 Sep 13 ] |
Could you please elaborate a bit on the necessary steps to reproduce the error? |
Comment by Ilya Rudometov [ 2016 Sep 13 ] |
Create new map -> added two elements -> added link between the elements and click update map. ps Sorry for my english |
Comment by Aleksandrs Saveljevs [ 2016 Sep 14 ] |
Tried with both PHP 5.6.24 and PHP 7.0.8, but the issue did not manifest. Can you reproduce the problem on a fresh database (e.g., by creating a fresh installation, importing some hosts and maps required, and then trying the described scenario)? |
Comment by Ilya Rudometov [ 2016 Sep 14 ] |
There are new details. The base change was made manually via mysql two hosts are added, and the link between them. As I understand zabbix "thinks" that there is no such link and adding a link via a web interface receives an error. |
Comment by richlv [ 2016 Sep 14 ] |
sounds like no bug in zabbix then - your direct database modifications apparently have been incorrect |
Comment by Ilya Rudometov [ 2016 Sep 14 ] |
|
Comment by richlv [ 2016 Sep 14 ] |
please see http://zabbix.org/wiki/Getting_help for support options. in this specific case, you might have forgotten to update the 'ids' table |
Comment by Ilya Rudometov [ 2016 Sep 14 ] |
Ок, thanks for the help. |
Comment by Ilya Rudometov [ 2016 Sep 14 ] |
It is necessary to update zabbix.ids |
Comment by Aleksandrs Saveljevs [ 2016 Sep 14 ] |
Reopening to set the correct resolution... |
Comment by Aleksandrs Saveljevs [ 2016 Sep 14 ] |
Closing as "Won't fix" as per richlv's comments above. |