Version control systems/platforms such as Git and Subversion store their metadata in hidden folders. When left open via the web, they could reveal sensitive information such as passwords. This holds true even when directory listing is disabled. ————————————— Solution: RedirectMatch 404 /\.git You need to add the above line into your .htaccess or your server Full Article…
Viewing 71 to 80 of 86 items
How to fetch complete customer data in magento
I need to fetch whole customer data from mysql by query. I need to get data by entity_id. Please help ——————————– Answer: Here is what you can do. Activate the sql query log. Edit /lib/Varien/Db/Adapter/Pdo/Mysql.php and set the values for $_debug and $_logAllQueriesto true. then create a custom script that just calls $customerId = Full Article…
Setting Up Git on Windows in Four Easy Steps
Introduction Setting up Git can be intimidating, especially for those that are trying a version control system for the first time or moving from Subversion. It use to be the case that Git was a huge hassle to install and use on Windows. However, today it’s very easy to use Git on Windows either through Full Article…
Can’t re-index new products – Product Attributes
If you re-index your data and you see this error: Product Attributes 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 (`your_database_name`.`catalog_product_index_eav`, CONSTRAINT `FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE)’ in . ..\lib\Zend\Db\Statement\Pdo.php:228 It causes by some products Full Article…
Fixing Magento catalog price rule disappears at night
I have developed the online store on magento platform. Everything works fine except the Catalog price rule for sale. I have created the simple rule that applies 15% discount on all products. When I save and apply the rule, it works fine the whole day. But after 12 at night, the sale is no more Full Article…
Change Magento default increment ID for orders & invoices
Sometimes you will be required to change the default increment ID’s of orders, invoices, credit memos & shipments. To do this is surprisingly simple, yet cannot be done via the backend Admin area without an extension. Today I’ll show you how simple it is to change these numbers with some simple SQL queries to run Full Article…
How to Turn on PayPal IPN When Using Magento & PayPal
What I’ve been really surprised by over the past few weeks is the number of sites that don’t actually have this turned on and it’s just not limited to self builds even the really expensive Magento builds are missing this out this as a step. Turning on the PayPal Instant Payment Notification (IPN for short) Full Article…
Fix Product Flat Data index process unknown error in Magento
A client mentioned that he kept having to reindex the Product Flat Data but the notification in the admin section never went away. While trying to reindex from command line I was greeted with the following error: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Full Article…
CANNOT INITIALIZE THE INDEXER PROCESS IN MAGENTO
This phrase gave me nightmares for days as I was building the new website. We installed a ton of extensions to automate the website, and somewhere along the line some database tables got corrupted, so I had to start a what seemed like an endless game of cat and mouse chasing down what was really wrong Full Article…
Configurable product – Inventory – Stock Availability status doesn’t change when all associated Simple products go out of stock?
I have an Enterprise site (1.12.0.2) and a Community site (1.7.0) both doing the same thing. A configurable product (Manage Stock set to Yes) has just one simple product. Somebody orders the last remaining stock item pushing the simple product's Stock Availability Status into "Out of Stock". However the configurable parent's Stock Availability Status remains Full Article…