Skip to content

Instantly share code, notes, and snippets.

View gygi's full-sized avatar

Ted gygi

View GitHub Profile
@gygi
gygi / SiteMapSQL Error
Created April 11, 2015 16:23
Magento Sitemap SQL error
Sitemap generate warnings: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query, query was: SELECT `main_table`.`entity_id`, `url_rewrite`.`request_path` FROM `catalog_product_entity` AS `main_table` INNER JOIN `catalog_product_website` AS `w` ON main_table.entity_id = w.product_id LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.product_id = main_table.entity_id AND url_rewrite.is_system = 1 AND url_rewrite.category_id IS NULL AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'product/%' INNER JOIN `catalog_product_entity_int` AS `t1_visibility` ON main_table.entity_id=t1_visibility.entity_id AND t1_visibility.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `t2_visibility` ON t1_visibility.entity_id = t2_visibility.entity_id AND t1_visibility.attribute_id = t2_visibility.attribute_id AND t2_visibility.store_id = 1 INNER JOIN `catalog_product_entity_int` AS `t1_status` ON main_table.entity_id=t1_status.entity_id AND t1_status.store_id=0 LEFT JOIN `catalog_