JDatabaseMySQL::query: 1038 - Out of sort memory; increase server sort buffer size SQL=SELECT DISTINCT b.* FROM hmodj_hikashop_category AS a LEFT JOIN hmodj_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (2) AND b.category_id!=1 ORDER BY b.category_left Call stack # Function Location 1 JAdministrator->dispatch() /homez.383/reggaemuq/www/administrator/index.php:47 2 JComponentHelper::renderComponent() /homez.383/reggaemuq/www/administrator/includes/application.php:153 3 require_once() /homez.383/reggaemuq/www/libraries/joomla/application/component/helper.php:156 4 hikashopController->execute() /homez.383/reggaemuq/www/administrator/components/com_hikashop/admin.hikashop.php:43 5 JController->execute() /homez.383/reggaemuq/www/administrator/components/com_hikashop/helpers/helper.php:1005 6 hikashopController->listing() /homez.383/reggaemuq/www/libraries/joomla/application/component/controller.php:684 7 hikashopController->display() /homez.383/reggaemuq/www/administrator/components/com_hikashop/helpers/helper.php:832 8 JController->display() /homez.383/reggaemuq/www/administrator/components/com_hikashop/helpers/helper.php:1050 9 ProductViewProduct->display() /homez.383/reggaemuq/www/libraries/joomla/application/component/controller.php:650 10 ProductViewProduct->listing() /homez.383/reggaemuq/www/administrator/components/com_hikashop/views/product/view.html.php:23 11 hikashopCategoryClass->getParents() /homez.383/reggaemuq/www/administrator/components/com_hikashop/views/product/view.html.php:90 12 JDatabase->loadObjectList() /homez.383/reggaemuq/www/administrator/components/com_hikashop/classes/category.php:491 13 JDatabaseMySQLi->query() /homez.383/reggaemuq/www/libraries/joomla/database/database.php:975 14 JError::raiseError() /homez.383/reggaemuq/www/libraries/joomla/database/database/mysqli.php:535 15 JError::raise() /homez.383/reggaemuq/www/libraries/joomla/error/error.php:250 Erreurs JDatabaseMySQL::query: 1038 - Out of sort memory; increase server sort buffer size SQL=SELECT DISTINCT b.* FROM hmodj_hikashop_category AS a LEFT JOIN hmodj_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (2) AND b.category_id!=1 ORDER BY b.category_left Information Suivi Call stack # Function Location 1 JAdministrator->dispatch() /homez.383/reggaemuq/www/administrator/index.php:47 2 JComponentHelper::renderComponent() /homez.383/reggaemuq/www/administrator/includes/application.php:153 3 require_once() /homez.383/reggaemuq/www/libraries/joomla/application/component/helper.php:156 4 hikashopController->execute() /homez.383/reggaemuq/www/administrator/components/com_hikashop/admin.hikashop.php:43 5 JController->execute() /homez.383/reggaemuq/www/administrator/components/com_hikashop/helpers/helper.php:1005 6 hikashopController->listing() /homez.383/reggaemuq/www/libraries/joomla/application/component/controller.php:684 7 hikashopController->display() /homez.383/reggaemuq/www/administrator/components/com_hikashop/helpers/helper.php:832 8 JController->display() /homez.383/reggaemuq/www/administrator/components/com_hikashop/helpers/helper.php:1050 9 ProductViewProduct->display() /homez.383/reggaemuq/www/libraries/joomla/application/component/controller.php:650 10 ProductViewProduct->listing() /homez.383/reggaemuq/www/administrator/components/com_hikashop/views/product/view.html.php:23 11 hikashopCategoryClass->getParents() /homez.383/reggaemuq/www/administrator/components/com_hikashop/views/product/view.html.php:90 12 JDatabase->loadObjectList() /homez.383/reggaemuq/www/administrator/components/com_hikashop/classes/category.php:491 13 JDatabaseMySQLi->query() /homez.383/reggaemuq/www/libraries/joomla/database/database.php:975 14 JError::raiseError() /homez.383/reggaemuq/www/libraries/joomla/database/database/mysqli.php:535 15 JError::raise() /homez.383/reggaemuq/www/libraries/joomla/error/error.php:250 Profil d'information Application 0.002 seconds (+0.002); 0.73 MB (+0.735) - afterLoad Application 0.123 seconds (+0.120); 4.25 MB (+3.512) - afterInitialise Application 0.123 seconds (+0.000); 4.25 MB (+0.000) - afterRoute Occupation de la mémoire 7.2 MB (7,551,016 Bytes) 13 requêtes exécutées SELECT `data` FROM `hmodj_session` WHERE `session_id` = 'q3ekml1s3ab86c2l13gr6fmrt3' DELETE FROM `hmodj_session` WHERE `time` < 1348722889 SELECT extension_id AS "id", element AS "option", params, enabled FROM hmodj_extensions WHERE `type` = 'component' AND `element` = 'com_languages' SELECT folder AS type, element AS name, params FROM hmodj_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3) ORDER BY ordering SELECT extension_id AS "id", element AS "option", params, enabled FROM hmodj_extensions WHERE `type` = 'component' AND `element` = 'com_kunena' SELECT template, s.params FROM hmodj_template_styles as s LEFT JOIN hmodj_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = 1 AND home = 1 ORDER BY home SELECT extension_id AS "id", element AS "option", params, enabled FROM hmodj_extensions WHERE `type` = 'component' AND `element` = 'com_hikashop' SELECT * FROM hmodj_hikashop_config SELECT category_id FROM hmodj_hikashop_category WHERE category_type='root' LIMIT 1 SELECT category_id FROM hmodj_hikashop_category WHERE category_parent_id=1 AND category_type='product' LIMIT 1 SELECT category_id FROM hmodj_hikashop_category WHERE category_parent_id=1 AND category_type='1' LIMIT 1 SELECT DISTINCT b.* FROM hmodj_hikashop_category AS a LEFT JOIN hmodj_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (2) AND b.category_id!=1 ORDER BY b.category_left UPDATE `hmodj_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:30;s:19:\"session.timer.start\";i:1348723394;s:18:\"session.timer.last\";i:1348723775;s:17:\"session.timer.now\";i:1348723789;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:15.0) Gecko/20100101 Firefox/15.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:5:\" order\";O:8:\"stdClass\":1:{s:14:\"filter_partner\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:8:\"Marshall\";s:5:\"email\";s:27:\"contact@reggaemusicshop.com\";s:8:\"password\";s:65:\"181e3f2a39127ac6e3758a8c6c7f4747:TMToXGIxLag3KXX62cKgZTZKbewKhrno\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-10-13 19:51:39\";s:13:\"lastvisitDate\";s:19:\"2012-09-26 13:59:19\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:17:\"Super Utilisateur\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4589643fa6a6c3496af1472a440fa8dc\";}', `time` = 1348723789 WHERE `session_id` = 'q3ekml1s3ab86c2l13gr6fmrt3' 9 types de requêtes exécutées, triées par occurrences. Tables sélectionnées : 3 × SELECT category_id FROM hmodj_hikashop_category 3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM hmodj_extensions 1 × SELECT * FROM hmodj_hikashop_confi 1 × SELECT DISTINCT b.* FROM hmodj_hikashop_category AS a LEFT JOIN hmodj_hikashop_category AS b ON a.category_left >= b.category_left 1 × SELECT template, s.params FROM hmodj_template_styles as s LEFT JOIN hmodj_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id 1 × SELECT folder AS type, element AS name, params FROM hmodj_extensions 1 × SELECT `data` FROM `hmodj_session` Autres tables : 1 × UPDATE `hmodj_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:30;s:19:\"session.timer.start\";i:1348723394;s:18:\"session.timer.last\";i:1348723775;s:17:\"session.timer.now\";i:1348723789;s:22:\"session.client.browser\";s:67:\"Mozilla/5.0 (Windows NT 6.1; rv:15.0) Gecko/20100101 Firefox/15.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:5:\"order\";O:8:\"stdClass\":1:{s:14:\"filter_partner\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:8:\"Marshall\";s:5:\"email\";s:27:\"contact@reggaemusicshop.com\";s:8:\"password\";s:65:\"181e3f2a39127ac6e3758a8c6c7f4747:TMToXGIxLag3KXX62cKgZTZKbewKhrno\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-10-13 19:51:39\";s:13:\"lastvisitDate\";s:19:\"2012-09-26 13:59:19\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:17:\"Super Utilisateur\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4589643fa6a6c3496af1472a440fa8dc\";}', `time` = 1348723789 1 × DELETE FROM `hmodj_session`