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

Missing Products
 
amweigh
Jr. Member
 
Total Posts:  10
Joined:  2009-04-08
 

One of our employees was adding products to a new site. He says he was clicking save when he received an error message. He could not recall the error message, only saying it said something about “foreign” something. The error was in red, like when you omit a required attribute. When he clicked the back arrow to return to the catalog list, all of the product that he had been adding (all the same manufacturer) was gone. The other products were still there from other manufacturers but the ones that had used this particular attribute set were all missing. When they informed me, I searched the database for the missing products and they still seem to be there. However, they don’t show in the catalog.

I tried doing a repair table on the entire database, but got an error that the storage system does not support repair. I also did a check on the database and the following errors were reported:

Problems with indexes of table `catalogindex_eav`
PRIMARY and INDEX keys should not both be set for column `store_id`
Problems with indexes of table `catalogindex_minimal_price`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `catalogindex_price`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `cataloginventory_stock_item`
UNIQUE and INDEX keys should not both be set for column `product_id`
Problems with indexes of table `catalogrule_product`
UNIQUE and INDEX keys should not both be set for column `rule_id`
Problems with indexes of table `catalogsearch_result`
PRIMARY and INDEX keys should not both be set for column `query_id`
More than one INDEX key was created for column `query_id`
Problems with indexes of table `catalog_category_product`
UNIQUE and INDEX keys should not both be set for column `category_id`
Problems with indexes of table `catalog_category_product_index`
UNIQUE and INDEX keys should not both be set for column `category_id`
More than one INDEX key was created for column `product_id`
Problems with indexes of table `catalog_compare_item`
More than one INDEX key was created for column `customer_id`
Problems with indexes of table `catalog_product_enabled_index`
UNIQUE and INDEX keys should not both be set for column `product_id`
Problems with indexes of table `catalog_product_entity_datetime`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `catalog_product_entity_decimal`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `catalog_product_entity_int`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `catalog_product_entity_text`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `catalog_product_entity_varchar`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `catalog_product_option_price`
More than one INDEX key was created for column `store_id`
Problems with indexes of table `catalog_product_option_title`
More than one INDEX key was created for column `store_id`
Problems with indexes of table `catalog_product_option_type_price`
More than one INDEX key was created for column `store_id`
Problems with indexes of table `catalog_product_option_type_title`
More than one INDEX key was created for column `store_id`
Problems with indexes of table `catalog_product_super_attribute_label`
More than one INDEX key was created for column `product_super_attribute_id`
Problems with indexes of table `core_translate`
UNIQUE and INDEX keys should not both be set for column `store_id`
Problems with indexes of table `core_url_rewrite`
UNIQUE and INDEX keys should not both be set for column `store_id`
More than one INDEX key was created for column `store_id`
More than one UNIQUE key was created for column `store_id`
More than one INDEX key was created for column `category_id`
Problems with indexes of table `customer_address_entity_datetime`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `customer_address_entity_decimal`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `customer_address_entity_int`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `customer_address_entity_text`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `customer_address_entity_varchar`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `customer_entity_datetime`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `customer_entity_decimal`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `customer_entity_int`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `customer_entity_text`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `customer_entity_varchar`
UNIQUE and INDEX keys should not both be set for column `entity_id`
More than one INDEX key was created for column `entity_id`
Problems with indexes of table `downloadable_link`
More than one INDEX key was created for column `product_id`
Problems with indexes of table `eav_attribute`
UNIQUE and INDEX keys should not both be set for column `entity_type_id`
More than one INDEX key was created for column `entity_type_id`
Problems with indexes of table `eav_attribute_group`
UNIQUE and INDEX keys should not both be set for column `attribute_set_id`
Problems with indexes of table `eav_attribute_set`
UNIQUE and INDEX keys should not both be set for column `entity_type_id`
Problems with indexes of table `eav_entity_attribute`
UNIQUE and INDEX keys should not both be set for column `attribute_set_id`
Problems with indexes of table `eav_entity_datetime`
More than one INDEX key was created for column `entity_type_id`
More than one INDEX key was created for column `attribute_id`
Problems with indexes of table `eav_entity_decimal`
More than one INDEX key was created for column `entity_type_id`
More than one INDEX key was created for column `attribute_id`
Problems with indexes of table `eav_entity_int`
More than one INDEX key was created for column `entity_type_id`
More than one INDEX key was created for column `attribute_id`
Problems with indexes of table `eav_entity_varchar`
More than one INDEX key was created for column `entity_type_id`
More than one INDEX key was created for column `attribute_id`
Problems with indexes of table `sales_order_datetime`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_decimal`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_entity_datetime`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_entity_decimal`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_entity_int`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_entity_text`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_entity_varchar`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_int`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_text`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `sales_order_varchar`
UNIQUE and INDEX keys should not both be set for column `entity_id`
Problems with indexes of table `tag_summary`
PRIMARY and INDEX keys should not both be set for column `tag_id`
Problems with indexes of table `tax_calculation`
More than one INDEX key was created for column `tax_calculation_rate_id`
Problems with indexes of table `tax_calculation_rate_title`
More than one INDEX key was created for column `tax_calculation_rate_id`

Are the products gone for good? Is there any way to repair the database?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top