[dev.icinga.com #3492] Column not found: 1054 Unknown column 'host_status' in 'where clause'

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/3492

Created by mfriedrich on 2012-12-12 17:03:30 +00:00

Assignee: jmosshammer
Status: Resolved (closed on 2013-02-11 16:39:29 +00:00)
Target Version: 1.8.2
Last Update: 2013-02-11 16:39:36 +00:00 (in Redmine)

Icinga Version: 1.8.3
Icinga Web Version: 1.8.1-filter
IDO Version: 1.8.3
OS Version: OpenSUSE 12.2
DB Type: MySQL
DB Version: 5.5.25a
Browser Version: IE 8.0

---

Happens with the git branch jsmosshammer/filtering (commits from yesterday, todays fixes do not seem to contain for this case)

directly when the first initial setup is done, ido2db populating the database with services, does not happen later then, but still, it produces errors on web and logs. should be fixed, likely it's a missing table attribute for that column.

[Wed Dec 12 17:54:49 2012] [fatal] Uncaught Doctrine_Connection_Mysql_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'host_status' in 'where clause'. Failing Query: "SELECT DISTINCT i.icon_image AS i__0, i2.instance_name AS i2__1, i.host_object_id AS i__2, i4.name1 AS i4__3, i.alias AS i__4, i.display_name AS i__5, i3.current_state AS i3__6, (CASE WHEN i3.last_state_change<='1970-01-01 00:00:00' THEN i5.program_start_time ELSE i3.last_state_change END) AS i__7, i3.last_check AS i3__8, i3.next_check AS i3__9, i5.program_start_time AS i5__10, i3.output AS i3__11, i3.current_check_attempt AS i3__12, i3.max_check_attempts AS i3__13, i3.process_performance_data AS i3__14, i3.max_check_attempts AS i3__15, i3.perfdata AS i3__16, i2.instance_id AS i2__17, i.host_id AS i__18, i.action_url AS i__19, i.notes AS i__20, i.notes_url AS i__21, (i3.has_been_checked-1)*-1 AS i__22, i3.notifications_enabled AS i3__23, i3.problem_has_been_acknowledged AS i3__24, i3.scheduled_downtime_depth AS i3__25, i3.has_been_checked AS i3__26 FROM icinga_hosts i LEFT JOIN icinga_instances i2 ON i.instance_id = i2.instance_id LEFT JOIN icinga_hoststatus i3 ON i.host_object_id = i3.host_object_id LEFT JOIN icinga_objects i4 ON i.host_object_id = i4.object_id LEFT JOIN icinga_programstatus i5 ON i2.instance_id = i5.instance_id WHERE (i.config_type = '1' AND host_status = '0' AND i3.has_been_checked = '1') ORDER BY i.host_object_id ASC LIMIT 25" (/usr/share/icinga-web/lib/doctrine/lib/Doctrine/Connection.php:1090)

Changesets

2012-12-19 09:58:24 +00:00 by jmosshammer a0fbc01

Added host_status field for host view, should fix #3492 (refs #3492)

2012-12-20 15:35:51 +00:00 by jmosshammer b36db4f

Added host_status field for host view, should fix #3492 (refs #3492)

[icinga-migration]

Updated by mfrosch on 2013-02-11 16:39:29 +00:00

• Status changed from New to Resolved
• Assigned to set to jmosshammer
• Target Version set to 1.8.2

[icinga-migration]

Updated by mfrosch on 2013-02-11 16:39:36 +00:00

• Done % changed from 0 to 100