Invalid Form Key. Please refresh the page / Magento admin login

If you have this issue, the method below solve it be sure =)

I had the same problem and could fix it by setting the correct web/cookie/cookie_domain and web/cookie/cookie_path values in the table core_config_data.

Don't forget to clear all session and cookie data in your browser and the Magento session and cache files/data afterwards.

Good luck! 

Reset / Delete magento category / products by SQL for magento 1

Use query below. Works like a charm! =)

TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;
TRUNCATE TABLE `catalog_product_entity_tier_price`;
TRUNCATE TABLE `catalog_product_entity_varchar`;
TRUNCATE TABLE `catalog_product_link`;
TRUNCATE TABLE `catalog_product_link_attribute`;
TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `catalog_product_link_attribute_int`;
TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `catalog_product_link_type`;
TRUNCATE TABLE `catalog_product_option`;
TRUNCATE TABLE `catalog_product_option_price`;
TRUNCATE TABLE `catalog_product_option_title`;
TRUNCATE TABLE `catalog_product_option_type_price`;
TRUNCATE TABLE `catalog_product_option_type_title`;
TRUNCATE TABLE `catalog_product_option_type_value`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_attribute_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_product_entity`;
TRUNCATE TABLE `cataloginventory_stock`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;
INSERT INTO `catalog_category_entity` (`entity_id`, `entity_type_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES (1, 3, 0, 0, '2012-06-17 22:20:47', '2012-06-17 22:20:47', '1', 0, 0, 1), (2, 3, 3, 1, '2012-06-17 22:20:47', '2012-06-17 22:20:47', '1/2', 1, 1, 0);
INSERT INTO `catalog_category_entity_int` (`value_id`, `entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1, 3, 67, 0, 1, 1), (2, 3, 67, 1, 1, 1), (3, 3, 42, 0, 2, 1), (4, 3, 67, 0, 2, 1), (5, 3, 42, 1, 2, 1), (6, 3, 67, 1, 2, 1);
INSERT INTO `catalog_category_entity_varchar` (`value_id`, `entity_type_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1, 3, 41, 0, 1, 'Root Catalog'), (2, 3, 41, 1, 1, 'Root Catalog'), (3, 3, 43, 1, 1, 'root-catalog'), (4, 3, 41, 0, 2, 'Default Category'), (5, 3, 41, 1, 2, 'Default Category'), (6, 3, 49, 1, 2, 'PRODUCTS'), (7, 3, 43, 1, 2, 'default-category');
INSERT INTO `catalog_product_link_type` (`link_type_id`, `code`) VALUES (1, 'relation'), (3, 'super'), (4, 'up_sell'), (5, 'cross_sell');
INSERT INTO `catalog_product_link_attribute` (`product_link_attribute_id`, `link_type_id`, `product_link_attribute_code`, `data_type`) VALUES (1, 1, 'position', 'int'), (2, 3, 'position', 'int'), (3, 3, 'qty', 'decimal'), (4, 4, 'position', 'int'), (5, 5, 'position', 'int');
INSERT INTO `cataloginventory_stock` (`stock_id`, `stock_name`) VALUES (1, 'Default');


Magento Inline translation doesn't work in chrome brower (SOLVED)

Open Inline.php file from this path /app/code/core/Mage/Core/Model/Translate/Inline.php

Now find below code in that file. (In my case line 272)

 <script type="text/javascript">  
   new TranslateInline('translate-inline-trig', '<?php echo $ajaxUrl ?>', '<?php  
     echo Mage::getDesign()->getArea() ?>');  

Add this code after:

 if(Object.__defineGetter__)  
 {  
   var hasTranslateAttribute = function(){  
     return $(this).hasAttribute("translate");  
   };  
   document.observe("dom:loaded", function() {  
     $$('*').each(function(theElement){  
        theElement.__defineGetter__("translate", hasTranslateAttribute);  
     });  
   });  
 }  

Now check it. It should work in Chrome browser now.

 Enjoy :)

jQuery - remove style added with .css() function

jQuery('#your_element').css("background-color", "")

Get navigation menu categories and category path url key

 <ul>  
               <?php  
                 $obj = new Mage_Catalog_Block_Navigation();  
                 $storeCategories = $obj->getStoreCategories();  
                 foreach ($storeCategories as $_category):  
               ?>  
                   <li><a href="<?php echo $this->getUrl(). $_category->getUrl_key(); ?>"><?php echo $_category->getName(); ?></a></li>  
                 <?php endforeach ?>  
             </ul>  

