The following text in core/functions.inc.php:core_trunks_list()
generates a database error.
if ($amp_conf["AMPDBENGINE"] == "sqlite3")
{
// TODO: sqlite work arround - diego
// TODO: WILL NOT WORK, need to remove the usage of SUBSTRING
// need to reorder the trunks in PHP code
$sqlstr = "SELECT t.variable, t.value, d.value state FROM `globals` t ";
$sqlstr .= "JOIN (SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE 'OUTDISABLE\_%') d ";
$sqlstr .= "ON substring(t.variable,5) = substring(d.variable,12) WHERE t.variable LIKE 'OUT\_%' ";
$sqlstr .= "UNION ALL ";
$sqlstr .= "SELECT v.variable, v.value, concat(substring(v.value,1,0),'off') state FROM `globals` v ";
$sqlstr .= "WHERE v.variable LIKE 'OUT\_%' AND concat('OUTDISABLE_',substring(v.variable,5)) NOT IN ";
$sqlstr .= " ( SELECT variable from globals WHERE variable LIKE 'OUTDISABLE\_%' ) ";
$sqlstr .= "ORDER BY variable";
//$unique_trunks = sql("SELECT * FROM globals WHERE variable LIKE 'OUT_%' ORDER BY variable","getAll");
$unique_trunks = sql($sqlstr,"getAll");
}
The error:
sqlite> 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\_%' );
SQL error: no such column: d.value
The table:
sqlite> .schema globals
CREATE TABLE `globals` (
`variable` char(20) NOT NULL default '',
`value` char(50) NOT NULL default '',
PRIMARY KEY (`variable`)
);
