Wordpress annotation plugin

http://php-you.blogspot.com/search/label/pdf%20annotation%20wordpress

With the plugin 
Plugin for annotation
Viewer page template for viewing all pages of pdf document with scroll
Manage annotation page for edit the text used for annotation and for deleting the annotation

Magento Tips: 404 Not Found error after Magento module installation

Sometimes after Magento modules installation, you can see 404 page not found error in your Magento administration zone.




To fix this error, try to re-save permission role of your administrator user, using Magento admin zone -> System -> Permissions -> ‘Roles’ page -> Administrators -> Click on ‘Save Role’ button.


Don’t forget to clear Magento cache after this.

Sql query for getting Category id and name from magento database table

SELECT `entity_id`,`value` FROM `catalog_category_entity_varchar` WHERE `attribute_id` = 3 and
`entity_id` IN(SELECT distinct(`entity_id`)  FROM `catalog_category_entity` WHERE `path` LIKE
'%1/xxx%')
For more than one store
Take the root category id  of store from admin and put it in place of 1/xxx as 1/categoryid
Also you have to search in table `catalog_category_entity_varchar'  for attribute_id  by giving the name of you store root category in place of value field.

SELECT  `attribute_id`   FROM `catalog_category_entity_varchar` WHERE `value` = "your category name";