Symphony Fatal Error: MySQL Error (3065): Expression #1 of ORDER BY clause is not in SELECT list, references column 'phoenl_luxury.p.sortorder' which is not in SELECT list; this is incompatible with DISTINCT in query: SELECT SQL_CACHE DISTINCT p.id, p.title, p.handle, (SELECT COUNT(id) FROM `sym_pages` WHERE parent = p.id) AS children
FROM `sym_pages` AS p
LEFT JOIN `sym_pages_types` AS pt ON (p.id = pt.page_id)
WHERE 1 = 1
AND p.parent IS NULL
ORDER BY p.`sortorder` ASC
An error occurred in /home/phoenl/public_html/symphony/lib/toolkit/class.mysql.php
around line 807
- 802
'msg' => $msg,
- 803
'num' => $errornum
- 804
));
- 805
}
- 806
- 807
throw new DatabaseException(__('MySQL Error (%1$s): %2$s in query: %3$s', array($errornum, $msg, $this->_lastQuery)), array(
- 808
'msg' => $msg,
- 809
'num' => $errornum,
- 810
'query' => $this->_lastQuery
- 811
));