[ZBX-4598] Cannot add host from frontend Created: 2012 Jan 30  Updated: 2017 May 30  Resolved: 2012 Feb 02

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.9 (beta)
Fix Version/s: 2.0.0rc1

Type: Incident report Priority: Blocker
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

rev 25069.


Issue Links:
Duplicate
is duplicated by ZBX-4654 Can't add any template to host, Error... Closed

 Description   

I'm trying add host and receive this errors:
Undefined variable: rows [include/triggers.inc.php:301]
Undefined variable: rows [include/triggers.inc.php:301]
Undefined variable: rows [include/triggers.inc.php:301]
Undefined variable: rows [include/triggers.inc.php:301]
Undefined variable: rows [include/triggers.inc.php:301]
Undefined variable: rows [include/triggers.inc.php:301]
Undefined variable: rows [include/triggers.inc.php:301]
Undefined variable: rows [include/triggers.inc.php:301]
mysql_real_escape_string() expects parameter 1 to be string, array given [include/db.inc.php:616]
mysql_real_escape_string() expects parameter 1 to be string, array given [include/db.inc.php:616]
Error in query [INSERT INTO auditlog_details (auditdetailid,auditid,table_name,field_name,oldvalue,newvalue) VALUES (5885,43941,'','hosts',Array,Array)] [Unknown column 'Array' in 'field list']



 Comments   
Comment by richlv [ 2012 Jan 31 ]

most likely the same as ZBX-4596

Comment by Oleksii Zagorskyi [ 2012 Jan 31 ]

I cannot reproduce it anyhow in r25095
Alexey, please describe details how you add the host.

Comment by Alexey Pustovalov [ 2012 Jan 31 ]

try to clone host with templates

Comment by Alexey Pustovalov [ 2012 Jan 31 ]

error is started receive after svn log -r25039
------------------------------------------------------------------------
r25039 | pavels | 2012-01-26 21:02:35 +0600 (Чтв, 26 Янв 2012) | 4 lines

..F....... ZBX-4558 added audit logging when udpating and creating triggers
A.F....... ZBX-4558 fixed deleting child template triggers when moving a trigger to a template
A......... ZBX-4558 fixed child template trigger attributes being reset when updating a template trigger
..F....... ZBX-4558 fixed trigger form "type" field value being inverted
------------------------------------------------------------------------

Comment by Alexey Pustovalov [ 2012 Jan 31 ]

it is trouble saving in rev 25100.
Bug appears when trying add new host and with cloning hosts. New hosts must containing triggers.

Comment by Oleksii Zagorskyi [ 2012 Jan 31 ]

The problem appears when I'm trying to link a template which has at least one trigger:

mysql_real_escape_string() expects parameter 1 to be string, array given [include/db.inc.php:616]
mysql_real_escape_string() expects parameter 1 to be string, array given [include/db.inc.php:616]
Error in query [INSERT INTO auditlog_details (auditdetailid,auditid,table_name,field_name,oldvalue,newvalue) VALUES (4085,210998,'','hosts',Array,Array)] [Unknown column 'Array' in 'field list']

And I cannot reproduce anyhow mentioned error: "Undefined variable: rows [include/triggers.inc.php:301]

Actually no problems with just host creation.

Comment by Pavels Jelisejevs (Inactive) [ 2012 Feb 01 ]

(1) Another problem caused by ZBX-4558: when cloning a host with templated triggers, these triggers are deleted from the original host.

<pavels> RESOLVED.
<Sasha> CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2012 Feb 02 ]

RESOLVED.

Comment by Oleksii Zagorskyi [ 2012 Feb 02 ]

(2) I'm using this dev branch for usual work (because it works better than current trunk ) and I've observed one problem:
Open items list for some host, move mouse over "Triggers (1)" value in the Triggers column -> a tool-tip with the triggers details doesn't appear. On the mouse click doesn't appear too.
REOPENED.

<zalex> meh, the problem reproducible even on the rev 25142 (a base of copy this dev branch). This problem already fixed today in the trunk rev 25162.
Status changed to RESOLVED again.
CLOSED.

Comment by Alexander Vladishev [ 2012 Feb 08 ]

Successfully tested!

Comment by Pavels Jelisejevs (Inactive) [ 2012 Feb 08 ]

Merged to trunk r25260.

CLOSED.

Comment by Alexey Serba [ 2012 Mar 13 ]

Is there any workaround/patch to make "link template" working on 1.9.9 release?

Comment by Oleksii Zagorskyi [ 2012 Mar 13 ]

You may consider this page: http://www.zabbix.org/wiki/How_to/trunk_db_patches

Generated at Sat Apr 27 04:41:57 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.