^ Scroll to Top
Contact us | Login

Archive for January, 2012

Magento – There was a problem with reindexing process.

Monday, January 16th, 2012

Just a quick blog about this one as it wasted about an hour of my time and wanted to help others (and remind myself for future reference)

I had a customer who had this error when trying to re-index his Category Products “ There was a problem with reindexing process.”

After a bit of digging the solution was to:

1. Backup the SQL table “catalog_category_product_index” with “Disable foreign key checks” ticked.
2. Drop the table.
3. Remove the constraints at the bottom of the backup file, except “SET FOREIGN_KEY_CHECKS=1;”
so on my file it was this
“ALTER TABLE `catalog_category_product_index`

ADD CONSTRAINT `FK_CATALOG_CATEGORY_PROD_IDX_CATEGORY_ENTITY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_CATALOG_CATEGORY_PROD_IDX_PROD_ENTITY` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE;”
4. Save and Import your backup file, or runt the sql directly.
5. You should then be able to run the re-index from the magento backend.
6. If 5 did not work(you might have thousands of products) SSH to your install and go to /shell/ and run this command.
“php indexer.php –reindex catalog_category_product”
if you want to re-index all run this “php indexer.php reindexall”
That’s it, i hope this helps some one…
Stiofan

GeoTheme.com

Monday, January 16th, 2012


GeoTheme has been under development for about a year and since partnering with an Italian web marketing agency it’s development has progressed more quickly and was officially launched in December 2011.

GeoTheme is what can be called a wordpress Yelp clone . The theme has been developed to create beautiful Geo Portals and Directories just like Yelp or Trip Advisor.

We have added some awesome features to the theme and we are constantly updating and improving it. We have both Iphone and Android app’s under development to make this a complete package.

GeoTheme can be bought for only $85, yes $ dollars, this is because it is the most Internationally used currency and GeoTheme is a global product.

I am very excited about this project and things have started of well for us, you can view the demo here http://demo.geotheme.com/

Here you can also view some example of sites users have made: GeoTheme Showcase