Exception 10101: Unexisting item in /home/vlaamspa/domains/vlaamspatientenplatform.be/public_html/_lib/sys/core/c_item.php (line 60)

									INNER JOIN item_cat ON item_type.item_cat_id = item_cat.item_cat_id
							WHERE item.item_id = {$item_id}";
 
      $res = MC::get()->DB->db_query($sql);
      if (!$item_cat = MC::get()->DB->db_fetch($res))
        throw new Exception('Unexisting item', 10101); // error handling (unexisting item)
      MC::get()->CACHE->set('item_cat_for_item_id//' . $item_id, $item_cat);
    }
 
 
    // require relevant file and instantiate relevant item subclass

Trace:

1. item_factory::factory in /home/vlaamspa/domains/vlaamspatientenplatform.be/public_html/index.php (line 44) - code - args
   array(1) { [0]=> int(8689) }

    
    
    
   $smarty->assign('themes', item_list::get(ITEM_TYPE_THEME)->add_filter('show_in_subnav', 1)->order_by("title ASC")->execute());
   $smarty->assign('positions', item_list::get(ITEM_TYPE_POSITION)->order_by("title ASC")->execute());
   $all_events = item_factory::factory(8689);
   $smarty->assign('all_events', $all_events);
   $smarty->assign('event_categories', item_list::get(ITEM_TYPE_EVENT_CATEGORY)->order_by("name ASC")->execute());
   $smarty->assign('all_news', current(item_list::get(ITEM_TYPE_LIST_PAGE)->add_filter('list_item_type_id', ITEM_TYPE_BLOG)->execute()->get_list()));
   $smarty->assign('all_publications', current(item_list::get(ITEM_TYPE_LIST_PAGE)->add_filter('list_item_type_id', ITEM_TYPE_PUBLICATION)->execute()->get_list()));
   $smarty->assign('newsletters', current(item_list::get(ITEM_TYPE_LIST_PAGE)->add_filter('list_item_type_id', ITEM_TYPE_NEWSLETTER)->execute()->get_list()));

Queries: (35)

toon

1. SELECT * FROM `plugin` WHERE enabled=1  
2. SELECT * FROM `item_cat`  
3. SELECT *
                   FROM item_type
                   ORDER BY item_type.item_cat_id
4. SELECT * FROM item_relation_cat
5. SELECT * FROM `role`  
6. SHOW COLUMNS FROM `item`
7. SELECT * FROM `role`  
8. SELECT *
                   FROM item_type
                   ORDER BY item_type.item_cat_id
9. SHOW COLUMNS FROM `acl`
10. SELECT * FROM `acl` WHERE item_type_id = 0 AND rule='allow'  
11. SELECT * FROM `acl` WHERE item_type_id <> 0  
12. SELECT * FROM `language`  
13. SELECT * FROM text
14. SELECT *
                  FROM item_type
                  WHERE item_type.item_type_id = ITEM_TYPE_NAVIGATION
15. SELECT item_cat.item_cat_id, item_cat.item_cat
                  FROM item_type
                    INNER JOIN item_cat ON item_type.item_cat_id = item_cat.item_cat_id
                  WHERE item_type_id = ITEM_TYPE_NAVIGATION
16. SELECT * FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_NAVIGATION
17. SELECT DISTINCT item.item_id, item.time_entered, version.time_touched, item.is_locked, item.is_approved, item.is_featured, item.STATUS, item.user_id, item.edit_user_id, version.version_id, version.time_version, version.edit_user_id, version.seq_order, version_language.language_id, version_language.url, item_type.*, item_cat.*,  FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_NAVIGATION
18. SELECT *
                  FROM item_type
                  WHERE item_type.item_type_id = ITEM_TYPE_NAVIGATION
19. SELECT item_cat.item_cat_id, item_cat.item_cat
                  FROM item_type
                    INNER JOIN item_cat ON item_type.item_cat_id = item_cat.item_cat_id
                  WHERE item_type_id = ITEM_TYPE_NAVIGATION
20. SELECT * FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_NAVIGATION
21. SELECT DISTINCT item.item_id, item.time_entered, version.time_touched, item.is_locked, item.is_approved, item.is_featured, item.STATUS, item.user_id, item.edit_user_id, version.version_id, version.time_version, version.edit_user_id, version.seq_order, version_language.language_id, version_language.url, item_type.*, item_cat.*,  FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_NAVIGATION
22. SELECT *
                  FROM item_type
                  WHERE item_type.item_type_id = ITEM_TYPE_NAVIGATION
23. SELECT item_cat.item_cat_id, item_cat.item_cat
                  FROM item_type
                    INNER JOIN item_cat ON item_type.item_cat_id = item_cat.item_cat_id
                  WHERE item_type_id = ITEM_TYPE_NAVIGATION
