Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY lft' at line 8
The SQL being executed was: SELECT tr.tree_id, tr.lft, tr.rgt, tr.level, tr.tree_update, tr.tree_pid, trl.*, v.*, vl.*
FROM
tree tr
LEFT OUTER JOIN tree_lang trl ON trl.tree_id = tr.tree_id AND trl.lang_kod = "ua"
RIGHT JOIN val_tree_6 v ON v.tree_id = tr.tree_id
LEFT JOIN val_tree_6_lang vl ON vl.tree_id = tr.tree_id AND vl.lang = "ua"

WHERE (tr.is_enable = "1" OR tr.is_enable IS NULL) AND tr.tree_pid=2067 AND tr.tree_id = ORDER BY lft

Error Info: Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY lft' at line 8
)
$_GET = [
    'tree_url' => '562101m',
];

$_SESSION = [
    '__flash' => [],
    'c_lang' => 'O:21:"common\\models\\SysLang":10:{s:36:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_attributes";a:9:{s:7:"lang_id";i:3;s:8:"lang_kod";s:2:"ua";s:9:"lang_name";s:20:"Українська";s:9:"lang_icon";s:0:"";s:14:"lang_shortname";s:2:"Ua";s:8:"lang_poz";i:2;s:8:"lang_def";i:1;s:11:"lang_enable";i:1;s:5:"local";s:5:"ua-UA";}s:39:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_oldAttributes";a:9:{s:7:"lang_id";i:3;s:8:"lang_kod";s:2:"ua";s:9:"lang_name";s:20:"Українська";s:9:"lang_icon";s:0:"";s:14:"lang_shortname";s:2:"Ua";s:8:"lang_poz";i:2;s:8:"lang_def";i:1;s:11:"lang_enable";i:1;s:5:"local";s:5:"ua-UA";}s:33:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_related";a:0:{}s:47:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_relationsDependencies";a:0:{}s:23:"' . "\0" . 'yii\\base\\Model' . "\0" . '_errors";N;s:27:"' . "\0" . 'yii\\base\\Model' . "\0" . '_validators";N;s:25:"' . "\0" . 'yii\\base\\Model' . "\0" . '_scenario";s:7:"default";s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:0:{}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";a:0:{}}',
];