Archive for the ‘General’ Category
Magento – There was a problem with reindexing process.
Monday, January 16th, 2012Just 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
First Post – Hello World…
Tuesday, March 30th, 2010
Well just finished setting up my blog and this is my first post! I have been meaning to setup a blog for ages but haven’t had the time. I wasn’t sure if i should write my own blog script or use a package but in the end i have decided to try out WordPress. I intend to use this to keep track of my work and use it as an archive on how i solved certain problems. Let’s see how it goes…
-
You are currently browsing the archives for the General category.