Update Observium

I believe I ran into this. Not sure when it started but I have it on 8010. Every test alert I am sending out seems to always go to the default and not my other examples. I'll try a fresh pull from svn and hope that helps.

SQL[SELECT * FROM `alert_tests` WHERE 1]

ROWS[9]

SQL RUNTIME[0.00023103s]

Cached 9 alert rules.

SQL[SELECT * FROM `alert_assoc`]

ROWS[11]

SQL RUNTIME[0.00007796s]

SQL[SELECT * FROM `alert_table` WHERE `alert_table_id` = '1']

ROWS[0]

SQL RUNTIME[0.00026011s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '']

ROWS[0]

SQL RUNTIME[0.00010085s]

SQL[SELECT * FROM `` WHERE ``.`` = '']

ROWS[-1]

SQL RUNTIME[0.00009203s]

ERROR[Error in query: (Incorrect table name '') 1103]

SQL[SELECT * FROM `devices` WHERE `device_id` = '']

ROWS[0]

SQL RUNTIME[0.00010896s]

Dear my friend.... I resolved it... delete the complete folder "/opt/observium/includes" and the I do svn update. The problem was resolved! You can close the issue pls!?

rrd folder

Sorry, I cant understand you... RED Directory? Can you explain more? The directory of instalation is /opt/observium... So I have to delete what some folders. Which ones?

You seem to have somehow managed to break your observium installation, either via svn misbehaving or via unresolved local changes.

you should delete your installation and checkout a clean set of code.

if you retain your config.php and red directory, you won't lose any data.

OK. I executed

[root@observium observium]# php test_alert.php -a server -d
PHP Warning: Module 'ldap' already loaded in Unknown on line 0
DEBUG!

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00049996s]
Observium 0.15.10.7107
Test Alert Notification

CMD[/opt/observium/scripts/distro]

EXITCODE[0]
CMD RUNTIME[0.034s]
STDOUT[
Linux|2.6.32-504.8.1.el6.x86_64|amd64|CentOS|6.6
]

CMD[/usr/bin/env python --version 2>&1]

EXITCODE[0]
CMD RUNTIME[0.0023s]
STDOUT[
Python 2.6.6
]

SQL[SELECT version()]
SQL RUNTIME[0.00015998s]

CMD[/usr/bin/snmpget --version 2>&1]

EXITCODE[0]
CMD RUNTIME[0.0036s]
STDOUT[
NET-SNMP version: 5.5
]

CMD[/usr/bin/rrdtool --version |head -n1]

EXITCODE[0]
CMD RUNTIME[0.0029s]
STDOUT[
RRDtool 1.3.8 Copyright 1997-2009 by Tobias Oetiker <tobi@oetiker.ch>
]

SQL[SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);]
SQL RUNTIME[0.00018215s]

CMD[/usr/bin/env apache2 -v | awk '/Server version:/

']

EXITCODE[0]
CMD RUNTIME[0.0145s]
STDOUT[
Apache/2.2.15
]

1. 1. 1. 1. 1. Software versions #####

o OS Linux 2.6.32-504.8.1.el6.x86_64 [amd64] (CentOS 6.6)
o Apache 2.2.15
o PHP 5.4.44
o Python 2.6.6
o MySQL 5.1.73 (extension: mysqli 5.1.73)
o SNMP NET-SNMP 5.5
o RRDtool 1.3.8

SQL[SHOW VARIABLES LIKE 'character_set_connection']
SQL RUNTIME[0.00055885s]

1. 1. 1. 1. 1. Charset info #####

o PHP UTF-8
o MySQL utf8

1. 1. 1. 1. 1. Timezones info #####

o Date Monday, 26-Oct-15 18:43:24 UTC
o PHP +00:00
o MySQL -03:00

SQL[SELECT * FROM `alert_tests` WHERE 1]
SQL RUNTIME[0.00028396s]
Cached 9 alert rules.

SQL[SELECT * FROM `alert_assoc`]
SQL RUNTIME[0.00019002s]

SQL[SELECT * FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `alert_table`.`alert_table_id` = 'server']
SQL RUNTIME[0.00023198s]

SQL[SELECT * FROM `devices` WHERE `device_id` = '']
SQL RUNTIME[0.00021291s]

SQL[SELECT * FROM `` WHERE ``.`` = '']
SQL RUNTIME[0.00010991s]
ERROR[Error in query: (Incorrect table name '') 1103]

SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `alert_checker_id` = '');]
SQL RUNTIME[0.00021219s]
o Notifying [email] : email@server.com.ar
PHP Parse error: syntax error, unexpected '<<' (T_SL) in /opt/observium/includes/alerting/email.inc.php on line 157

Parse error: syntax error, unexpected '<<' (T_SL) in /opt/observium/includes/alerting/email.inc.php on line 157

How can I fix? I make svn update, but the error persist!

The alert_contacts_assoc table uses `contact_id`, not `alert_contact_id`.