Skip to content

Instantly share code, notes, and snippets.

@jdsimcoe
Created November 9, 2012 17:48
Show Gist options
  • Select an option

  • Save jdsimcoe/4047110 to your computer and use it in GitHub Desktop.

Select an option

Save jdsimcoe/4047110 to your computer and use it in GitHub Desktop.
Global Resource Loader (2.3) Error
Symphony Fatal Error: The page you requested does not exist.
An error occurred in /Users/jdsimcoe/Sites/dtrmn/symphony/lib/toolkit/class.datasource.php around line 243
238 }
239
240 $this->_param_output_only = ((!is_array($this->dsParamINCLUDEDELEMENTS) || empty($this->dsParamINCLUDEDELEMENTS)) && !isset($this->dsParamGROUP));
241
242 if($this->dsParamREDIRECTONEMPTY == 'yes' && $this->_force_empty_result){
243 throw new FrontendPageNotFoundException;
244 }
245
246 }
247
Backtrace
[/Users/jdsimcoe/Sites/dtrmn/symphony/lib/toolkit/class.frontendpage.php:774]
DataSource->processParameters();
[/Users/jdsimcoe/Sites/dtrmn/symphony/lib/toolkit/class.frontendpage.php:401]
FrontendPage->processDatasources();
[/Users/jdsimcoe/Sites/dtrmn/symphony/lib/toolkit/class.frontendpage.php:183]
FrontendPage->__buildPage();
[/Users/jdsimcoe/Sites/dtrmn/symphony/lib/core/class.frontend.php:103]
FrontendPage->generate();
[/Users/jdsimcoe/Sites/dtrmn/symphony/lib/core/class.frontend.php:161]
Frontend->display();
[:0]
FrontendPageNotFoundExceptionHandler::render();
[/Users/jdsimcoe/Sites/dtrmn/symphony/lib/core/class.errorhandler.php:100]
call_user_func();
[:0]
GenericExceptionHandler::handler();
Database Query Log
[0.0001] SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8';
[0.0001] SET CHARACTER SET 'utf8';
[0.0004] 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.0001] SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = '16e24b51f58431dd0492e2dc5964e85c' LIMIT 1;
[0.0001] SELECT SQL_CACHE `id` FROM `sym_authors` WHERE `username` = 'jdsimcoe' AND `password` = '7b10dfd8ecfb74eafd8778364f883ce41cb756f5' LIMIT 1;
[0.0001] UPDATE sym_authors SET `last_seen` = '2012-11-09 09:43:00' WHERE `id` = '1';
[0.0002] SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1);
[0.0003] SELECT SQL_CACHE `p`.* FROM `sym_pages` AS `p` LEFT JOIN `sym_pages_types` AS `pt` ON (p.id = pt.page_id) WHERE `pt`.type = 'index';
[0.0002] SELECT SQL_CACHE type FROM `sym_pages_types` AS pt WHERE pt.page_id = 64 GROUP BY pt.type ORDER BY pt.type ASC;
[0.0003] SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled';
[0.0004] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (1);
[0.0002] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(5);
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` IN (5);
[0.0003] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 1 AND `element_name` IN ('date') ORDER BY `sortorder` ASC;
[0.0003] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(23);
[0.0002] SELECT SQL_CACHE * FROM `sym_fields_datetime` WHERE `field_id` IN (23);
[0.0005] SELECT SQL_CACHE DISTINCT `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_5` AS t5_1 ON (e.id = t5_1.entry_id) LEFT OUTER JOIN `sym_entries_data_23` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '1' AND (t5_1.value IN ('yes')) ORDER BY `ed`.`start` DESC LIMIT 0, 5;
[0.0003] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 1 AND `element_name` IN ('title', 'date', 'body') ORDER BY `sortorder` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_1` WHERE `entry_id` IN (8,3,4) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_2` WHERE `entry_id` IN (8,3,4) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_23` WHERE `entry_id` IN (8,3,4) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_sections_association` AS `sa`, `sym_sections` AS `s` WHERE `sa`.`parent_section_id` = 1 AND `s`.`id` = `sa`.`child_section_id` ORDER BY `s`.`sortorder` ASC;
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(1,2);
[0.0001] 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 t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(17);
[0.0003] SELECT SQL_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` IN (17);
[0.0002] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 8;
[0.0002] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 3;
[0.0002] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 4;
[0.0001] SELECT SQL_CACHE `id` FROM `sym_authors` WHERE `username` IN ('jdsimcoe');
[0.0004] 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;
[0.0001] SELECT SQL_CACHE `page_id`,`type` FROM `sym_pages_types`;
[0.0002] SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` IN (3);
[0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 3 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(24);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_datetime` WHERE `field_id` IN (24);
[0.0002] SELECT SQL_CACHE DISTINCT `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT OUTER JOIN `sym_entries_data_24` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '3' ORDER BY `ed`.`start` DESC LIMIT 0, 5;
[0.0002] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 3 AND `element_name` IN ('date', 'note') ORDER BY `sortorder` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_24` WHERE `entry_id` IN (9,7,5,6) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_9` WHERE `entry_id` IN (9,7,5,6) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE t1.* FROM sym_fields AS `t1` WHERE 1 AND t1.`id` IN(9);
[0.0001] SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` IN (9);
[0.0003] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_5` AS t5_2 ON (e.id = t5_2.entry_id) WHERE 1 AND `e`.`section_id` = '1' AND (t5_2.value IN ('yes')) ORDER BY `e`.`id`DESC;
[0.0003] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 1 AND `element_name` IN ('title', 'date') ORDER BY `sortorder` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_1` WHERE `entry_id` IN (8,4,3) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_23` WHERE `entry_id` IN (8,4,3) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_5` AS t5_2 ON (e.id = t5_2.entry_id) WHERE `e`.`section_id` = '1' AND (t5_2.value IN ('yes'));
[0.0001] SELECT SQL_CACHE * FROM `sym_sections_association` AS `sa`, `sym_sections` AS `s` WHERE `sa`.`parent_section_id` = 1 AND `s`.`id` = `sa`.`child_section_id` ORDER BY `s`.`sortorder` ASC;
[0.0001] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 8;
[0.0001] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 4;
[0.0001] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 3;
[0.0003] SELECT SQL_CACHE `p`.* FROM `sym_pages` AS `p` LEFT JOIN `sym_pages_types` AS `pt` ON (p.id = pt.page_id) WHERE `pt`.type = '404';
[0.0002] SELECT SQL_CACHE p.handle, p.parent FROM `sym_pages` AS p WHERE p.id = 76 OR p.handle = '76' LIMIT 1;
[0.0002] SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'page-not-found' LIMIT 1;
[0.0002] SELECT SQL_CACHE type FROM `sym_pages_types` AS pt WHERE pt.page_id = 76 GROUP BY pt.type ORDER BY pt.type ASC;
[0.0004] SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_5` AS t5_3 ON (e.id = t5_3.entry_id) WHERE 1 AND `e`.`section_id` = '1' AND (t5_3.value IN ('yes')) ORDER BY `e`.`id`DESC;
[0.0003] SELECT SQL_CACHE `id` FROM `sym_fields` WHERE 1 AND `parent_section` = 1 AND `element_name` IN ('title', 'date') ORDER BY `sortorder` ASC;
[0.0002] SELECT SQL_CACHE * FROM `sym_entries_data_1` WHERE `entry_id` IN (8,4,3) ORDER BY `id` ASC;
[0.0001] SELECT SQL_CACHE * FROM `sym_entries_data_23` WHERE `entry_id` IN (8,4,3) ORDER BY `id` ASC;
[0.0002] SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_5` AS t5_3 ON (e.id = t5_3.entry_id) WHERE `e`.`section_id` = '1' AND (t5_3.value IN ('yes'));
[0.0002] SELECT SQL_CACHE * FROM `sym_sections_association` AS `sa`, `sym_sections` AS `s` WHERE `sa`.`parent_section_id` = 1 AND `s`.`id` = `sa`.`child_section_id` ORDER BY `s`.`sortorder` ASC;
[0.0001] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 8;
[0.0002] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 4;
[0.0001] SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_17` WHERE `relation_id` = 3;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment