magento，重新索引目录URL重写时出错 [英] magento, error when reindexing Catalog URL Rewrites

问题描述

所有这些从1.4.1开始升级

All this afte rupgrading from 1.4.1

我收到一条非常具体的错误消息:

I get a quite specific error message:

具有消息"SQLSTATE [23000]"的下一个异常"Zend_Db_Statement_Exception":违反完整性约束:1062/home/in-due/domains/sb2中的键"UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID"的条目"product/19-1-2"重复. in-due.de/public_html/hochzeitsshop/lib/Zend/Db/Statement/Pdo.php:234

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'product/19-1-2' for key 'UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID'' in /home/in-due/domains/sb2.in-due.de/public_html/hochzeitsshop/lib/Zend/Db/Statement/Pdo.php:234

问题是，我不知道如何找到条目，这很麻烦.后端(catalog | URL重写管理)或数据库本身(表core_url_rewrite)都不是条目

problem is, that I don't know how to find the entry, that is making trouble. neither in the backend (catalog|URL Rewrite Management) nor in the db itself (table core_url_rewrite) is an entry

product/19-1-2

product/19-1-2

感谢您的帮助，

PAT ERLER

PAT ERLER

推荐答案

@perler，这是一个MySQL查询，用于检测重复的SKU.请记住，如果您为表加了前缀，请相应地更改catalog_product_entity！

@perler, here is a MySQL query to detect duplicate SKUs. Remember, if you prefixed your tables, change catalog_product_entity accordingly!

SELECT
    DISTINCT(`sku`) as `sku`,
    COUNT(`sku`) as `skuCount`,
    entity_id
FROM
    catalog_product_entity
GROUP BY
    `sku`
HAVING
    `skuCount` > 1;

这篇关于magento，重新索引目录URL重写时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！