FreePBX System Status
FreePBX Notices
*
Critical Error Asterisk Manager Connection Failure
Ignore this
Failed to connect to the Asterisk manager through port: 5038
Added 1 days, 21 hours, 17 minutes ago
(retrieve_conf.FATAL)
show all
FATAL ERROR
SELECT t.variable, t.value, d.value state FROM `globals` t JOIN (SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE 'OUTDISABLE\\_%') d ON substring(t.variable,5) = substring(d.variable,12) WHERE t.variable LIKE 'OUT\\_%' UNION ALL SELECT v.variable, v.value, concat(substring(v.value,1,0),'off') state FROM `globals` v WHERE v.variable LIKE 'OUT\\_%' AND concat('OUTDISABLE_',substring(v.variable,5)) NOT IN ( SELECT variable from globals WHERE variable LIKE 'OUTDISABLE\\_%' ) ORDER BY RIGHT( variable, LENGTH( variable ) - 4 )+0 [nativecode=1064 ** You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE]SQL -
SELECT t.variable, t.value, d.value state FROM `globals` t JOIN (SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE 'OUTDISABLE\\_%') d ON substring(t.variable,5) = substring(d.variable,12) WHERE t.variable LIKE 'OUT\\_%' UNION ALL SELECT v.variable, v.value, concat(substring(v.value,1,0),'off') state FROM `globals` v WHERE v.variable LIKE 'OUT\\_%' AND concat('OUTDISABLE_',substring(v.variable,5)) NOT IN ( SELECT variable from globals WHERE variable LIKE 'OUTDISABLE\\_%' ) ORDER BY RIGHT( variable, LENGTH( variable ) - 4 )+0