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

Catalog Index rebuild error. Please try again later - Error After Upgrade and Import
 
PurpleARO
Member
 
Total Posts:  50
Joined:  2009-02-25
 

I was able to successfully install a FRESH INSTALL of the latest magento software with no hitches, I used Magneticones Cart 2 Cart Importation and was able to successfully import all products,prices and images with no issues.

Now I did new Attributes and I clicked on Catalog Index Rebuild - REFRESH

I got the (Catalog Index rebuild error. Please try again later) error…

I have searched the forums and nothing really matches this issue.

Is there a work around for this issue.

Thank you

 
Magento Community Magento Community
Magento Community
Magento Community
 
PurpleARO
Member
 
Total Posts:  50
Joined:  2009-02-25
 

Just realized most of the errors people are discussing here are for the SEARCH INDEX rebuild....My main problem is the Catalog Index Rebuild..  Hopefully someone can guide me with what I am missing.

 
Magento Community Magento Community
Magento Community
Magento Community
 
abort73
Jr. Member
 
Total Posts:  2
Joined:  2008-03-24
 

I’m having the same problem… upgraded to 1.3.2.3, tried to assign a category to a product; got the following error: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘store_id’ in ‘where clause’

Tried to “Rebuild Catalog Index”. Got the following error: “Catalog Index rebuild error. Please try again later”

I get the same error when trying to “Rebuild Flat Catalog Product”.

I’m able to “Rebuild Flat Catalog Category” successfully.

Not sure how to proceed…

 
Magento Community Magento Community
Magento Community
Magento Community
 
deggertsen
Jr. Member
 
Avatar
Total Posts:  30
Joined:  2008-12-17
Utah
 

Same problem here. Is there a way to rebuild and refresh caches manually? It seems like Magento has a hard time with a lot of things when run on a shared server. Is everybody else that has posted with this problem running on a shared server?

 
Magento Community Magento Community
Magento Community
Magento Community
 
diglin
Sr. Member
 
Avatar
Total Posts:  93
Joined:  2008-12-29
Zurich - Switzerland
 

Use your preferred MySQL manager software: phpmyadmin for example and check the state of the tables. If a problem occurs (for the catalogsearch_fulltext table for example) you will see the problem. So just do a Repair table ‘xyz’ with your software or with a SQL query.

 
Magento Community Magento Community
Magento Community
Magento Community
 
deggertsen
Jr. Member
 
Avatar
Total Posts:  30
Joined:  2008-12-17
Utah
 

When I ran a database check everything checked out OK. When I went ahead and did a database repair some of the tables check out OK while others gave me this note

note : The storage engine for the table doesn’t support repair

.
 
Magento Community Magento Community
Magento Community
Magento Community
 
diglin
Sr. Member
 
Avatar
Total Posts:  93
Joined:  2008-12-29
Zurich - Switzerland
 

You should check if your tables use the correct Engine for Magento 95% is InnoDB but some old tables use MyISAM. I don’t have the list. And if your check provide a OK statement it changes nothing to try to repair.
But so, in my case, I had this problem few minutes ago with the error in the title of this topic and I did this check and repair. It was necessary for the catalog_fulltext table only in my side.

 
Magento Community Magento Community
Magento Community
Magento Community
 
spectrumaudio
Member
 
Total Posts:  39
Joined:  2008-07-22
 

Has anyone confirmed what causes this problem? I am having the same problem. I get this error:

“Error while refreshed Catalog Rewrites. Please try again later”

I have checked database and repaired also running InnoDB on tables too.

Any advise or help would be appreciated.

Thanks

Currently running version 1.3.1

 
Magento Community Magento Community
Magento Community
Magento Community
 
diglin
Sr. Member
 
Avatar
Total Posts:  93
Joined:  2008-12-29
Zurich - Switzerland
 

In my case, I don’t know the reason of this. And i didn’t have the problem anymore. However, it’s possible that you have to dump the database and import it again. You could too update Magento to a higher version 1.3.x or even 1.4.

Regards

 
Magento Community Magento Community
Magento Community
Magento Community
 
spectrumaudio
Member
 
Total Posts:  39
Joined:  2008-07-22
 

So far my developer told me the problem, is caused by PHP version 5.3.

I will update the post if I figure it out.

 
Magento Community Magento Community
Magento Community
Magento Community
 
wsj3
Guru
 
Avatar
Total Posts:  521
Joined:  2008-07-13
Portland, OR
 

Did anyone ever come up with a recommended way to fix this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
michaelc
Member
 
Avatar
Total Posts:  64
Joined:  2008-05-21
Qld, Australia
 

I had incurred this same error on our site.
I started getting this error on both “Rebuild Flat Catalog Product” and “Rebuild Flat Catalog Category”.

Disabling all Caches and then re-running the indexes worked first time for us.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Giannis-M-
Jr. Member
 
Avatar
Total Posts:  24
Joined:  2010-06-24
Greece
 

Repairing the database fixed it for me! Thanks Sylvain_Raye!

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