Magento错误：异常'PDOException'，消息'SQLSTATE [23000]

尝试从XML文件上传产品时，我从Magento收到以下错误：

数组（[id] => 1 [文件名] => /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/temp/xmlimport/Alpha_price_046551_01.xml [processed] => 0 [adddate ] => 1386340077）记录数：1000异常'PDOException'，消息'SQLSTATE [23000]：完整性约束违规：1452无法添加或更新子行：外键约束失败（db23517_TestMagento / catalog_category_product，CONSTRAINT FK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID FOREIGN KEY（ category_id）REFERENCES catalog_category_entity（entity_id）ON DEL）'在/var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Statement/Pdo.php:228堆栈跟踪：＃0 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Statement/Pdo.php(228):PDOStatement-> execute（Array）＃1 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Statement.php(320）：Zend_Db_Statement_Pdo - > _ execute（Array）＃2 / var / www /虚拟主机/一十二万零四百六十三分之八/我们bspace / httpdocs / casesupply.nl / importer / lib / 3rdparty / Zend / Db / Adapter / Abstract.php（468）：Zend_Db_Statement-> execute（Array）＃3 / var / www / vhosts / 8/120463 / webspace / httpdocs /casesupply.nl/importer/lib/3rdparty/Zend/Db/Adapter/Pdo/Abstract.php(238):Zend_Db_Adapter_Abstract-> query（'INSERT INTO ca ...'，Array）＃4 / var / www / vhosts /8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Adapter/Abstract.php(546):Zend_Db_Adapter_Pdo_Abstract-> query（'INSERT INTOca ...'，Array）＃5 / var / www / vhosts / 8/120463 / webspace / httpdocs / casesupply.nl / importer / models / productsModel.php（818）：Zend_Db_Adapter_Abstract-> insert（'catalog_categor ...'，Array）＃6 / var / www / vhosts / 8/120463 / webspace / httpdocs / casesupply.nl / importer / import2.php（461）：ProductsModel-> updateProduct（Array，NULL，Array）＃7 下一个异常'Zend_Db_Statement_Exception'，消息'SQLSTATE [23000 ]：完整性约束违规：1452无法添加或更新子行：外键约束失败（db23517_TestMagento / catalog_cat egory_product，CONSTRAINT FK_CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID FOREIGN KEY（category_id）REFERENCES /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Statement/中的catalog_category_entity（entity_id）ON DEL）' Pdo.php：234堆栈跟踪：＃0 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Statement.php(320）：Zend_Db_Statement_Pdo - > _ execute （数组）＃1 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Adapter/Abstract.php(468）：Zend_Db_Statement-> execute（Array） ＃2 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Adapter/Pdo/Abstract.php(238):Zend_Db_Adapter_Abstract-> query（'INSERT INTO ca ...'，Array）＃3 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/lib/3rdparty/Zend/Db/Adapter/Abstract.php(546):Zend_Db_Adapter_Pdo_Abstract- > query（'INSERT INTOca ...'，Array）＃4 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/ importer / models / productsModel.php（818）：Zend_Db_Adapter_Abstract-> insert（'catalog_categor ...'，Array）＃5 /var/www/vhosts/8/120463/webspace/httpdocs/casesupply.nl/importer/import2 . php（461）：ProductsModel-> updateProduct（Array，NULL，Array）＃6

每天晚上，XML文件都会更新我的所有产品，但最近我发现有些产品没有正确上传 . 所以我删除了数据库中的所有产品 . 我用了一个脚本 . 现在我想重新上载XML文件中的所有产品，但我不断收到此错误消息 . 希望有人可以帮助我解决这个问题 .