• Symphony Fatal Database Error: 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

    An error occurred while attempting to execute the following 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
  • Backtrace
    • [/home/phoenl/public_html/symphony/lib/toolkit/class.mysql.php:459]
    •     MySQL->__error();
    • [/home/phoenl/public_html/symphony/lib/toolkit/class.mysql.php:655]
    •     MySQL->query();
    • [/home/phoenl/public_html/symphony/lib/toolkit/data-sources/class.datasource.navigation.php:89]
    •     MySQL->fetch();
    • [/home/phoenl/public_html/symphony/lib/toolkit/class.datasource.php:128]
    •     NavigationDatasource->execute();
    • [/home/phoenl/public_html/symphony/lib/toolkit/class.frontendpage.php:825]
    •     DataSource->grab();
    • [/home/phoenl/public_html/symphony/lib/toolkit/class.frontendpage.php:411]
    •     FrontendPage->processDatasources();
    • [/home/phoenl/public_html/symphony/lib/toolkit/class.frontendpage.php:183]
    •     FrontendPage->__buildPage();
    • [/home/phoenl/public_html/symphony/lib/core/class.frontend.php:103]
    •     FrontendPage->generate();
    • [/home/phoenl/public_html/index.php:25]
    •     Frontend->display();
  • Database Query Log
    • [0.0004] SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8';
    • [0.0001] SET CHARACTER SET 'utf8';
    • [0.0021] SELECT SQL_CACHE t1.name, t2.page, t2.delegate, t2.callback FROM `sym_extensions` as t1 INNER JOIN `sym_extensions_delegates` as t2 ON t1.id = t2.extension_id WHERE t1.status = 'enabled' ORDER BY t2.delegate, t1.name;
    • [0.0003] SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = '6bcebuqrsilsm527ifghb3o6h0' LIMIT 1;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` = 'restaurante' AND `handle` = 'restaurant-babel' LIMIT 1;
    • [0.0003] SELECT SQL_CACHE type FROM `sym_pages_types` AS pt WHERE pt.page_id = 17 GROUP BY pt.type ORDER BY pt.type ASC;
    • [0.0004] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (1);
    • [0.0005] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`section_id` = '1' ORDER BY `e`.`id`DESC LIMIT 0, 1;
    • [0.0006] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 1 AND `element_name` IN ('titlu-site', 'url-engleza', 'titlu-h1-prima-pagina', 'link-rezervare-online', 'links-hoteluri', 'adresa-and-telefon', 'links-footer', 'slideshow') ORDER BY `sortorder` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_1` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_2` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_5` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_6` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_9` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_10` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_59` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_15` WHERE `entry_id` IN (2) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE `section_id` FROM `sym_entries` WHERE `id` = '573' LIMIT 1;
    • [0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (2);
    • [0.0004] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`id` IN ('573', '96', '98', '97', '95', '3', '108', '101', '100', '99', '92', '93', '103', '107') AND `e`.`section_id` = '2' ORDER BY `e`.`id`DESC;
    • [0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 2 ORDER BY `sortorder` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_3` WHERE `entry_id` IN (573,108,107,103,101,100,99,98,97,96,95,93,92,3) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_4` WHERE `entry_id` IN (573,108,107,103,101,100,99,98,97,96,95,93,92,3) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE `section_id` FROM `sym_entries` WHERE `id` = '4' LIMIT 1;
    • [0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (3);
    • [0.0003] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`id` IN ('4', '52', '53', '54', '55') AND `e`.`section_id` = '3' ORDER BY `e`.`id`DESC;
    • [0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 3 ORDER BY `sortorder` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_7` WHERE `entry_id` IN (55,54,53,52,4) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_8` WHERE `entry_id` IN (55,54,53,52,4) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE `section_id` FROM `sym_entries` WHERE `id` = '1' LIMIT 1;
    • [0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (4);
    • [0.0002] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`, UNIX_TIMESTAMP(e.`modification_date`) AS `modification_date` FROM `sym_entries` AS `e` WHERE 1 AND `e`.`id` IN ('1', '5') AND `e`.`section_id` = '4' ORDER BY `e`.`id`DESC;
    • [0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 4 ORDER BY `sortorder` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_11` WHERE `entry_id` IN (5,1) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_12` WHERE `entry_id` IN (5,1) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_13` WHERE `entry_id` IN (5,1) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_14` WHERE `entry_id` IN (5,1) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(1,2,5,6,9,59,15);
    • [0.0003] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (1,2,59);
    • [0.0003] SELECT SQL_CACHE * FROM `sym_fields_subsectionmanager` WHERE `field_id` IN (5,9,15);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` IN (6);
    • [0.0003] SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled';
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(3);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (3);
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(4);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (4);
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(7);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (7);
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(8);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (8);
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(11);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (11);
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(12);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (12);
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(13);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_uniqueupload` WHERE `field_id` IN (13);