Export Products CSV -> The error "No valid data sent"

There seems to be something wrong with the filters on the export products' form. The simple fix for this, on magento 1.7.0.2:

1. Copy the file app/code/core/Mage/ImportExport/Model/Export.php toapp/code/local/Mage/ImportExport/Model/Export.php.
2. Around line 145, on the export() method, comment out the if, and the else. There is never a filter on the form.
3. Copy the file app/code/core/Mage/ImportExport/controllers/Adminhtml/ExportController.phpto app/code/local/Mage/ImportExport/controllers/Adminhtml/ExportController.
4. Around line 77, on the exportAction() method, comment out the if and the else. Same reason as above

Hope it will help U =)

Magento validation radio checkbox

use class="validate-one-required" and place it on the last radio/checkbox in the group. Make sure there's a parent div wrapping around the group

Adding products to cart using AJAX

JS functions:

    function processNext(urls, i) {
            var next = i + 1;
            //jQuery('processing-text').update('Processing item ' + next);
            if (next < urls.size()) {
                new Ajax.Request(urls[i], {
                  method: 'get',
                  onComplete: function(transport) {
                    processNext(urls, next);
                  }
                });
            } else {
                new Ajax.Request(urls[i], {
                  method: 'get',
                  onComplete: function(transport) {
                      window.location.href = "/checkout/cart/";
                  }
                });
            }
        }

        function addItemsToCart() {
            jQuery('#add-items-to-cart').hide();
            jQuery('#loading').show();
            jQuery('#add-items-to-cart-col').hide();
            jQuery('#loading-col').show();
            var addToCartUrls = [];
            jQuery('input.add').each(function(){
                if(jQuery(this).is(":checked")) {
                    var id = jQuery(this).attr('id').split('_')[1];
                    var urlo = jQuery("input[name='url_"+id+"']").val();
                    var qtylo = jQuery("input[name='qty_"+id+"']").val();
                    if (qtylo < 1) qtylo = 1;
                    addToCartUrls.push(urlo + 'qty/' + qtylo);

                }
            });
  if (addToCartUrls.size() > 0) {
                processNext(addToCartUrls, 0);
            } else {
                jQuery('add-items-to-cart').show();
                jQuery('waiting').hide();
            }
        }

Disable state/province option in the Magento

update core_config_data set `value`=0 where path = 'general/region/display_all'; update core_config_data set `value`='' where path = 'general/region/state_required';

source: http://www.magentotricks.com/disable-stateprovince-option-in-the-magento/

Magento date of birth (dob widget) selectbox 's instead input fields

Magento date of birth (dob widget) selectbox 's instead input fields

Solution:

