Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Réécriture d’URL du catalogue toujours en cours
 
pascalbeli
Jr. Member
 
Total Posts:  1
Joined:  2012-05-11
 

Bonsoir,

J’ai mise à jour mon magento v1.4 vers une v1.6 et je n’arrive plus a recréer l’index d’url du catalogue. Deplus une requête SQL se lance toute les 4-5 minutes :
SELECT
`e`.*,
IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`,
IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`,
`core_url_rewrite`.`request_path`
FROM `catalog_category_entity` AS `e`
INNER JOIN `catalog_category_entity_int` AS `at_is_active_default`
ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`)
AND (`at_is_active_default`.`attribute_id` = ‘119’)
AND `at_is_active_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_is_active`
ON (`at_is_active`.`entity_id` = `e`.`entity_id`)
AND (`at_is_active`.`attribute_id` = ‘119’)
AND (`at_is_active`.`store_id` = 3)
INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default`
ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`)
AND (`at_include_in_menu_default`.`attribute_id` = ‘932’)
AND `at_include_in_menu_default`.`store_id` = 0
LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu`
ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`)
AND (`at_include_in_menu`.`attribute_id` = ‘932’)
AND (`at_include_in_menu`.`store_id` = 3)
LEFT JOIN `core_url_rewrite`
ON (core_url_rewrite.category_id=e.entity_id)
AND (core_url_rewrite.is_system=1
AND core_url_rewrite.product_id IS NULL
AND core_url_rewrite.store_id=’3’
AND id_path LIKE ‘category/%’)
WHERE (`e`.`entity_type_id` = ‘9’) # type catalog_category_id
AND (`e`.`entity_id`
IN(’20’, ‘10’, ‘22’, ‘23’, .............................................................
AND (`e`.`entity_id` NOT
IN(’8’, ‘16’, ‘16’, .......................................
‘966’))
AND (IF(at_is_active.value_id > 0,
at_is_active.value,
at_is_active_default.value) = ‘1’)
AND (IF(at_include_in_menu.value_id > 0,
at_include_in_menu.value,
at_include_in_menu_default.value) = ‘1’);

et tourne sans arrêt.

Mon herbergeur me demande de trouver une solution au plus vite mais je ne sais plus quoi faire.

Une aide me serait plus qu’utile.

Merci d’avance

File Attachments
sqlChiantTraitement.sql  (File Size: 10KB - Downloads: 37)
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top