Magento技术点滴

1. 修复产品与分类的索引，删除不对应的数据sql: 

delete from rs_catalog_category_product   where not exists 

(select t2.entity_id from rs_catalog_product_entity t2 where t2.entity_id=rs_catalog_category_product.product_id ) 

2.打开backend的debug 模式：

法一：

INSERT INTO core_config_data (scope, scope_id, path, value)

VALUES ('default', 0, 'dev/debug/template_hints', 1),

('default', 0, 'dev/debug/template_hints_blocks', 1);

法二：

Create a custom extension, and inside the etc folder create a system.xml file with the following contents.

?

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23

<? xml version = "1.0" ?> < config >     < sections >         < dev >             < groups >                 < debug >                     < fields >                          < template_hints >                              < show_in_default >1</ show_in_default >                              < show_in_website >1</ show_in_website >                              < show_in_store >1</ show_in_store >                          </ template_hints >                          < template_hints_blocks >                              < show_in_default >1</ show_in_default >                              < show_in_website >1</ show_in_website >                              < show_in_store >1</ show_in_store >                          </ template_hints_blocks >                      </ fields >                 </ debug >             </ groups >         </ dev >      </ sections > </ config >