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

Database errors
 
dynamedia
Jr. Member
 
Total Posts:  8
Joined:  2008-09-26
 

Hi All,

I’ve just updated two installs - neither of which are live just yet, and noticed that one site in particular now seems to be seriously struggling with database queries. In an attempt to resolve this, I’ve tried to check and optimise the tables from my host’s sql manager. When I run a check on either site (both on completely different hosting providers), there are 50+ mysql table index key errors, ie.

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_price`
More than one INDEX key was created for column `store_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 `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`
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`

etc, etc. On one of the hosts, any attempt to optimise the table results in the sql server stalling altogether.

Is this a known issue? I’m reasonably familiar with mysql, but not sufficiently competent to say that this is definitely wrong - but certainly seems that way to me?! Is this the upgrade process gone astray, or is this just an issue with the way Magento is routinely coded?

Thanks in advance

 
Magento Community Magento Community
Magento Community
Magento Community
 
jogide
Jr. Member
 
Total Posts:  17
Joined:  2008-11-19
 

Hi,

the same problem.

Some info about it ?

Thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
chadhenry
Member
 
Total Posts:  38
Joined:  2009-01-01
 

I’m having the same issue. Anyone have an answer to this problem?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mootrealm
Sr. Member
 
Avatar
Total Posts:  150
Joined:  2007-09-14
San Francisco, CA
 

Did anyone figure this out? I am having this issue with 1.4.0.1

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