Paste code below instead exist code in customer/widget/dob.phtml 

 <div class="field">  
 <label for="<?php echo $this->getFieldId('month')?>"<?php if ($this->isRequired()) echo ' class="required"' ?>><?php if ($this->isRequired()) echo '<em>*</em>' ?><?php echo $this->__('Date of Birth') ?></label>  
 <div class=" customer-dob">  
   <select name="nday" id="nday" onchange="getElementById('<?php echo $this->getFieldId('day');?>').value=this.value" style="width:45px !important;">  
   <?php  
   for($i=1;$i<=31;$i++)  
   {  
   echo "<option value='".$i."'>".$i."</option>";  
   }  
   ?>  
   </select>  
   <select name="nmon" id="nmon" onchange="getElementById('<?php echo $this->getFieldId('month');?>').value=this.value" style="width:90px !important;">  
   <?php echo '<option value="01">'.$this->__("Januar").'</option>'.'<option value="02">'.$this->__("Februar").'</option>'.'<option value="03">'.$this->__("März").'</option>'.'<option value="04">'.$this->__("April").'</option>'.'<option value="05">'.$this->__("Mai").'</option>'.'<option value="06">'.$this->__("Juni").'</option>'.'<option value="07">'.$this->__("Juli").'</option>'.'<option value="08">'.$this->__("August").'</option>'.'<option value="09">'.$this->__("September").'</option>'.'<option value="10">'.$this->__("Oktober").'</option>'.'<option value="11">'.$this->__("November").'</option>'.'<option value="12">'.$this->__("Dezember").'</option>'; ?>  
   </select>  
   <select name="nyear" id="nyear" onchange="getElementById('<?php echo $this->getFieldId('year');?>').value=this.value" style="width:65px !important;">  
   <?php  
   for($j=date('Y');$j>=date('Y')-80;$j--)  
   {  
   echo "<option value='".$j."'>".$j."</option>";  
   }  
   ?>  
   </select>  
 <?php  
   $this->setDateInput('d',  
     '<div class="dob-day">  
        <input type="hidden" id="' . $this->getFieldId('day') . '" name="' . $this->getFieldName('day') . '" value="' . $this->getDay() . '" title="' . $this->__('Day') . '" class="input-dobdtext validate-custom" ' . $this->getFieldParams() . ' />  
      </div>'  
   );  
   $this->setDateInput('m',  
     '<div class="dob-month">  
        <input type="hidden" id="' . $this->getFieldId('month') . '" name="' . $this->getFieldName('month') . '" value="' . $this->getMonth() . '" title="' . $this->__('Month') . '" class="input-dobmtext validate-custom" ' . $this->getFieldParams() . ' />  
      </div>'  
   );  
   $this->setDateInput('y',  
     '<div class="dob-year">  
        <input type="hidden" id="' . $this->getFieldId('year') . '" name="' . $this->getFieldName('year') . '" value="' . $this->getYear() . '" title="' . $this->__('Year') . '" class="input-dobytext validate-custom" ' . $this->getFieldParams() . ' />  
      </div>'  
   );  
 ?>  
   <?php echo $this->getSortedDateInputs() ?>  
   <div class="dob-full" style="display:none;">  
     <input type="hidden" id="<?php echo $this->getFieldId('dob')?>" name="<?php echo $this->getFieldName('dob')?>" />  
   </div>  
   <div class="validation-advice" style="display:none;"></div>  
 </div>  
 </div>  
 <script type="text/javascript">  
 //<![CDATA[  
   var customer_dob = new Varien.DOB('.customer-dob', <?php echo $this->isRequired() ? 'true' : 'false' ?>, '<?php echo $this->getDateFormat() ?>');  
 //]]>  
 </script>   

Disable Footer block Caching in Magento

Disable Footer block Caching in Magento

 

Go to the file /app/code/core/Mage/Page/Block/Html/Footer.php file,
Remove or comment out the cache informations of the constructor function :

protected function _construct()
{
     /*$this->addData(array(
            'cache_lifetime'=> false,
            'cache_tags'    => array(Mage_Core_Model_Store::CACHE_TAG, Mage_Cms_Model_Block::CACHE_TAG)
        ));*/
}

Save and refresh your cache. All should be well.

 

 

Admin Fatal Error. No Login Screen

Problem: Admin Fatal Error. No Login Screen 

Fatal error: Call to a member function getUsername() on a non-object in /home/site/public_html/app/design/adminhtml/default/default/template/page/header.phtml on line 33 

Solution: 

check the config file adminhtml/default/default/layout/main.xml add this code to your main.xml :

<adminhtml_dashboard_customersmost>
        <block type="core/text_list" name="root" output="toHtml">
            <block type="adminhtml/dashboard_tab_customers_most" name="adminhtml.dashboard.tab.customers.most"/>
        </block>
    </adminhtml_dashboard_customersmost>

    <adminhtml_dashboard_customersnewest>
        <block type="core/text_list" name="root" output="toHtml">
            <block type="adminhtml/dashboard_tab_customers_newest" name="adminhtml.dashboard.tab.customers.newest"/>
        </block>
    </adminhtml_dashboard_customersnewest>

    <adminhtml_dashboard_productsviewed>
        <block type="core/text_list" name="root" output="toHtml">
            <block type="adminhtml/dashboard_tab_products_viewed" name="adminhtml.dashboard.tab.products.viewed"/>
        </block>
    </adminhtml_dashboard_productsviewed>

    <adminhtml_index_login>
        <block type="core/text_list" name="root" output="toHtml">
            <block type="adminhtml/template" name="content" template="login.phtml">
                <block type="core/text_list" name="form.additional.info" />
            </block>
        </block>
    </adminhtml_index_login>

    <adminhtml_index_forgotpassword>
        <block type="core/text_list" name="root" output="toHtml">
            <block type="adminhtml/template" name="content" template="forgotpassword.phtml">
                <block type="core/text_list" name="form.additional.info" />
            </block>
        </block>
    </adminhtml_index_forgotpassword>

Start

Welcome! I hope this blog helps U =)