• Symphony Fatal Database Error: Unknown column 'astana' in 'where clause'

    An error occurred while attempting to execute the following query

    • 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` = '7' AND `e`.id IN (astana) ORDER BY `e`.`id`ASC
  • Backtrace
    • [/var/www/eco-msu/symphony/lib/toolkit/class.mysql.php:459]
    •     MySQL->__error();
    • [/var/www/eco-msu/symphony/lib/toolkit/class.mysql.php:655]
    •     MySQL->query();
    • [/var/www/eco-msu/symphony/lib/toolkit/class.entrymanager.php:387]
    •     MySQL->fetch();
    • [/var/www/eco-msu/symphony/lib/toolkit/class.entrymanager.php:594]
    •     EntryManager::fetch();
    • [/var/www/eco-msu/symphony/lib/toolkit/data-sources/class.datasource.section.php:436]
    •     EntryManager::fetchByPage();
    • [/var/www/eco-msu/symphony/lib/toolkit/class.datasource.php:128]
    •     SectionDatasource->execute();
    • [/var/www/eco-msu/symphony/lib/toolkit/class.frontendpage.php:825]
    •     DataSource->grab();
    • [/var/www/eco-msu/symphony/lib/toolkit/class.frontendpage.php:411]
    •     FrontendPage->processDatasources();
    • [/var/www/eco-msu/symphony/lib/toolkit/class.frontendpage.php:183]
    •     FrontendPage->__buildPage();
    • [/var/www/eco-msu/symphony/lib/core/class.frontend.php:103]
    •     FrontendPage->generate();
    • [/var/www/eco-msu/index.php:25]
    •     Frontend->display();
  • Database Query Log
    • [0.0002] SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8';
    • [0.0001] SET CHARACTER SET 'utf8';
    • [0.0011] 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.0002] SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = 'ciku1nevdi95pntb1q0nic8nk6' LIMIT 1;
    • [0.0003] SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled';
    • [0.0003] SELECT SQL_CACHE * FROM sym_url_router;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` = 'document' AND `handle` = 'astana' LIMIT 1;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'document' LIMIT 1;
    • [0.0003] SELECT SQL_CACHE type FROM `sym_pages_types` AS pt WHERE pt.page_id = 159 GROUP BY pt.type ORDER BY pt.type ASC;
    • [0.0003] SELECT SQL_CACHE `sym_pages`.* FROM `sym_pages`, `sym_pages_types` WHERE `sym_pages_types`.page_id = `sym_pages`.id AND sym_pages_types.`type` = 'index' LIMIT 1;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` = 'document' AND `handle` = 'astana' LIMIT 1;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'document' LIMIT 1;
    • [0.0002] SELECT SQL_CACHE type FROM `sym_pages_types` AS pt WHERE pt.page_id = 159 GROUP BY pt.type ORDER BY pt.type ASC;
    • [0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (7);