Blog: Extra-ordinary

How to download Python

This is very simple to down load. Just go to http://www.python.org/download/ and download as you computer configuration. Then install python in your Computer. I will explain step by step Python Tutorial. Now enjoy Python.  

Continue Reading

Error 404 Not Found in Magento Admin Login Page

This is very simple solution, Please go to your database Run below  SQL. Hope it will be solved. SET FOREIGN_KEY_CHECKS=0; UPDATE `core_store` SET store_id = 0 WHERE code=’admin’; UPDATE `core_store_group` SET group_id = 0 WHERE name=’Default’; UPDATE `core_website` SET website_id = 0 WHERE code=’admin’; UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code=’NOT LOGGED IN’; SET FOREIGN_KEY_CHECKS=1;

Continue Reading

Magento : toggleMenu not defined error

If your version is old that makes this type problem. I have been tried to several way but not solved. Lastly solved this problem. Please follow my instruction. Hope you will enjoy. To solved this problem you have to Edit core file. If you avoid to edit core you can paste in your /app/core/local and then edit. or directly edit …

Continue Reading

Jquery addClass and removeClass

Just see below code $(“.product-info”).click(function(){ if(!$(this).hasClass(“activeBar”)) { $(this).addClass(“activeBar”); } else { $(this).removeClass(“activeBar”); } }); Another example ; $(“.product-info”).click(function(){ $(this).toggleClass(“activeBar”); }); hope it will help you.

Continue Reading

Why the Tier Price don’t show in Magento?

For some reason Tier price don’t show in your product price. Please check below info, hope it will solve. Points are: 1.) Clear cache. 2.)  Make sure  re-indexing is complete. 3.)  Make sure The tire price should less then normal price. 4.)  Check the code of product view page whether the code was removed?

Continue Reading

Calculate Total working hour from daily attendance sheet with mysql

SELECT TIMESTAMPDIFF(HOUR, MIN(CASE WHEN inandout = ‘in’ THEN dateandtime END), MAX(CASE WHEN inandout = ‘exit’ THEN dateandtime END))-1 AS HoursWorked, employeeid, employeename,inandout,department,  DATE(dateandtime) FROM attendance WHERE employeeid = 575 AND dateandtime BETWEEN ‘2013-08-01’ AND ‘2013-08-23’ GROUP BY employeeid, DATE(dateandtime)   Create table with below code CREATE TABLE `attendance` ( `attid` double DEFAULT NULL, `employeeid` double DEFAULT NULL, `employeename` varchar(300) DEFAULT NULL, `dateandtime` datetime DEFAULT NULL, `doorsname` varchar(300) DEFAULT NULL, `inandout` varchar(300) DEFAULT NULL, `department` varchar(300) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1

Continue Reading