installation impossible

Plus d'informations
21 Sep 2012 14:54 - 21 Sep 2012 14:56 #7 par focus65
Réponse de focus65 sur le sujet installation impossible
hello,

Je viens de refaire une tentative et j'ai activé le débogage Joomla, ça me génère un gros dossier avec plein d'infos que je colle, ci-dessous.
Code:
500 - Une erreur s'est produite JDatabaseMySQLi::query: 1062 - Duplicate entry 'com_kunena' for key 2 SQL=INSERT INTO `grc2012_assets` (`name`,`title`,`rules`,`parent_id`,`level`,`lft`,`rgt`) VALUES ('com_kunena','com_kunena','{}','1','1','3543','3544') Retour au panneau de contrôle Call stack # Function Location 1 JAdministrator->dispatch() /home/www/065a414098f266c66554ab4eec0cb754/web/administrator/index.php:46 2 JComponentHelper::renderComponent() /home/www/065a414098f266c66554ab4eec0cb754/web/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/application/component/helper.php:351 4 require_once() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/application/component/helper.php:383 5 JController->execute() /home/www/065a414098f266c66554ab4eec0cb754/web/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() /home/www/065a414098f266c66554ab4eec0cb754/web/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() /home/www/065a414098f266c66554ab4eec0cb754/web/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/installer/installer.php:472 10 JTableNested->store() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/installer/adapters/component.php:585 11 JTable->store() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/database/tablenested.php:851 12 JDatabase->insertObject() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/database/table.php:608 13 JDatabaseMySQLi->execute() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/database/database.php:841 14 JError::raiseError() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/database/database/mysqli.php:396 15 JError::raise() /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/error/error.php:251 Console de débogage Joomla! Erreurs JTableMenu: :_getNode échoué - Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JInstallerComponent->_removeAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:1410 12 JTableNested->delete() JROOT/libraries/joomla/installer/adapters/component.php:1651 13 JTableNested->_getNode() JROOT/libraries/joomla/database/tablenested.php:588 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1446 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1591 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1591 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1591 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1591 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1591 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1591 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 La ligne de la base de données est vide. Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JInstallerComponent->_buildAdminMenus() JROOT/libraries/joomla/installer/adapters/component.php:564 11 JTableMenu->store() JROOT/libraries/joomla/installer/adapters/component.php:1591 12 JTable->load() JROOT/libraries/joomla/database/table/menu.php:148 JDatabaseMySQLi::query: 1062 - Duplicate entry 'com_kunena' for key 2 SQL=INSERT INTO `grc2012_assets` (`name`,`title`,`rules`,`parent_id`,`level`,`lft`,`rgt`) VALUES ('com_kunena','com_kunena','{}','1','1','3543','3544') Call stack # Function Location 1 JAdministrator->dispatch() JROOT/administrator/index.php:46 2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351 4 require_once() JROOT/libraries/joomla/application/component/helper.php:383 5 JController->execute() JROOT/administrator/components/com_installer/installer.php:18 6 InstallerControllerInstall->install() JROOT/libraries/joomla/application/component/controller.php:761 7 InstallerModelInstall->install() JROOT/administrator/components/com_installer/controllers/install.php:29 8 JInstaller->install() JROOT/administrator/components/com_installer/models/install.php:105 9 JInstallerComponent->install() JROOT/libraries/joomla/installer/installer.php:472 10 JTableNested->store() JROOT/libraries/joomla/installer/adapters/component.php:585 11 JTable->store() JROOT/libraries/joomla/database/tablenested.php:851 12 JDatabase->insertObject() JROOT/libraries/joomla/database/table.php:608 13 JDatabaseMySQLi->execute() JROOT/libraries/joomla/database/database.php:841 14 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396 15 JError::raise() JROOT/libraries/joomla/error/error.php:251 [color=#ff0000]JDatabaseMySQLi::query: 1100 - Table 'grc2012_session' was not locked with LOCK TABLES SQL=UPDATE `grc2012_session`[/color] SET `data` = '__default|a:8:{s:15:\"session.counter\";i:57;s:19:\"session.timer.start\";i:1348228493;s:18:\"session.timer.last\";i:1348229390;s:17:\"session.timer.now\";i:1348229410;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":4:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;s:6:\"manage\";O:8:\"stdClass\":4:{s:4:\"data\";a:1:{s:7:\"filters\";a:5:{s:6:\"search\";s:0:\"\";s:9:\"client_id\";s:0:\"\";s:6:\"status\";s:0:\"\";s:4:\"type\";s:9:\"component\";s:5:\"group\";s:0:\"\";}}s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:4:\"name\";s:9:\"orderdirn\";s:3:\"asc\";}}s:10:\"kunena-old\";i:0;s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:12:\"Rafael Yuste\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:30:\"webmaster@gruyere-rail-club.ch\";s:8:\"password\";s:65:\"d5726deea0a06a859c66603d3edfd7d1:YKilyFON06ATbPA1dTw0BOJ0nNHWqvA2\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:17:\"Super Utilisateur\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2008-11-03 22:09:26\";s:13:\"lastvisitDate\";s:19:\"2012-09-21 11:54:53\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:124:\"{\"admin_style\":\"2\",\"admin_language\":\"fr-FR\",\"language\":\"fr-FR\",\"editor\":\"tinymce\",\"helpsite\":\"\",\"timezone\":\"Europe\\/Zurich\"}\";s:6:\"groups\";a:6:{i:2;s:1:\"2\";i:3;s:1:\"3\";i:4;s:1:\"4\";i:5;s:1:\"5\";i:7;s:1:\"7\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:1:\"2\";s:14:\"admin_language\";s:5:\"fr-FR\";s:8:\"language\";s:5:\"fr-FR\";s:6:\"editor\";s:7:\"tinymce\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:13:\"Europe/Zurich\";}}s:14:\"\0*\0_authGroups\";a:8:{i:0;i:1;i:1;i:2;i:4;i:3;i:8;i:4;i:13;i:5;i:15;i:6;i:16;i:7;i:18;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:\"bfc02960890bcaf82c5be0c9bbcce999\";}' , `time` = '1348229411' WHERE `session_id` = '8598a8091313e22be9fdbb6c1776a5ba' Call stack # Function Location 1 JSession->__destruct() 2 JSession->close() JROOT/libraries/joomla/session/session.php:133 3 JSessionStorageDatabase->write() JROOT/libraries/joomla/session/session.php:676 4 JDatabaseMySQLi->execute() JROOT/libraries/joomla/session/storage/database.php:87 5 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396 6 JError::raise() JROOT/libraries/joomla/error/error.php:251 Session __default Profil d'information Application 0.004 seconds (+0.004); 0.66 MB (+0.660) - afterLoad Application 0.121 seconds (+0.116); 4.07 MB (+3.409) - afterInitialise Application 0.141 seconds (+0.020); 4.60 MB (+0.527) - afterRoute Occupation de la mémoire 6.97 MB (7,311,352 Bytes) Requêtes de base de données 146 requêtes exécutées SELECT `data` FROM `grc2012_session` WHERE `session_id` = '8598a8091313e22be9fdbb6c1776a5ba' SELECT template, s.params FROM grc2012_template_styles as s LEFT JOIN grc2012_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 id = 2 AND e.enabled = 1 OR s.client_id = 1 AND home = 1 ORDER BY home SELECT id FROM grc2012_assets WHERE `name` = '' SELECT extension_id FROM grc2012_extensions WHERE `element` = '' SELECT id FROM grc2012_menu WHERE `type` = 'component' AND `menutype` = 'main' AND `link` LIKE 'index.php?option=' SHOW TABLES LIKE 'grc2012_kunena_version' SELECT version FROM grc2012_kunena_version ORDER BY `id` DESC LIMIT 0, 1 SHOW FULL COLUMNS FROM `grc2012_extensions` INSERT INTO `grc2012_extensions` (`name`,`type`,`element`,`folder`,`client_id`,`enabled`,`access`,`protected`,`manifest_cache`,`params`) VALUES ('com_kunena','component','com_kunena','','1','1','0','0','{\"legacy\":false,\"name\":\"com_kunena\",\"type\":\"component\",\"creationDate\":\"2012-09-02\",\"author\":\"Kunena Team\",\"copyright\":\"(C) 2008 - 2012 Kunena Team. All rights reserved.\",\"authorEmail\":\"kunena@kunena.org\",\"authorUrl\":\"http:\\/\\/www.kunena.org\",\"version\":\"2.0.2\",\"description\":\"COM_KUNENA_XML_DESCRIPTION\",\" group\":\"\"}','{}') SHOW FULL COLUMNS FROM `grc2012_updates` SELECT `update_id` FROM `grc2012_updates` WHERE element = 'com_kunena' AND type = 'component' AND client_id = '' AND folder = '' SHOW FULL COLUMNS FROM `grc2012_menu` SELECT m.id, e.extension_id FROM grc2012_menu AS m LEFT JOIN grc2012_extensions AS e ON m.component_id = e.extension_id WHERE m.parent_id = 1 AND m.client_id = 1 AND e.element = 'com_kunena' SELECT id FROM grc2012_menu WHERE `client_id` = 1 AND `component_id` = 10092 LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 401 LIMIT 0, 1 DELETE FROM grc2012_menu WHERE lft BETWEEN 328 AND 329 UPDATE grc2012_menu SET lft = lft - 2 WHERE lft > 329 UPDATE grc2012_menu SET rgt = rgt - 2 WHERE rgt > 329 UNLOCK TABLES LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 400 LIMIT 0, 1 DELETE FROM grc2012_menu WHERE lft BETWEEN 326 AND 327 UPDATE grc2012_menu SET lft = lft - 2 WHERE lft > 327 UPDATE grc2012_menu SET rgt = rgt - 2 WHERE rgt > 327 UNLOCK TABLES LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 399 LIMIT 0, 1 DELETE FROM grc2012_menu WHERE lft BETWEEN 324 AND 325 UPDATE grc2012_menu SET lft = lft - 2 WHERE lft > 325 UPDATE grc2012_menu SET rgt = rgt - 2 WHERE rgt > 325 UNLOCK TABLES LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 397 LIMIT 0, 1 DELETE FROM grc2012_menu WHERE lft BETWEEN 320 AND 321 UPDATE grc2012_menu SET lft = lft - 2 WHERE lft > 321 UPDATE grc2012_menu SET rgt = rgt - 2 WHERE rgt > 321 UNLOCK TABLES LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 398 LIMIT 0, 1 DELETE FROM grc2012_menu WHERE lft BETWEEN 320 AND 321 UPDATE grc2012_menu SET lft = lft - 2 WHERE lft > 321 UPDATE grc2012_menu SET rgt = rgt - 2 WHERE rgt > 321 UNLOCK TABLES LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 396 LIMIT 0, 1 DELETE FROM grc2012_menu WHERE lft BETWEEN 318 AND 319 UPDATE grc2012_menu SET lft = lft - 2 WHERE lft > 319 UPDATE grc2012_menu SET rgt = rgt - 2 WHERE rgt > 319 UNLOCK TABLES LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 394 LIMIT 0, 1 DELETE FROM grc2012_menu WHERE lft BETWEEN 315 AND 318 UPDATE grc2012_menu SET lft = lft - 4 WHERE lft > 318 UPDATE grc2012_menu SET rgt = rgt - 4 WHERE rgt > 318 UNLOCK TABLES LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 395 LIMIT 0, 1 UNLOCK TABLES SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena' AND `parent_id` = '1' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 1 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 315 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 315 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('1','1','315','316','com-kunena','main','COM_KUNENA','index.php?option=com_kunena','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-logo-white.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 402 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 402 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 315 , rgt = 316 , level = 1 , path = 'com-kunena' WHERE id = 402 SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena-configuration' AND `parent_id` = '402' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 402 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 316 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 316 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','316','317','com-kunena-configuration','main','COM_KUNENA_CONFIGURATION','index.php?option=com_kunena&view=config','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-config.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 403 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 403 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 316 , rgt = 317 , level = 2 , path = 'com-kunena/com-kunena-configuration' WHERE id = 403 SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena-category-manager' AND `parent_id` = '402' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 402 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 318 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 318 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','318','319','com-kunena-category-manager','main','COM_KUNENA_CATEGORY_MANAGER','index.php?option=com_kunena&view=categories','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-categories.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 404 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 404 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 318 , rgt = 319 , level = 2 , path = 'com-kunena/com-kunena-category-manager' WHERE id = 404 SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena-user-manager' AND `parent_id` = '402' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 402 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 320 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 320 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','320','321','com-kunena-user-manager','main','COM_KUNENA_USER_MANAGER','index.php?option=com_kunena&view=users','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-users.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 405 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 405 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 320 , rgt = 321 , level = 2 , path = 'com-kunena/com-kunena-user-manager' WHERE id = 405 SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena-template-manager' AND `parent_id` = '402' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 402 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 322 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 322 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','322','323','com-kunena-template-manager','main','COM_KUNENA_TEMPLATE_MANAGER','index.php?option=com_kunena&view=templates','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-templates.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 406 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 406 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 322 , rgt = 323 , level = 2 , path = 'com-kunena/com-kunena-template-manager' WHERE id = 406 SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena-emoticon-manager' AND `parent_id` = '402' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 402 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 324 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 324 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','324','325','com-kunena-emoticon-manager','main','COM_KUNENA_EMOTICON_MANAGER','index.php?option=com_kunena&view=smilies','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-smileys.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 407 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 407 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 324 , rgt = 325 , level = 2 , path = 'com-kunena/com-kunena-emoticon-manager' WHERE id = 407 SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena-rank-manager' AND `parent_id` = '402' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 402 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 326 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 326 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','326','327','com-kunena-rank-manager','main','COM_KUNENA_RANK_MANAGER','index.php?option=com_kunena&view=ranks','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-ranks.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 408 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 408 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 326 , rgt = 327 , level = 2 , path = 'com-kunena/com-kunena-rank-manager' WHERE id = 408 SELECT * FROM grc2012_menu WHERE `alias` = 'com-kunena-trash-manager' AND `parent_id` = '402' AND `client_id` = '1' AND `language` = '' LOCK TABLES `grc2012_menu` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_menu WHERE id = 402 LIMIT 0, 1 UPDATE grc2012_menu SET lft = lft + 2 WHERE lft > 328 UPDATE grc2012_menu SET rgt = rgt + 2 WHERE rgt >= 328 INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','328','329','com-kunena-trash-manager','main','COM_KUNENA_TRASH_MANAGER','index.php?option=com_kunena&view=trash','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-trash.png','0','1') UNLOCK TABLES SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 409 ORDER BY p.lft SELECT id, alias FROM grc2012_menu WHERE parent_id = 409 ORDER BY parent_id, ordering, lft UPDATE grc2012_menu SET lft = 328 , rgt = 329 , level = 2 , path = 'com-kunena/com-kunena-trash-manager' WHERE id = 409 SHOW FULL COLUMNS FROM `grc2012_assets` LOCK TABLES `grc2012_assets` WRITE SELECT id, parent_id, level, lft, rgt FROM grc2012_assets WHERE id = 1 LIMIT 0, 1 UPDATE grc2012_assets SET lft = lft + 2 WHERE lft > 3543 UPDATE grc2012_assets SET rgt = rgt + 2 WHERE rgt >= 3543 INSERT INTO `grc2012_assets` (`name`,`title`,`rules`,`parent_id`,`level`,`lft`,`rgt`) VALUES ('com_kunena','com_kunena','{}','1','1','3543','3544') UPDATE `grc2012_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:57;s:19:\"session.timer.start\";i:1348228493;s:18:\"session.timer.last\";i:1348229390;s:17:\"session.timer.now\";i:1348229410;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":4:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;s:6:\"manage\";O:8:\"stdClass\":4:{s:4:\"data\";a:1:{s:7:\"filters\";a:5:{s:6:\"search\";s:0:\"\";s:9:\"client_id\";s:0:\"\";s:6:\"status\";s:0:\"\";s:4:\"type\";s:9:\"component\";s:5:\" group\";s:0:\"\";}}s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:4:\"name\";s:9:\"orderdirn\";s:3:\"asc\";}}s:10:\"kunena-old\";i:0;s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\" limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:12:\"Rafael Yuste\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:30:\"webmaster@gruyere-rail-club.ch\";s:8:\"password\";s:65:\"d5726deea0a06a859c66603d3edfd7d1:YKilyFON06ATbPA1dTw0BOJ0nNHWqvA2\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:17:\"Super Utilisateur\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2008-11-03 22:09:26\";s:13:\"lastvisitDate\";s:19:\"2012-09-21 11:54:53\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:124:\"{\"admin_style\":\"2\",\"admin_language\":\"fr-FR\",\"language\":\"fr-FR\",\"editor\":\"tinymce\",\"helpsite\":\"\",\"timezone\":\"Europe\\/Zurich\"}\";s:6:\"groups\";a:6:{i:2;s:1:\"2\";i:3;s:1:\"3\";i:4;s:1:\"4\";i:5;s:1:\"5\";i:7;s:1:\"7\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:1:\"2\";s:14:\"admin_language\";s:5:\"fr-FR\";s:8:\"language\";s:5:\"fr-FR\";s:6:\"editor\";s:7:\"tinymce\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:13:\"Europe/Zurich\";}}s:14:\"\0*\0_authGroups\";a:8:{i:0;i:1;i:1;i:2;i:4;i:3;i:8;i:4;i:13;i:5;i:15;i:6;i:16;i:7;i:18;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:\"bfc02960890bcaf82c5be0c9bbcce999\";}' , `time` = '1348229411' WHERE `session_id` = '8598a8091313e22be9fdbb6c1776a5ba' 49 types de requêtes exécutées, triées par occurrences. Tables sélectionnées : 16 × SELECT id, parent_id, level, lft, rgt FROM grc2012_menu 8 × SELECT * FROM grc2012_menu 8 × SELECT p.* FROM grc2012_menu AS n, grc2012_menu AS p 8 × SELECT id, alias FROM grc2012_menu 2 × SELECT id FROM grc2012_menu 1 × SELECT id, parent_id, level, lft, rgt FROM grc2012_assets 1 × SELECT m.id, e.extension_id FROM grc2012_menu AS m LEFT JOIN grc2012_extensions AS e ON m.component_id = e.extension_id 1 × SELECT `update_id` FROM `grc2012_updates` 1 × SELECT template, s.params FROM grc2012_template_styles as s LEFT JOIN grc2012_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id 1 × SELECT id FROM grc2012_assets 1 × SELECT extension_id FROM grc2012_extensions 1 × SELECT version FROM grc2012_kunena_version 1 × SELECT `data` FROM `grc2012_session` Autres tables : 16 × LOCK TABLES `grc2012_menu` WRIT 16 × UNLOCK TABLE 8 × UPDATE grc2012_menu SET rgt = rgt + 2 8 × UPDATE grc2012_menu SET lft = lft + 2 7 × DELETE FROM grc2012_menu 6 × UPDATE grc2012_menu SET rgt = rgt - 2 6 × UPDATE grc2012_menu SET lft = lft - 2 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','324','325','com-kunena-emoticon-manager','main','COM_KUNENA_EMOTICON_MANAGER','index.php?option=com_kunena&view=smilies','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-smileys.png','0','1' 1 × UPDATE grc2012_menu SET lft = 322 , rgt = 323 , level = 2 , path = 'com-kunena/com-kunena-template-manager' 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','328','329','com-kunena-trash-manager','main','COM_KUNENA_TRASH_MANAGER','index.php?option=com_kunena&view=trash','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-trash.png','0','1' 1 × UPDATE grc2012_menu SET lft = 324 , rgt = 325 , level = 2 , path = 'com-kunena/com-kunena-emoticon-manager' 1 × UPDATE grc2012_menu SET lft = 328 , rgt = 329 , level = 2 , path = 'com-kunena/com-kunena-trash-manager' 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','326','327','com-kunena-rank-manager','main','COM_KUNENA_RANK_MANAGER','index.php?option=com_kunena&view=ranks','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-ranks.png','0','1' 1 × UPDATE grc2012_menu SET lft = 326 , rgt = 327 , level = 2 , path = 'com-kunena/com-kunena-rank-manager' 1 × LOCK TABLES `grc2012_assets` WRIT 1 × INSERT INTO `grc2012_assets` (`name`,`title`,`rules`,`parent_id`,`level`,`lft`,`rgt`) VALUES ('com_kunena','com_kunena','{}','1','1','3543','3544' 1 × UPDATE `grc2012_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:57;s:19:\"session.timer.start\";i:1348228493;s:18:\"session.timer.last\";i:1348229390;s:17:\"session.timer.now\";i:1348229410;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":4:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;s:6:\"manage\";O:8:\"stdClass\":4:{s:4:\"data\";a:1:{s:7:\"filters\";a:5:{s:6:\"search\";s:0:\"\";s:9:\"client_id\";s:0:\"\";s:6:\"status\";s:0:\"\";s:4:\"type\";s:9:\"component\";s:5:\" group\";s:0:\"\";}}s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:4:\"name\";s:9:\"orderdirn\";s:3:\"asc\";}}s:10:\"kunena-old\";i:0;s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\" limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:12:\"Rafael Yuste\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:30:\"webmaster@gruyere-rail-club.ch\";s:8:\"password\";s:65:\"d5726deea0a06a859c66603d3edfd7d1:YKilyFON06ATbPA1dTw0BOJ0nNHWqvA2\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:17:\"Super Utilisateur\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2008-11-03 22:09:26\";s:13:\"lastvisitDate\";s:19:\"2012-09-21 11:54:53\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:124:\"{\"admin_style\":\"2\",\"admin_language\":\"fr-FR\",\"language\":\"fr-FR\",\"editor\":\"tinymce\",\"helpsite\":\"\",\"timezone\":\"Europe\\/Zurich\"}\";s:6:\"groups\";a:6:{i:2;s:1:\"2\";i:3;s:1:\"3\";i:4;s:1:\"4\";i:5;s:1:\"5\";i:7;s:1:\"7\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:1:\"2\";s:14:\"admin_language\";s:5:\"fr-FR\";s:8:\"language\";s:5:\"fr-FR\";s:6:\"editor\";s:7:\"tinymce\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:13:\"Europe/Zurich\";}}s:14:\"\0*\0_authGroups\";a:8:{i:0;i:1;i:1;i:2;i:4;i:3;i:8;i:4;i:13;i:5;i:15;i:6;i:16;i:7;i:18;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:\"bfc02960890bcaf82c5be0c9bbcce999\";}' , `time` = '1348229411' 1 × UPDATE grc2012_assets SET rgt = rgt + 2 1 × UPDATE grc2012_assets SET lft = lft + 2 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','322','323','com-kunena-template-manager','main','COM_KUNENA_TEMPLATE_MANAGER','index.php?option=com_kunena&view=templates','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-templates.png','0','1' 1 × SHOW FULL COLUMNS FROM `grc2012_assets 1 × UPDATE grc2012_menu SET lft = 316 , rgt = 317 , level = 2 , path = 'com-kunena/com-kunena-configuration' 1 × UPDATE grc2012_menu SET lft = lft - 4 1 × UPDATE grc2012_menu SET rgt = rgt - 4 1 × SHOW FULL COLUMNS FROM `grc2012_menu 1 × SHOW FULL COLUMNS FROM `grc2012_updates 1 × SHOW FULL COLUMNS FROM `grc2012_extensions 1 × INSERT INTO `grc2012_extensions` (`name`,`type`,`element`,`folder`,`client_id`,`enabled`,`access`,`protected`,`manifest_cache`,`params`) VALUES ('com_kunena','component','com_kunena','','1','1','0','0','{\"legacy\":false,\"name\":\"com_kunena\",\"type\":\"component\",\"creationDate\":\"2012-09-02\",\"author\":\"Kunena Team\",\"copyright\":\"(C) 2008 - 2012 Kunena Team. All rights reserved.\",\"authorEmail\":\"kunena@kunena.org\",\"authorUrl\":\"http:\\/\\/www.kunena.org\",\"version\":\"2.0.2\",\"description\":\"COM_KUNENA_XML_DESCRIPTION\",\" group\":\"\"}','{}' 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('1','1','315','316','com-kunena','main','COM_KUNENA','index.php?option=com_kunena','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-logo-white.png','0','1' 1 × UPDATE grc2012_menu SET lft = 315 , rgt = 316 , level = 1 , path = 'com-kunena' 1 × UPDATE grc2012_menu SET lft = 318 , rgt = 319 , level = 2 , path = 'com-kunena/com-kunena-category-manager' 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','320','321','com-kunena-user-manager','main','COM_KUNENA_USER_MANAGER','index.php?option=com_kunena&view=users','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-users.png','0','1' 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','318','319','com-kunena-category-manager','main','COM_KUNENA_CATEGORY_MANAGER','index.php?option=com_kunena&view=categories','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-categories.png','0','1' 1 × SHOW TABLES LIKE 'grc2012_kunena_version 1 × INSERT INTO `grc2012_menu` (`parent_id`,`level`,`lft`,`rgt`,`alias`,`menutype`,`title`,`link`,`type`,`published`,`component_id`,`access`,`img`,`home`,`client_id`) VALUES ('402','2','316','317','com-kunena-configuration','main','COM_KUNENA_CONFIGURATION','index.php?option=com_kunena&view=config','component','0','10092','1','components/com_kunena/media/icons/favicons/kunena-config.png','0','1' 1 × UPDATE grc2012_menu SET lft = 320 , rgt = 321 , level = 2 , path = 'com-kunena/com-kunena-user-manager' jos-Error: JDatabaseMySQLi::query: 1100 - Table 'grc2012_session' was not locked with LOCK TABLES SQL=UPDATE `grc2012_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:57;s:19:\"session.timer.start\";i:1348228493;s:18:\"session.timer.last\";i:1348229390;s:17:\"session.timer.now\";i:1348229410;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101 Firefox/15.0.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":4:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;s:6:\"manage\";O:8:\"stdClass\":4:{s:4:\"data\";a:1:{s:7:\"filters\";a:5:{s:6:\"search\";s:0:\"\";s:9:\"client_id\";s:0:\"\";s:6:\"status\";s:0:\"\";s:4:\"type\";s:9:\"component\";s:5:\"group\";s:0:\"\";}}s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:4:\"name\";s:9:\"orderdirn\";s:3:\"asc\";}}s:10:\"kunena-old\";i:0;s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";i:20;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:12:\"Rafael Yuste\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:30:\"webmaster@gruyere-rail-club.ch\";s:8:\"password\";s:65:\"d5726deea0a06a859c66603d3edfd7d1:YKilyFON06ATbPA1dTw0BOJ0nNHWqvA2\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:17:\"Super Utilisateur\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2008-11-03 22:09:26\";s:13:\"lastvisitDate\";s:19:\"2012-09-21 11:54:53\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:124:\"{\"admin_style\":\"2\",\"admin_language\":\"fr-FR\",\"language\":\"fr-FR\",\"editor\":\"tinymce\",\"helpsite\":\"\",\"timezone\":\"Europe\\/Zurich\"}\";s:6:\"groups\";a:6:{i:2;s:1:\"2\";i:3;s:1:\"3\";i:4;s:1:\"4\";i:5;s:1:\"5\";i:7;s:1:\"7\";i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:1:\"2\";s:14:\"admin_language\";s:5:\"fr-FR\";s:8:\"language\";s:5:\"fr-FR\";s:6:\"editor\";s:7:\"tinymce\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:13:\"Europe/Zurich\";}}s:14:\"\0*\0_authGroups\";a:8:{i:0;i:1;i:1;i:2;i:4;i:3;i:8;i:4;i:13;i:5;i:15;i:6;i:16;i:7;i:18;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:\"bfc02960890bcaf82c5be0c9bbcce999\";}' , `time` = '1348229411' WHERE `session_id` = '8598a8091313e22be9fdbb6c1776a5ba' JSession -> __destruct() JSession -> close() @ /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/session/session.php:133 JSessionStorageDatabase -> write() @ /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/session/session.php:676 JDatabaseMySQLi -> execute() @ /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/session/storage/database.php:87 JError :: raiseError() @ /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/database/database/mysqli.php:396 JError :: raise() @ /home/www/065a414098f266c66554ab4eec0cb754/web/libraries/joomla/error/error.php:251

ce qui m'inquiète un peu c'est ceci : jos-Error: JDatabaseMySQLi::query: 1100 - Table 'grc2012_session' was not locked with LOCK TABLES notamment...
Dernière édition: 21 Sep 2012 14:56 par focus65.

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Plus d'informations
21 Sep 2012 18:50 #8 par failrOn
Réponse de failrOn sur le sujet installation impossible
Pour ça, il y a déjà un élément avec le même id qui éxiste :
Code:
JDatabaseMySQLi::query: 1062 - Duplicate entry 'com_kunena' for key 2 SQL=INSERT INTO `grc2012_assets` (`name`,`title`,`rules`,`parent_id`,`level`,`lft`,`rgt`) VALUES ('com_kunena','com_kunena','{}','1','1','3543','3544')

Pour ça, la table session a été verrouillée et donc une autre requête essaie de lire ou écrire :
Code:
Table 'grc2012_session' was not locked with LOCK

Essaie de faire ça :
Code:
UNLOCK TABLES
Pour soutenir le projet Kunena : soutenir via le système de sponsor de github
Les utilisateur(s) suivant ont remercié: focus65

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Plus d'informations
22 Sep 2012 17:46 #9 par focus65
Réponse de focus65 sur le sujet installation impossible
Hello,

Merci du conseil, mais il s'est passé un fait étrange... Hier, découragé, j'ai décidé de momentanément tout laisser tomber et de vaquer à d'autres occupations pendant mon après-midi. Des potes de mon club m'ont rendu visite hier soir et je leur ai expliqué mes problèmes en leur présentant la home page et ce qui coinçait... et bin ça coinçait plus ! :laugh:

Mes menus Kunena étaient bien présents dans la partie admin, j'ai pu configurer les accès et faire divers contrôles, bref, le forum fonctionne avec les tables de ma version 1.5.26 et donc tous les posts, attachements, paramètres persos des membres. J'ai juste effectué un contrôle de l'intégrité de la DB et synchroniser la DB Joomla et celle de Kunena...

Faut pas me demander comment cela se fais-ce car impossible de le savoir; est-ce que le fait d'avoir quitté l'admin pendant quelque temps a eu pour effet d'UNLOCK TABLES ? B) ?

En tout cas encore merci de ta patience et du temps consacré à m'aider thumbs up

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Plus d'informations
23 Sep 2012 10:42 #10 par failrOn
Réponse de failrOn sur le sujet installation impossible

focus65 écrit: Faut pas me demander comment cela se fais-ce car impossible de le savoir; est-ce que le fait d'avoir quitté l'admin pendant quelque temps a eu pour effet d'UNLOCK TABLES ? B) ?
[/color][/b]

Je ne sais pas comment marche exactement le système de session de Joomla!

Mais tant mieux que cela marche
Pour soutenir le projet Kunena : soutenir via le système de sponsor de github

Veuillez vous connecter ou vous enregistrer pour rejoindre la conversation.

Modérateurs: lavsteph, failrOn, dede17, serge
Temps de génération de la page : 0.944 secondes
Propulsé par Kunena