9 votes
Accepted

Remove specific criteria from Varien_Db_Select join

So this is what I came up with: $fromAndJoins = $select->getPart(Zend_Db_Select::FROM); foreach($fromAndJoins as $key=>$joins){ if(strpos($joins['joinCondition'],$attribute->...
Anna's user avatar
  • 1,645
7 votes

How to stop index process in running

Stopping the indexing process is an easy task. When Magento starts indexing, it updates the status in the table index_process to working. If the script stops working due to some error or server ...
Abhinav Singh's user avatar
6 votes

Products exist in the database but are not showing in backend or frontend

I managed to reproduce the effect. If the status doesn't have the value "1" (enabled) or "2" (disabled), the product doesn't display at all. You can fix this as follows. Create a PHP file in the base ...
Andreas von Studnitz's user avatar
4 votes

Remove specific criteria from Varien_Db_Select join

Here is the method I would use. You can get the conditions ("where" part) like this: $where = $collection->getSelect()->getPart('where'); Then you can loop through the conditions like this: ...
Raphael at Digital Pianism's user avatar
4 votes

Enterprise 1.14.1 Swatches causing 35 sec plus load time on category pages

Additional way to improve performance configurable swatches when you have a lot of attribute options. For example if you have 2000 options and show 36 products in catalog list, in this case method ...
Yaroslav Voronoy's user avatar
4 votes

How to change order increment prefix?

Better use model wrappers rather than raw sql statements. Example: $productEntityType = Mage::getModel('eav/entity_type') ->loadByCode(Mage_Catalog_Model_Product::ENTITY); $entityStoreConfig =...
Aleksey Razbakov's user avatar
4 votes

event observer in magento not working

The module cannot be loaded. In app/etc/modules/pan_Registration.xml you specify that the module is found in app/code/local/pan/Registration, but you put it in app/code/local/TM/ProductConditions. ...
Fabian Schmengler's user avatar
4 votes
Accepted

Error when reindexing "Category Products" - Integrity constraint violation: 1452

I found the answer that works for me in another thread here https://stackoverflow.com/a/34810007/2810565I : Go to PhpMyAdmin and run this query: ALTER TABLE catalog_category_product_index DROP ...
Anna's user avatar
  • 1,645
4 votes

How to load custom CSS for individual product

Go to admin, and edit your product. In Custom Layout Update, add following XML code : <reference name="head"> <action method="addItem"><type>skin_css</type><name>...
Anil Suthar's user avatar
  • 4,731
4 votes

Issue applying SUPEE-10752 (no errors)

When applying any patch to the Magento make sure you have applied the previous patch also into it. If it is not applied then may be you can face some error as because many times the new patches are ...
Abhishek Tripathi's user avatar
3 votes

How disable Paypal express checkout or require a shipping price

Here's how to see the setting that David Manners wrote about, to disable PayPal express: go to system -> configuration -> Payment Methods click configure button of PayPal Express Checkout under ...
Mitch Goldman - londonmitch's user avatar
3 votes

Shopping Cart Rule Causing Internal Sever Error 500

Based on comments on @kalpesh link this also solved the problem for me. (adding the fix here for future reference) There is a patch for this https://gist.github.com/piotrekkaminski/...
karpa's user avatar
  • 396
3 votes

CMS Pages and static blocks not editable

Class Varien_Data_Collection_Filesystem not found Check to make sure lib/Varien/Data/Collection/Filesystem.php exist and has the correct permission. If it does not exist download a fresh copy of your ...
MagePal Extensions's user avatar
3 votes
Accepted

How to stop Magento from sending emails via cron?

Standard this involves a lot of customisation and changing of core files (of course via overwrite instead of really changing core files). There is a solution via a extensions though. the SMTP Pro ...
Kay Int Veen's user avatar
  • 1,503
3 votes
Accepted

Magento isn't upgradable through Magento Connect Manager

The reason behind that is that the Magento Connect Manager has not been initiated by a previous install/upgrade. It could be because this store has been installed by transferring files via FTP. Thus, ...
Raphael at Digital Pianism's user avatar
3 votes
Accepted

How can I add a field in admin panel > system > configuration > General Tab?

In your module add below code: In file app/code/local/Namesapce/Modulename/etc/system.xml <general> <groups> <test translate="label"> ...
Prashant Valanda's user avatar
3 votes
Accepted

ESI processing not enabled error only on Product detail page Varnish and Magento 1.9

Varnish 4 does not support -p esi_syntax=, instead you have to use -p feature= -p feature=+esi_disable_xml_check,+esi_ignore_other_elements esi_disable_xml_check, "Don't check of body looks like XML"...
MagenX's user avatar
  • 3,820
2 votes

How to show address fields in register

Step:1 At First From magento admin developer mode on & find the registration from path as like /app/design/frontend/base/default/template/customer/form/register.phtml Step:2 Find <?php ...
matinict's user avatar
  • 1,559
2 votes

How to use Magento 1.9.1.0 Configurable Swatches in Default package theme (or a custom theme)?

your solution is great but not show color swatch in category list or grid. Here I add the solution to show it, tested on magento 1.9.2.4. In : app/design/frontend/CUSTOM-THEME/template/catalog/...
Joso's user avatar
  • 317
2 votes

Error: Mage registry key "_singleton/rkt_jscssforsb/observer" already exists

Check if your event observer xml code in your module's config.xml is all correct. It should be something like this: <events> <event_name_that_you_are_working_on> <...
Mukesh Chapagain's user avatar
2 votes

How to change order increment prefix?

I really try and avoid direct queries into a magento db. If possible, create a simple module that has an install or upgrade script which will do this for you. For example, you can use the below script ...
MagentJo's user avatar
  • 121
2 votes

Thumbnail Image option is not showing in categories admin panel

In Magento 1.9.X version they disable module for category Thumbnail. The thumbnail attribute is active by Mage_XmlConnect module. So you just need to enable Mage_XmlConnect module to fix the issue. ...
Roshni's user avatar
  • 131
2 votes

Add custom field in onepage check out,order,invoice,sales

You can add this field everywhere it's needed (as you mentioned checkout, order page, sales page,...) etc. within one module. A module named Vendor_MobileNumber or even better Vendor_CustomFields (or ...
Anna Völkl's user avatar
  • 17.3k
2 votes

How can I add a field in admin panel > system > configuration > General Tab?

A module can be created using following files: app/etc/modules/Vendor_Module.xml <?xml version="1.0"?> <config> <modules> <Vendor_Module> <active&...
Raphael at Digital Pianism's user avatar
2 votes
Accepted

Bundle Products not adding to the cart in magento1.9.1.0

I solved this error finally. I just enabled the error_display and got this error: Fatal error: Call to a member function getPosition() on a non-object in htdocs/app/code/core/Mage/Bundle/Model/...
Sheetal's user avatar
  • 61
2 votes

How to make the check-out steps land at the top of the screen as oppose to closer to the bottom where people have to use the scroll bar to scroll up

Use load instead of ready. You need to add jquery in "/public_html/app/design/frontend/PACKAGE/THEME/template/checkout/onepage.phtml" file. You can get your current onpage.phtml file path by enable ...
Chirag Rajput's user avatar
2 votes
Accepted

How to suspend one store until January 8th with least SEO damage?

You could disable the checkout, that's not really messing with your content, but it's been my experience, people will still order as long as you let them know orders will not be processed until a ...
dawhoo's user avatar
  • 851
2 votes

Issue applying SUPEE-10752 (no errors)

I had the same issue. I used this link to resolved AccountController hunk : https://magentary.com/kb/install-supee-10752-without-ssh/
th0r1eif's user avatar
  • 154
1 vote

Base tables already exist

Try commenting all the code lines in: /var/www/html/magento/fresh/magento1.7/app/code/core/Mage/Index/sql/index_setup/install-1.6.0.0.php You poroblably already run it and it is trying to create ...
Phoenix128_RiccardoT's user avatar
1 vote

Remove specific criteria from Varien_Db_Select join

If you get the error You cannot define a correlation name 'xxx' more than once you have to unset($fromAndJoins[$key]); item, where the key was in my case $key = $attribute->getAttributeCode()....
Nob's user avatar
  • 11

Only top scored, non community-wiki answers of a minimum length are eligible