• Symphony Fatal Database Error: Unknown column 'chemicals' 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` = '4' AND `e`.id IN (chemicals) ORDER BY ( SELECT `ed`.value FROM sym_entries_data_13 AS `ed` WHERE entry_id = e.id ) ASC
  • Backtrace
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.mysql.php:459]
    •     MySQL->__error();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.mysql.php:655]
    •     MySQL->query();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.entrymanager.php:387]
    •     MySQL->fetch();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.entrymanager.php:594]
    •     EntryManager::fetch();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/data-sources/class.datasource.section.php:436]
    •     EntryManager::fetchByPage();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.datasource.php:128]
    •     SectionDatasource->execute();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.frontendpage.php:825]
    •     DataSource->grab();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.frontendpage.php:411]
    •     FrontendPage->processDatasources();
    • [/home/arpolpet/public_html/symphony/lib/toolkit/class.frontendpage.php:183]
    •     FrontendPage->__buildPage();
    • [/home/arpolpet/public_html/symphony/lib/core/class.frontend.php:103]
    •     FrontendPage->generate();
    • [/home/arpolpet/public_html/index.php:25]
    •     Frontend->display();
  • Database Query Log
    • [0.0003] SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8';
    • [0.0001] SET CHARACTER SET 'utf8';
    • [0.0015] 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.0004] SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = '58k14hei45fdqsup1flmlvi477' LIMIT 1;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` = 'solutions' AND `handle` = 'chemicals' LIMIT 1;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'solutions' LIMIT 1;
    • [0.0004] SELECT SQL_CACHE type FROM `sym_pages_types` AS pt WHERE pt.page_id = 3 GROUP BY pt.type ORDER BY pt.type ASC;
    • [0.0004] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (3);
    • [0.0004] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 3 AND `element_name` IN ('order') ORDER BY `sortorder` ASC;
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(23);
    • [0.0003] SELECT SQL_CACHE * FROM `sym_fields_order_entries` WHERE `field_id` IN (23);
    • [0.0002] SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled';
    • [0.0008] 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` LEFT OUTER JOIN `sym_entries_data_23` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '3' ORDER BY `ed`.`value` ASC LIMIT 0, 100;
    • [0.0005] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 3 AND `element_name` IN ('title', 'link', 'description', 'logo', 'cover', 'order') ORDER BY `sortorder` ASC;
    • [0.0005] SELECT SQL_CACHE * FROM `sym_entries_data_9` WHERE `entry_id` IN (7,10,9,8) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_10` WHERE `entry_id` IN (7,10,9,8) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_11` WHERE `entry_id` IN (7,10,9,8) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_21` WHERE `entry_id` IN (7,10,9,8) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_29` WHERE `entry_id` IN (7,10,9,8) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_23` WHERE `entry_id` IN (7,10,9,8) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(9,10,11,21,29);
    • [0.0004] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (9,10);
    • [0.0004] SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` IN (11);
    • [0.0004] SELECT SQL_CACHE * FROM `sym_fields_upload` WHERE `field_id` IN (21,29);
    • [0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (1);
    • [0.0003] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 1 AND `element_name` IN ('order') ORDER BY `sortorder` ASC;
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(4);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_order_entries` WHERE `field_id` IN (4);
    • [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` LEFT OUTER JOIN `sym_entries_data_4` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '1' ORDER BY `ed`.`value` ASC LIMIT 0, 100;
    • [0.0004] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 1 AND `element_name` IN ('title', 'description', 'longdescription', 'thumbnail', 'cover') ORDER BY `sortorder` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_1` WHERE `entry_id` IN (1,2,3,4,2915) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_2` WHERE `entry_id` IN (1,2,3,4,2915) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_37` WHERE `entry_id` IN (1,2,3,4,2915) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_3` WHERE `entry_id` IN (1,2,3,4,2915) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_24` WHERE `entry_id` IN (1,2,3,4,2915) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(1,2,3,24);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (1);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` IN (2);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_upload` WHERE `field_id` IN (3,24);
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(37);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` IN (37);
    • [0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (2);
    • [0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 2 AND `element_name` IN ('date') ORDER BY `sortorder` ASC;
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(8);
    • [0.0003] SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` IN (8);
    • [0.0006] 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` = '2' ORDER BY ( SELECT `ed`.value FROM sym_entries_data_8 AS `ed` WHERE entry_id = e.id ) DESC LIMIT 0, 20;
    • [0.0004] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 2 AND `element_name` IN ('title', 'summary', 'date', 'body', 'images') ORDER BY `sortorder` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_5` WHERE `entry_id` IN (745,733,735,736) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_6` WHERE `entry_id` IN (745,733,735,736) ORDER BY `id` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_7` WHERE `entry_id` IN (745,733,735,736) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_8` WHERE `entry_id` IN (745,733,735,736) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_32` WHERE `entry_id` IN (745,733,735,736) ORDER BY `id` ASC;
    • [0.0002] SELECT SQL_CACHE `section_id` FROM `sym_entries` WHERE `id` = '743' LIMIT 1;
    • [0.0001] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (7);
    • [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 ('743', '744', '740', '741', '742') AND `e`.`section_id` = '7' ORDER BY ( SELECT `ed`.value FROM sym_entries_data_8 AS `ed` WHERE entry_id = e.id ) DESC;
    • [0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 7 ORDER BY `sortorder` ASC;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_entries_data_30` WHERE `entry_id` IN (742,741,740,743,744) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_31` WHERE `entry_id` IN (742,741,740,743,744) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_33` WHERE `entry_id` IN (742,741,740,743,744) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(5,6,7,32);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (5);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` IN (6,7);
    • [0.0003] SELECT SQL_CACHE * FROM `sym_fields_subsectionmanager` WHERE `field_id` IN (32);
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(30);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_upload` WHERE `field_id` IN (30);
    • [0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(31);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (31);
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(33);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (33);
    • [0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (4);
    • [0.0003] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 4 AND `element_name` IN ('nato') ORDER BY `sortorder` ASC;
    • [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_input` WHERE `field_id` IN (13);