24. SELECT * FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_NAVIGATION
25. SELECT DISTINCT item.item_id, item.time_entered, version.time_touched, item.is_locked, item.is_approved, item.is_featured, item.STATUS, item.user_id, item.edit_user_id, version.version_id, version.time_version, version.edit_user_id, version.seq_order, version_language.language_id, version_language.url, item_type.*, item_cat.*,  FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_NAVIGATION
26. SELECT *
                  FROM item_type
                  WHERE item_type.item_type_id = ITEM_TYPE_THEME
27. SELECT item_cat.item_cat_id, item_cat.item_cat
                  FROM item_type
                    INNER JOIN item_cat ON item_type.item_cat_id = item_cat.item_cat_id
                  WHERE item_type_id = ITEM_TYPE_THEME
28. SELECT * FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_THEME
29. SELECT DISTINCT item.item_id, item.time_entered, version.time_touched, item.is_locked, item.is_approved, item.is_featured, item.STATUS, item.user_id, item.edit_user_id, version.version_id, version.time_version, version.edit_user_id, version.seq_order, version_language.language_id, version_language.url, item_type.*, item_cat.*,  FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_THEME ORDER BY `` ASC
30. SELECT *
                  FROM item_type
                  WHERE item_type.item_type_id = ITEM_TYPE_POSITION
31. SELECT item_cat.item_cat_id, item_cat.item_cat
                  FROM item_type
                    INNER JOIN item_cat ON item_type.item_cat_id = item_cat.item_cat_id
                  WHERE item_type_id = ITEM_TYPE_POSITION
32. SELECT * FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_POSITION
33. SELECT DISTINCT item.item_id, item.time_entered, version.time_touched, item.is_locked, item.is_approved, item.is_featured, item.STATUS, item.user_id, item.edit_user_id, version.version_id, version.time_version, version.edit_user_id, version.seq_order, version_language.language_id, version_language.url, item_type.*, item_cat.*,  FROM item LEFT JOIN `version` ON `item`.`version_id` = `version`.`version_id` LEFT JOIN `version_language` ON `version`.`version_id` = `version_language`.`version_id` LEFT JOIN `item_type` ON `item`.`item_type_id` = `item_type`.`item_type_id` LEFT JOIN `item_cat` ON `item_type`.`item_cat_id` = `item_cat`.`item_cat_id` LEFT JOIN `` ON `item`.`version_id` = ``.`version_id` WHERE .language_id = LANGUAGE_DUTCH AND item.item_type_id = ITEM_TYPE_POSITION ORDER BY `` ASC
34. SELECT version_id FROM `item` WHERE item_id = 8689  
35. SELECT item_cat.item_cat
                  FROM item
                    INNER JOIN item_type ON item.item_type_id = item_type.item_type_id
                      INNER JOIN item_cat ON item_type.item_cat_id = item_cat.item_cat_id
                  WHERE item.item_id = 8689

Geheugengebruik:

0.6MB

Tijd:

0.292201042175s

Route:

array(1) { [0]=> string(8) "homepage" } array(31) { [""]=> string(8) "homepage" ["tellafriend"]=> string(11) "tellafriend" ["inloggen"]=> string(9) "user/form" ["lijst/:list_page"]=> string(27) "item/view/list_page:item_id" ["themas/:theme"]=> string(23) "item/view/theme:item_id" ["blogs/:blog"]=> string(22) "item/view/blog:item_id" ["blogs/categorie/:blog_category"]=> string(31) "item/view/blog_category:item_id" ["standpunten/:position"]=> string(26) "item/view/position:item_id" ["sectie/:navigation"]=> string(28) "item/view/navigation:item_id" ["activiteiten/inschrijven/:event"]=> string(26) "item/add/135/event:item_id" ["activiteiten/:event"]=> string(23) "item/view/event:item_id" ["activiteiten/categorie/:event_category"]=> string(32) "item/view/event_category:item_id" ["activiteiten/toevoegen"]=> string(12) "item/add/117" ["activiteiten/insert"]=> string(15) "item/insert/117" ["publicaties/:publication"]=> string(29) "item/view/publication:item_id" ["publicaties/categorie/:publication_category"]=> string(38) "item/view/publication_category:item_id" ["nieuwsbrieven/:newsletter"]=> string(28) "item/view/newsletter:item_id" ["nieuwsbrieven/item/:newsletter_item"]=> string(33) "item/view/newsletter_item:item_id" ["persberichten/:press_release"]=> string(31) "item/view/press_release:item_id" ["nieuws/:news"]=> string(22) "item/view/news:item_id" ["pagina/:page"]=> string(22) "item/view/page:item_id" ["vacature/toevoegen"]=> string(12) "item/add/136" ["vacature/insert"]=> string(15) "item/insert/136" ["vacature/:vacature"]=> string(26) "item/view/vacature:item_id" ["contact"]=> string(7) "contact" ["zoeken"]=> string(11) "item/search" ["mailinglist/inschrijven"]=> string(32) "item/insert/ITEM_TYPE_SUBSCRIBER" ["preview/*/*"]=> string(13) "item/view/*/*" ["afmelden"]=> string(11) "user/logout" ["aanmelden"]=> string(10) "user/login" ["rss"]=> string(20) "item/list/132////rss" }