«banners/categories» dans tous les url de nouveaux éléments de menu

**boumy** · 30/09/2013, 21h15

Re : «banners/categories» dans tous les url de nouveaux éléments de menu

Bonjour.

J'ai supprimé l'équivalent de ceci:

Code:

INSERT INTO `xyz_menu` VALUES ('103', 'menu-tek', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners', 'component', '0', '2', '2', '4', '0', '0', '0000-00-00 00:00:00', '0', '0', 'class:banners', '0', '', '112', '131', '0', '*', '1');
INSERT INTO `xyz_menu` VALUES ('104', 'menu-tek', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&extension=com_banners', 'component', '0', '2', '2', '6', '0', '0', '0000-00-00 00:00:00', '0', '0', 'class:banners-cat', '0', '', '114', '131', '0', '*', '1');

Edit: Le problème a été résolu pour un temps seulement

**boumy** · 07/10/2013, 19h42

Re : «banners/categories» dans tous les url de nouveaux éléments de menu

Salut.

Je serais vraiment reconnaissant d'avoir votre aide.

Mon problème est toujours là. Et je continue à essayer de le résoudre par moi-même.

Voici une capture d'écran de PhpMyAdmin pour ce site particulier

menu table

http://ge.tt/4yRGLxt/v/1?c

http://ge.tt/4yRGLxt/v/0?c

Comme vous pouvez le voir avec les deux flèches rouges, l'élément nouvellement créé contient / Tracks quelque part dans son "path" (l'URL SEF généré par Joomla). Cette chaîne "/ Tracks" ne devrait pas être là. Cela génère un page 404. Même si je supprime "/ Tracks" dans le champ d'adresse de mon navigateur.

La seule solution que j'ai trouvée jusqu'à présent est de modifier ce "path" dans phpmyadmin et d'y supprimer la chaîne de caractères "/ Tracks".

Une idée de ce qui ne va pas dans tout cela? L'id parent?

Merci beaucoup.

**boumy** · 08/10/2013, 19h40

Re : «banners/categories» dans tous les url de nouveaux éléments de menu

Et il y a pire: quand j'édite un élément de menu (donc un élément de menu qui existe déjà) le «path» foireux est recréé!
Par exemple: je change la catégorie d'un item de menu de type affichage blog (ou même je ne change rien du tout), puis j'enregistre, et là le path est à nouveau mal réglé!

**boumy** · 08/10/2013, 21h31

Re : «banners/categories» dans tous les url de nouveaux éléments de menu

Et voici les requêtes (partie I) qui se produisent quand j'enregistre l'item de menu.

Code:

27 requêtes exécutées
SELECT `data` 
  FROM `xyz_session` 
  WHERE `session_id` = 'phogrmr6jee1j3l6r9qcs8ncl5'
DELETE 
  FROM `xyz_session` 
  WHERE `time` < '1381260339'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM xyz_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params 
  FROM xyz_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1,2,3,5) 
  ORDER BY ordering
SELECT template, s.params 
  FROM xyz_template_styles as s 
  LEFT JOIN xyz_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 xyz_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_menus'
SHOW FULL COLUMNS 
  FROM `xyz_menu`
SELECT * 
  FROM xyz_menu 
  WHERE `id` = '274'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM xyz_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_content'
SELECT * 
  FROM xyz_menu 
  WHERE `id` = '274'
SELECT * 
  FROM xyz_menu 
  WHERE `id` = '274'
SELECT a.id, a.title, a.position, a.published, map.menuid,(SELECT COUNT(*) 
  FROM xyz_modules_menu 
  WHERE moduleid = a.id 
  AND menuid < 0) AS `except`,ag.title AS access_title 
  FROM xyz_modules AS a 
  LEFT JOIN xyz_modules_menu AS map 
  ON map.moduleid = a.id 
  AND map.menuid IN (0, 274, -274) 
  LEFT JOIN xyz_viewlevels AS ag 
  ON ag.id = a.access 
  WHERE a.published >= 0 
  AND a.client_id = 0 
  ORDER BY a.position, a.ordering
SELECT name, element AS `option` 
  FROM xyz_extensions 
  WHERE type = 'component' 
  AND enabled = 1 
  ORDER BY name ASC
