• Symphony Fatal Database Error: Unknown column 'index.aspx' in 'where clause'

    An error occurred while attempting to execute the following query

    • SELECT SQL_CACHE DISTINCT `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_35` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '10' AND `e`.id IN (index.aspx) ORDER BY `ed`.`start` DESC LIMIT 0, 1
  • Backtrace
    • [/home/esoles/public_html/symphony/lib/toolkit/class.mysql.php:459]
    •     MySQL->__error();
    • [/home/esoles/public_html/symphony/lib/toolkit/class.mysql.php:655]
    •     MySQL->query();
    • [/home/esoles/public_html/symphony/lib/toolkit/class.entrymanager.php:387]
    •     MySQL->fetch();
    • [/home/esoles/public_html/symphony/lib/toolkit/class.entrymanager.php:613]
    •     EntryManager::fetch();
    • [/home/esoles/public_html/symphony/lib/toolkit/data-sources/class.datasource.section.php:436]
    •     EntryManager::fetchByPage();
    • [/home/esoles/public_html/symphony/lib/toolkit/class.datasource.php:128]
    •     SectionDatasource->execute();
    • [/home/esoles/public_html/symphony/lib/toolkit/class.frontendpage.php:825]
    •     DataSource->grab();
    • [/home/esoles/public_html/symphony/lib/toolkit/class.frontendpage.php:411]
    •     FrontendPage->processDatasources();
    • [/home/esoles/public_html/symphony/lib/toolkit/class.frontendpage.php:183]
    •     FrontendPage->__buildPage();
    • [/home/esoles/public_html/symphony/lib/core/class.frontend.php:103]
    •     FrontendPage->generate();
    • [/home/esoles/public_html/index.php:25]
    •     Frontend->display();
  • Database Query Log
    • [0.0005] SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8';
    • [0.0005] SET CHARACTER SET 'utf8';
    • [0.0007] 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.0005] SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = '7e4af62d4f6bb3b7a474b67e94272333' LIMIT 1;
    • [0.0015] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` = 'news' AND `handle` = 'index.aspx' LIMIT 1;
    • [0.0004] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'news' LIMIT 1;
    • [0.0004] SELECT SQL_CACHE type FROM `sym_pages_types` AS pt WHERE pt.page_id = 82 GROUP BY pt.type ORDER BY pt.type ASC;
    • [0.0080] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (10);
    • [0.0109] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 10 AND `element_name` IN ('datetime') ORDER BY `sortorder` ASC;
    • [0.0007] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(35);
    • [0.0009] SELECT SQL_CACHE * FROM `sym_fields_datetime` WHERE `field_id` IN (35);
    • [0.0002] SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled';
    • [0.0012] SELECT SQL_CACHE DISTINCT `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_35` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '10' ORDER BY `ed`.`start` DESC LIMIT 0, 5;
    • [0.0007] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 10 AND `element_name` IN ('title', 'datetime', 'urllink', 'imagefile', 'croppedimage', 'type', 'shortdesc') ORDER BY `sortorder` ASC;
    • [0.0006] SELECT SQL_CACHE * FROM `sym_entries_data_34` WHERE `entry_id` IN (265,262,263,261,260) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE * FROM `sym_entries_data_35` WHERE `entry_id` IN (265,262,263,261,260) ORDER BY `id` ASC;
    • [0.0005] SELECT SQL_CACHE * FROM `sym_entries_data_36` WHERE `entry_id` IN (265,262,263,261,260) ORDER BY `id` ASC;
    • [0.0005] SELECT SQL_CACHE * FROM `sym_entries_data_37` WHERE `entry_id` IN (265,262,263,261,260) ORDER BY `id` ASC;
    • [0.0005] SELECT SQL_CACHE * FROM `sym_entries_data_38` WHERE `entry_id` IN (265,262,263,261,260) ORDER BY `id` ASC;
    • [0.0005] SELECT SQL_CACHE * FROM `sym_entries_data_39` WHERE `entry_id` IN (265,262,263,261,260) ORDER BY `id` ASC;
    • [0.0005] SELECT SQL_CACHE * FROM `sym_entries_data_75` WHERE `entry_id` IN (265,262,263,261,260) ORDER BY `id` ASC;
    • [0.0003] SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` WHERE `e`.`section_id` = '10';
    • [0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(34,37,38,39,75);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (34);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_image_upload` WHERE `field_id` IN (37);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_imagecropper` WHERE `field_id` IN (38);
    • [0.0005] SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` IN (39);
    • [0.0004] SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` IN (75);
    • [0.0105] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (15);
    • [0.0038] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(188);
    • [0.0060] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (188);
    • [0.0037] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 15 AND `element_name` IN ('sortorder') ORDER BY `sortorder` ASC;
    • [0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(74);
    • [0.0043] SELECT SQL_CACHE * FROM `sym_fields_order_entries` WHERE `field_id` IN (74);
    • [0.0013] 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 JOIN `sym_entries_data_188` AS t188_1 ON (e.id = t188_1.entry_id) LEFT OUTER JOIN `sym_entries_data_74` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '15' AND ( t188_1.value IN ('no') OR t188_1.value IS NULL ) ORDER BY `ed`.`value` ASC;
    • [0.0012] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 15 AND `element_name` IN ('name', 'page-url', 'imagefile', 'croppedimage', 'urllink', 'sortorder') ORDER BY `sortorder` ASC;
    • [0.0007] SELECT SQL_CACHE * FROM `sym_entries_data_70` WHERE `entry_id` IN (24,26,170,196) ORDER BY `id` ASC;
    • [0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_191` WHERE `entry_id` IN (24,26,170,196) ORDER BY `id` ASC;
    • [0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_71` WHERE `entry_id` IN (24,26,170,196) ORDER BY `id` ASC;
    • [0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_72` WHERE `entry_id` IN (24,26,170,196) ORDER BY `id` ASC;
    • [0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_73` WHERE `entry_id` IN (24,26,170,196) ORDER BY `id` ASC;
    • [0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_74` WHERE `entry_id` IN (24,26,170,196) ORDER BY `id` ASC;
    • [0.0001] SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_188` AS t188_1 ON (e.id = t188_1.entry_id) WHERE `e`.`section_id` = '15' AND ( t188_1.value IN ('no') OR t188_1.value IS NULL );
    • [0.0006] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(70,191,71,72,73);
    • [0.0002] SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` IN (70,73,191);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_image_upload` WHERE `field_id` IN (71);
    • [0.0001] SELECT SQL_CACHE * FROM `sym_fields_imagecropper` WHERE `field_id` IN (72);
    • [0.0008] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 10 AND `element_name` IN ('datetime') ORDER BY `sortorder` ASC;