Magento 1

Magento: Problem with reindexing process for “Product flat data” indexes

Problem with reindexing process for "Product flat data" indexes
Problem with reindexing process for "Product flat data" indexes

Symptoms

Reindexing of Product flat data index gives unknown reindexing error or “Some problem with reindexing process” error message or reindexing of Product flat data index is never completed.

Attempt to reindex it via command line gives the following error message:

$ php -f shell/indexer.php -- --reindex catalog_product_flat
Product Flat Data index process unknown error:
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (<result 2 when explaining filename '#sql-'>, CONSTRAINT ´FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID´ FOREIGN KEY (´entity_id´) REFERENCES ´catalog_product_entity´ (´entity_id)' in lib/Zend/Db/Statement/Pdo.php:228

(more…)

Continue ReadingMagento: Problem with reindexing process for “Product flat data” indexes

Magento: Automated Bash Script Installer

Magento: Automated Bash Script Installer
Magento: Automated Bash Script Installer

The following SSH script will automate the process of installing Magento, with or without sample data. It will walk you through everything, and the only thing you need to setup first is the database and assign a user to the database.

You will need SSH access to use this. SSH is similar to FTP, in that it requires software that you’ll need to download in order to connect to your site. If you don’t have an SSH client, you can download PuTTY for free.
(more…)

Continue ReadingMagento: Automated Bash Script Installer

Magento: How To Setup / integrate Google Adwords Conversion Tracking?

Magento: How To Setup Google Adwords Conversion Tracking
Magento: How To Setup Google Adwords Conversion Tracking

Setting up Google Adwords Conversion Tracking on your Magento Community store is relatively easy – but it’s not a built-in Magento feature, so you’ll have to edit a template file. Here are the 4 simple steps that need to be done: (more…)

Continue ReadingMagento: How To Setup / integrate Google Adwords Conversion Tracking?

Magento: “There has been an error processing your request”

Symptoms
The following error message is shown instead of your usual Magento page:
There has been an error processing your request
Exception printing is disabled by default for security reasons.
Error log record number: 1286489434787

Cause
Usually, it is caused by calling incompatible classes in themes, extensions or templates, database connectivity issues or resource shortage (i.e. insufficient diskspace or PHP memory_limit option).
(more…)

Continue ReadingMagento: “There has been an error processing your request”

Magento shows blank/empty page. How do I solve this?


Symptoms
Blank page is shown in Magento Frontend, Backend or Magento Connect Manager

Cause
If you see a blank page opening your Store in browser, it indicates that there is a PHP syntax error somewhere in the code of your site.
This usually happens when you modified files, templates or extensions manually, or installed a theme or extension with PHP syntax errors.

Troubleshooting
Before starting investigation please try to Disable Magento Compiler and Clear cached Magento data , in the most cases it should solve the issue.
To see the actual error message you need to login via FTP to your Store and use the following instructions:
(more…)

Continue ReadingMagento shows blank/empty page. How do I solve this?