SELECT a.id AS value, a.title AS text 
  FROM xyz_viewlevels AS a 
  GROUP BY a.id, a.title, a.ordering 
  ORDER BY a.ordering ASC,`title` ASC
SELECT menutype AS value, title AS text 
  FROM `xyz_menu_types` 
  ORDER BY title
SELECT a.id AS value, a.title AS text, a.level 
  FROM xyz_menu AS a 
  LEFT JOIN `xyz_menu` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt 
  LEFT JOIN `xyz_menu` AS p 
  ON p.id = 274 
  WHERE a.menutype = 'menu-principal' 
  AND NOT(a.lft >= p.lft 
  AND a.rgt <= p.rgt) 
  AND a.published != -2 
  GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.menutype, a.parent_id, a.published 
  ORDER BY a.lft ASC
SELECT a.id AS value, a.title AS text 
  FROM xyz_menu AS a 
  WHERE a.published >= 0 
  AND a.parent_id =154 
  AND a.menutype = 'menu-principal' 
  ORDER BY a.lft ASC
SELECT a.lang_code AS value, a.title AS text, a.title_native 
  FROM xyz_languages AS a 
  WHERE a.published >= 0 
  ORDER BY a.title
SELECT s.id, s.title, e.name as name, s.template 
  FROM xyz_template_styles as s 
  LEFT JOIN xyz_extensions as e 
  on e.element=s.template 
  WHERE s.client_id = 0 
  AND e.enabled=1 
  AND `e`.`type`='template' 
  ORDER BY template,title
SELECT a.id, a.title, a.level 
  FROM xyz_categories AS a 
  WHERE a.parent_id > 0 
  AND extension = 'com_content' 
  AND a.published IN (0,1) 
  ORDER BY a.lft
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM xyz_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_media'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM xyz_modules AS m 
  LEFT JOIN xyz_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN xyz_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-10-08 19:55:39') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-10-08 19:55:39') 
  AND m.access IN (1,1,2,3,5) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
SELECT COUNT(*) 
  FROM xyz_messages 
  WHERE state = 0 
  AND user_id_to = 62
SELECT COUNT(session_id) 
  FROM xyz_session 
  WHERE guest = 0 
  AND client_id = 1
SELECT COUNT(session_id) 
  FROM xyz_session 
  WHERE guest = 0 
  AND client_id = 0
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM xyz_menu AS m 
  LEFT JOIN xyz_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1 
  ORDER BY m.lft
