Hi,

I have recently installed Observium and updated to the stable version.
I have successfully configured a number of alerts, however despite the alerts being generated (I see them via the web gui) I do not receive them to email.

Using test_alert.php -a 1 (see below) I am able to receive email, however the test email looks a little empty from what I would expect.

I receive the following error, see below for the debug.
ERROR[Error in query: (Incorrect table name '') 1103]

Any guidance will be appreciated.

Thanks
Laurence


-------------------------------------------------------------------------------------------
ALERTModify
Alert
Entity
Metrics
DurationUnknown
Device
Device
Hardware
Operating System
Location
UptimeNever polled

E-mail sent to: laurence@mydomain.com
E-mail sent at: Sun, 31 Jul 2016 16:33:53 +0300


./test_alert.php -a 1 
Observium 0.16.7.8003
Test Alert Notification


#####  Software versions  #####

 o OS                   Linux 3.5.0-23-generic [amd64] (Ubuntu 12.04)
 o Apache               2.2.22
 o PHP                  5.3.10-1ubuntu3.23
 o Python               2.7.3
 o MySQL                5.5.46-0ubuntu0.12.04.2 (extension: mysqli 5.5.46)
 o SNMP                 NET-SNMP 5.4.3
 o RRDtool              1.4.7

#####  MySQL mode  #####

 o MySQL                

#####  Charset info  #####

 o PHP                  UTF-8
 o MySQL                utf8

#####  Timezones info  #####

 o Date                 Sunday, 31-Jul-16 16:33:53 IDT
 o PHP                  +03:00
 o MySQL                +03:00

 o Notifying            [email] : {"email":"laurence@mydomain.com"}
root@observiumsrv:/opt/observium# ./test_alert.php -a 1 -d 
DEBUG!

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';]
SQL RUNTIME[0.00009990s]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00012803s]

SQL[SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'current_rev';]
SQL RUNTIME[0.00007296s]

SQL[SELECT * FROM `config`]
SQL RUNTIME[0.00008488s]

CMD[/bin/hostname -f]

CMD EXITCODE[0]
CMD RUNTIME[0.0017s]
STDOUT[
observiumsrv.mydomain.com
]
Observium 0.16.7.8003
Test Alert Notification


CMD[/opt/observium/scripts/distro]

CMD EXITCODE[0]
CMD RUNTIME[0.038s]
STDOUT[
Linux|3.5.0-23-generic|amd64|Ubuntu|12.04
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0025s]
STDOUT[
Python 2.7.3
]

SQL[SELECT version();]
SQL RUNTIME[0.00017810s]

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

CMD EXITCODE[0]
CMD RUNTIME[0.002s]
STDOUT[
NET-SNMP version: 5.4.3
]

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

CMD EXITCODE[0]
CMD RUNTIME[0.0036s]
STDOUT[
RRDtool 1.4.7  Copyright 1997-2012 by Tobias Oetiker <tobi@oetiker.ch>
]

CMD[date "+%:z"]

CMD EXITCODE[0]
CMD RUNTIME[0.0016s]
STDOUT[
+03:00
]

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

CMD[/usr/bin/env apache2 -v | awk '/Server version:/ {print $3}']

CMD EXITCODE[0]
CMD RUNTIME[0.0132s]
STDOUT[
Apache/2.2.22
]

SQL[SELECT @@SESSION.sql_mode;]
SQL RUNTIME[0.00013804s]

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

#####  Software versions  #####

 o OS                   Linux 3.5.0-23-generic [amd64] (Ubuntu 12.04)
 o Apache               2.2.22
 o PHP                  5.3.10-1ubuntu3.23
 o Python               2.7.3
 o MySQL                5.5.46-0ubuntu0.12.04.2 (extension: mysqli 5.5.46)
 o SNMP                 NET-SNMP 5.4.3
 o RRDtool              1.4.7

#####  MySQL mode  #####

 o MySQL                

#####  Charset info  #####

 o PHP                  UTF-8
 o MySQL                utf8

#####  Timezones info  #####

 o Date                 Sunday, 31-Jul-16 16:34:23 IDT
 o PHP                  +03:00
 o MySQL                +03:00


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

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

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

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

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

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

SQL[SELECT * FROM `alert_contacts` WHERE `contact_disabled` = 0 AND `contact_id` IN (SELECT `contact_id` FROM `alert_contacts_assoc` WHERE `aca_type` = 'alert' AND `alert_checker_id` = '');]
SQL RUNTIME[0.00006199s]
 o Notifying            [email] : {"email":"laurence@mydomain.com"}

SQL[UPDATE `alert_log` set `notified` ='1' WHERE `event_id` = '']
SQL RUNTIME[0.00025702s]