Saturday, December 26, 2015

Delete mysql user and revoke all privileges properly in mysql

If you want to remove all the privileges and start totally from scratch do the following:

    Revoke all privileges on database level:

    REVOKE ALL PRIVILEGES ON dbname.* FROM 'username'@'hostname';

    Drop the user:

    DROP USER 'username'@'hostname';

Above procedure will entirely remove mysql user from your instance, this means you can recreate him from scratch.

Wednesday, December 16, 2015

Attribute options are not deleting in magento

It may happen due to lesser php value of max_input_variable.

To fix this problem open .htaccess file of magento's document root and write this in it:

php_value max_input_vars 2500
You can also do the same by adding/changing max_input_vars value from active php.ini of your server.
max_input_vars = 2500

Thursday, September 10, 2015

Add link to category page by id from cms static block/cms page in Magento

If you want to add a link for category page from cms page or cms static block, simply use the category link widget inline link code:

{{widget type="catalog/category_widget_link" anchor_text="Displayed Text" title="Title attribute text" template="catalog/category/widget/link/link_block.phtml" id_path="category/22"}}

There is no need to add <a> tag from cms pages or static blocks.