UPDATE `xyz_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:73;s:19:\"session.timer.start\";i:1381258420;s:18:\"session.timer.last\";i:1381262139;s:17:\"session.timer.now\";i:1381262139;s:22:\"session.client.browser\";s:117:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/536.30.1 (KHTML, like Gecko) Version/6.0.5 Safari/536.30.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":8:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";N;}}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:14:\"menu-principal\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":4:{s:2:\"id\";a:1:{i:0;i:274;}s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":4:{s:8:\"ordercol\";s:5:\"
  group\";s:6:\"filter\";O:8:\"stdClass\":1:{s:9:\"client_id\";i:0;}s:10:\"limitstart\";s:1:\"0\";s:9:\"orderdirn\";s:3:\"asc\";}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
  limit\";i:100;}}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admyn\";s:5:\"email\";s:19:\"me@mymail.com\";s:8:\"password\";s:65:\"__32_signs_here__:__32_signs_here__\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-01-08 22:45:09\";s:13:\"lastvisitDate\";s:19:\"2013-10-08 09:27:37\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:18:\"{\"timezone\":\"UTC\"}\";s:6:\"groups\";a:1:{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\":1:{s:8:\"timezone\";s:3:\"UTC\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:5;}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:\"__32_signs_here__\";}__wf|a:1:{s:13:\"session.token\";s:32:\"__32_signs_here__\";}' , `time` = '1381262139' 
  WHERE `session_id` = '__32_signs_here__'

**boumy** · 08/10/2013, 21h33

Re : «banners/categories» dans tous les url de nouveaux éléments de menu

Voici la partie II des requêtes (j'ai posté en 2 fois étant donné les limitations du forum pour les textes trop long)

Code:

21 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
4 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM xyz_extensions
3 × SELECT * 
  FROM xyz_menu
2 × SELECT COUNT(session_id) 
  FROM xyz_session
1 × SELECT s.id, s.title, e.name as name, s.template 
  FROM xyz_template_styles as s 
  LEFT JOIN xyz_extensions as e 
  on e.element=s.template
1 × SELECT a.lang_code AS value, a.title AS text, a.title_native 
  FROM xyz_languages AS a
1 × SELECT a.id, a.title, a.level 
  FROM xyz_categories AS a
1 × SELECT COUNT(*) 
  FROM xyz_messages
1 × SELECT a.id AS value, a.title AS text 
  FROM xyz_menu AS a
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM xyz_menu AS m 
  LEFT JOIN xyz_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM xyz_modules AS m 
  LEFT JOIN xyz_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN xyz_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT menutype AS value, title AS text 
  FROM `xyz_menu_types`
1 × SELECT template, s.params 
  FROM xyz_template_styles as s 
  LEFT JOIN xyz_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 xyz_extensions
1 × SELECT a.id, a.title, a.position, a.published, map.menuid,(SELECT COUNT(*) 
  FROM xyz_modules_menu
1 × SELECT name, element AS `option` 
  FROM xyz_extensions
1 × SELECT `data` 
  FROM `xyz_session`
1 × SELECT a.id AS value, a.title AS text 
  FROM xyz_viewlevels AS a 
  GROUP BY a.id, a.title, a.ordering
1 × SELECT a.id AS value, a.title AS text, a.level 
  FROM xyz_menu AS a 
  LEFT JOIN `xyz_menu` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt 
  LEFT JOIN `xyz_menu` AS p 
  ON p.id = 274
Autres tables :
1 × UPDATE `xyz_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:73;s:19:\"session.timer.start\";i:1381258420;s:18:\"session.timer.last\";i:1381262139;s:17:\"session.timer.now\";i:1381262139;s:22:\"session.client.browser\";s:117:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/536.30.1 (KHTML, like Gecko) Version/6.0.5 Safari/536.30.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":8:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}}s:10:\"com_config\";O:8:\"stdClass\":1:{s:6:\"config\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"data\";N;}}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:14:\"menu-principal\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":4:{s:2:\"id\";a:1:{i:0;i:274;}s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:9:\"com_cache\";O:8:\"stdClass\":1:{s:5:\"cache\";O:8:\"stdClass\":4:{s:8:\"ordercol\";s:5:\"
  group\";s:6:\"filter\";O:8:\"stdClass\":1:{s:9:\"client_id\";i:0;}s:10:\"limitstart\";s:1:\"0\";s:9:\"orderdirn\";s:3:\"asc\";}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
  limit\";i:100;}}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admyn\";s:5:\"email\";s:19:\"me@mymail.com\";s:8:\"password\";s:65:\"__32_signs_here__:__32_signs_here__\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-01-08 22:45:09\";s:13:\"lastvisitDate\";s:19:\"2013-10-08 09:27:37\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:18:\"{\"timezone\":\"UTC\"}\";s:6:\"groups\";a:1:{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\":1:{s:8:\"timezone\";s:3:\"UTC\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:5;}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:\"__32_signs_here__\";}__wf|a:1:{s:13:\"session.token\";s:32:\"__32_signs_here__\";}' , `time` = '1381262139'
1 × SHOW FULL COLUMNS 
  FROM `xyz_menu
1 × DELETE 
  FROM `xyz_session`

**boumy** · 06/04/2014, 13h58

Re : «banners/categories» dans tous les url de nouveaux éléments de menu

Un membre du forum anglais m'a soufflé un truc qui semble fonctionner: http://forum.joomla.org/viewtopic.php?f=624&t=820656
Il suffirait de choisir "Reconstruire" dans la fenêtre du backend pour le menu concerné. Et, de préférence, vider les caches Joomla ensuite.

«banners/categories» dans tous les url de nouveaux éléments de menu

[RÉGLÉ] «banners/categories» dans tous les url de nouveaux éléments de menu

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Annonce

Partenaire de l'association