http://dltr.org Magento code snippets and misc codings IT/Internet/Web development en-au Damodar Bashyal is at enjoygame at hotmail dot com Copyright 2026 http://dltr.org/blog/server/599/How-to-upgrade-NodeJS-using-NPM http://dltr.org/blog/server/599/How-to-upgrade-NodeJS-using-NPM Check current installed nodejs version.
[root@dltr.org]# node -v
Force clean cache.
[root@dltr.org]# npm cache clean -f ]]> server Fri, 08 Sep 2017 12:38:43 +0000 http://dltr.org/blog/server/597/Generate-new-SSL-certificate-using-SAN-for-localhost http://dltr.org/blog/server/597/Generate-new-SSL-certificate-using-SAN-for-localhost
NOTE: I am logged in as root, so I haven't used SUDO. ]]> server Wed, 19 Jul 2017 13:06:55 +0000 http://dltr.org/blog/server/596/Linux-remove-IP-from-fail2ban-f2b http://dltr.org/blog/server/596/Linux-remove-IP-from-fail2ban-f2b server Wed, 01 Feb 2017 12:41:41 +0000 http://dltr.org/blog/magento/595/Magento-go-live-checklist http://dltr.org/blog/magento/595/Magento-go-live-checklist Here are few things that I have came across so far. Suggest me below in the comment section if I missed any critical step. ]]> magento Tue, 10 Jan 2017 10:51:40 +0000 http://dltr.org/blog/magento/594/How-to-override-Magento-Observers http://dltr.org/blog/magento/594/How-to-override-Magento-Observers Today's task was to show/hide M2ePro's 'Show eBay Order' button based on permission. Earlier I had done the similar task for 'Create RMA' button which was quite straight forward. But that rewrite didn't work this time as it was an Observer.
This is how I was able to hide 'RMA' tab and 'Create RMA' button from Magento order view page. ]]> magento Thu, 24 Nov 2016 13:02:47 +0000 http://dltr.org/blog/error/587/PHP-undefined-function-mssql_connect-and-sqlsrv_connect http://dltr.org/blog/error/587/PHP-undefined-function-mssql_connect-and-sqlsrv_connect
ERROR: exception 'Exception' with message 'connection to mssql is not supported. Please download and follow directions from here - https://www.microsoft.com/en-us/download/details.aspx?id=20098' in C:\_projects\technooze\app\code\local\Technooze\Schoolbrochure\Model\Mssql.php:182

For sqlsrv_connect to work download (Microsoft Drivers for PHP for SQL Server) from https://www.microsoft.com/en-us/download/details.aspx?id=20098 ]]> error Wed, 06 Apr 2016 06:39:31 +0000 http://dltr.org/blog/magento/586/Magento-Missing-argument-1-for-Mage_Core_Block_Template-setTemplate http://dltr.org/blog/magento/586/Magento-Missing-argument-1-for-Mage_Core_Block_Template-setTemplate Open file app/code/core/Mage/Core/Block/Template.php and go to function setTemplate() (line 111 as shown in error log) and add these lines: ]]> magento Mon, 04 Apr 2016 01:01:44 +0000 http://dltr.org/blog/error/585/How-to-fix-node-gyp-rebuild-errors-on-windows http://dltr.org/blog/error/585/How-to-fix-node-gyp-rebuild-errors-on-windows I would like to share what worked for me at the end. ]]> error Wed, 30 Mar 2016 02:08:34 +0000 http://dltr.org/blog/tips/584/PHPStorm-increase-responsiveness http://dltr.org/blog/tips/584/PHPStorm-increase-responsiveness tips Fri, 18 Mar 2016 06:10:51 +0000 http://dltr.org/blog/magento/583/magento-2-setup-on-existing-vagrant-environment-using-browser http://dltr.org/blog/magento/583/magento-2-setup-on-existing-vagrant-environment-using-browser
Step 2: Open your local /etc/hosts file and point www.mageee2.com.au to your environment IP as: ]]> magento Wed, 23 Dec 2015 03:54:21 +0000 http://dltr.org/blog/server/582/Resume-broken-large-scp-transfer http://dltr.org/blog/server/582/Resume-broken-large-scp-transfer server Mon, 07 Sep 2015 05:55:56 +0000 http://dltr.org/blog/server/581/Linux-commands-to-empty-all-files-of-a-directory http://dltr.org/blog/server/581/Linux-commands-to-empty-all-files-of-a-directory server Tue, 25 Aug 2015 02:04:34 +0000 http://dltr.org/blog/magento/580/How-to-apply-Magento-patches http://dltr.org/blog/magento/580/How-to-apply-Magento-patches This is how I apply patch locally: ]]> magento Mon, 13 Jul 2015 05:39:43 +0000 http://dltr.org/blog/server/579/Synchronizing-system-clock-to-Network-Time-Protocol-NTP-issue http://dltr.org/blog/server/579/Synchronizing-system-clock-to-Network-Time-Protocol-NTP-issue server Thu, 04 Jun 2015 09:15:42 +0000 http://dltr.org/blog/ssh/578/How-to-permanently-save-a-password-protected-ssh-key-on-your-machine http://dltr.org/blog/ssh/578/How-to-permanently-save-a-password-protected-ssh-key-on-your-machine
ssh-agent bash
It will ask you to enter your password once, then won't ask again.
Now add your ssh keys like this: ]]> ssh Mon, 04 May 2015 01:33:49 +0000 http://dltr.org/blog/magento/577/Magento-read-CSV-using-Varien_File_Csv-library http://dltr.org/blog/magento/577/Magento-read-CSV-using-Varien_File_Csv-library $file = 'csv_file_to_parse_into_php_array.csv'; // full path to your csv file. ]]> magento Mon, 20 Apr 2015 05:51:04 +0000 http://dltr.org/blog/server/576/How-to-increase-virtualbox-hard-disk-partition-size http://dltr.org/blog/server/576/How-to-increase-virtualbox-hard-disk-partition-size server Mon, 16 Mar 2015 04:00:07 +0000 http://dltr.org/blog/magento/575/Imacros-to-automate-magento-checkout-using-paypal-express http://dltr.org/blog/magento/575/Imacros-to-automate-magento-checkout-using-paypal-express magento Thu, 08 Jan 2015 05:16:26 +0000 http://dltr.org/blog/magento/574/Magento-re-index-via-command-line http://dltr.org/blog/magento/574/Magento-re-index-via-command-line To over come this issue, you can use your command line to run reindex on required indexes.
I use PuTTY to connect to server and then go to your magento install and then to shell folder. e.g.
~/public_html/shell
Here you can check status of current indexes with this command: ]]> magento Mon, 29 Dec 2014 22:56:51 +0000 http://dltr.org/blog/server/573/How-to-install-SSL-on-windows-localhost-wamp http://dltr.org/blog/server/573/How-to-install-SSL-on-windows-localhost-wamp First of all download and install OpenSSL binary from http://slproweb.com/products/Win32OpenSSL.html, I installed http://slproweb.com/download/Win64OpenSSL_Light-0_9_8zb.exe.
Using command line generate private key which is 2048bits encryption. ]]> server Tue, 14 Oct 2014 01:39:52 +0000 http://dltr.org/blog/magento/572/Magento-find-number-of-times-a-coupon-has-been-used http://dltr.org/blog/magento/572/Magento-find-number-of-times-a-coupon-has-been-used mysql> select u.coupon_id, c.code, count(*) as total from salesrule_coupon_usage u, salesrule_coupon c where u.coupon_id=c.coupon_id and u.coupon_id IN (119, 132, 91) group by u.coupon_id;
May be I was wrong to use that query to find usage :), so tried another query, which gave me better report. ]]> magento Mon, 13 Oct 2014 00:21:29 +0000 http://dltr.org/blog/magento/570/How-to-get-secure-url-in-Magento http://dltr.org/blog/magento/570/How-to-get-secure-url-in-Magento Now we will show you how to get secure urls in magento. So in previous post we got base url as: ]]> magento Fri, 05 Sep 2014 03:30:13 +0000 http://dltr.org/blog/magento/567/Magento-add-your-own-CMS-Directive-to-include-your-custom-template-tag http://dltr.org/blog/magento/567/Magento-add-your-own-CMS-Directive-to-include-your-custom-template-tag I have already added this functionality and example on my github repository here https://github.com/dbashyal/Magento-General-Module-Extension. This module consists of other functionalities, so check code and strip out that you don't need it. ]]> magento Tue, 15 Jul 2014 09:09:07 +0000 http://dltr.org/blog/htaccess/566/Multiple-RewriteCond-.htaccess-Query-String-Redirects http://dltr.org/blog/htaccess/566/Multiple-RewriteCond-.htaccess-Query-String-Redirects This is how I redirected simple pages: ]]> htaccess Thu, 29 May 2014 09:04:12 +0000 http://dltr.org/blog/magento/565/How-to-pull-new-product-image-in-magento-for-hover-image-in-product-list-page http://dltr.org/blog/magento/565/How-to-pull-new-product-image-in-magento-for-hover-image-in-product-list-page Set Attribute Properties as below: ]]> magento Wed, 28 May 2014 04:19:27 +0000 http://dltr.org/blog/git/564/Git-Delete-Remove-Last-Commit-From-Local-and-Remote http://dltr.org/blog/git/564/Git-Delete-Remove-Last-Commit-From-Local-and-Remote git Fri, 23 May 2014 05:20:26 +0000 http://dltr.org/blog/magento/563/Magento-301-redirect-404-page-to-existing-pages http://dltr.org/blog/magento/563/Magento-301-redirect-404-page-to-existing-pages magento Tue, 20 May 2014 03:57:27 +0000 http://dltr.org/blog/magento/562/Magento-fix-catalog-price-rules-promotion http://dltr.org/blog/magento/562/Magento-fix-catalog-price-rules-promotion magento Tue, 06 May 2014 03:46:43 +0000 http://dltr.org/blog/mysql/561/Save-output-MySQL-query-results-into-a-text-file http://dltr.org/blog/mysql/561/Save-output-MySQL-query-results-into-a-text-file mysql Tue, 15 Apr 2014 07:54:00 +0000 http://dltr.org/blog/magento/557/Magento-robots.txt-file-content http://dltr.org/blog/magento/557/Magento-robots.txt-file-content Magento admin / System / configuration / General / Web / Auto-redirect to Base URL / Yes (301 Moved Permanently)
Also, add robots.txt file with below content. ]]> magento Fri, 31 Jan 2014 05:52:13 +0000 http://dltr.org/blog/magento/556/Magento-product-images-duplicate-issue-with-CSV-product-importer http://dltr.org/blog/magento/556/Magento-product-images-duplicate-issue-with-CSV-product-importer So below is a quick workaround to fix this issue. Here we are just deleting previous images if we are going to re-import them again. ]]> magento Tue, 28 Jan 2014 05:05:54 +0000 http://dltr.org/blog/magento/553/Magento-upgrade-steps-issues-and-solutions http://dltr.org/blog/magento/553/Magento-upgrade-steps-issues-and-solutions
======================================= Restrict access to /index.php with IP Address whitelist.
This is what I have:
if (file_exists($maintenanceFile)) {
// START IP BLOCKER
// Remove file 'maintenance.flag' when you decide to go live
$ip_whitelist = array('x.x.x.x', '127.0.0.1', 'x.x.x.x');
if(!in_array($_SERVER['REMOTE_ADDR'], $ip_whitelist)) {
$protocol = "HTTP/1.0";
if ( "HTTP/1.1" == $_SERVER["SERVER_PROTOCOL"] )
$protocol = "HTTP/1.1";
header( "$protocol 503 Service Unavailable", true, 503 );
header( "Retry-After: 3600" );
header('Location: /index_landingpage.php'); // our own custom landing page.
exit;
}
// END IP BLOCKER
include_once dirname(__FILE__) . '/errors/503.php';
exit;
} ]]> magento Fri, 24 Jan 2014 02:07:53 +0000 http://dltr.org/blog/magento/549/Magento-Print-Customers-Group-Name-on-the-transactional-emails http://dltr.org/blog/magento/549/Magento-Print-Customers-Group-Name-on-the-transactional-emails magento Mon, 13 Jan 2014 23:34:58 +0000 http://dltr.org/blog/magento/548/Magento-rewriting-block-helper-and-models-plus-override-issues http://dltr.org/blog/magento/548/Magento-rewriting-block-helper-and-models-plus-override-issues magento Mon, 06 Jan 2014 03:08:18 +0000 http://dltr.org/blog/magento/516/Magento-fix-database-table-engines http://dltr.org/blog/magento/516/Magento-fix-database-table-engines ALTER TABLE `catalog_category_flat_store_1` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_2` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_3` ENGINE=InnoDB;
ALTER TABLE `catalog_category_flat_store_4` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_1` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_2` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_3` ENGINE=InnoDB;
ALTER TABLE `catalog_product_flat_4` ENGINE=InnoDB;
/*below table exists in enterprise version. tested on 1.12.0.2*/ ]]> magento Mon, 23 Sep 2013 12:45:48 +0000 http://dltr.org/blog/magento/513/Magento-Reindex-Issue-Error-on-Product-Flat-Data http://dltr.org/blog/magento/513/Magento-Reindex-Issue-Error-on-Product-Flat-Data There was a problem with reindexing process.SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ('database'.'#sql-70c_45b87', CONSTRAINT 'FK_CAT_PRD_FLAT_2_ENTT_ID_CAT_PRD_ENTT_ENTT_ID' FOREIGN KEY ('entity_id') REFERENCES 'catalog_product_entity' ('entity_id') ON DELETE CASCADE ON UPDAT) ]]> magento Tue, 17 Sep 2013 03:25:15 +0000 http://dltr.org/blog/javascript/509/jQuery-get-browser-width-including-scrollBar http://dltr.org/blog/javascript/509/jQuery-get-browser-width-including-scrollBar if($(document).height() > $(window).height()){... srcollbar is on ...}
Now lets create a function to find the width of the scrollbar: ]]> javascript Fri, 06 Sep 2013 02:21:00 +0000 http://dltr.org/blog/magento/508/Magento-Set-Order-Status-To-Complete http://dltr.org/blog/magento/508/Magento-Set-Order-Status-To-Complete magento Tue, 03 Sep 2013 09:08:51 +0000 http://dltr.org/blog/magento/495/Magento-force-sending-emails-after-order-successful http://dltr.org/blog/magento/495/Magento-force-sending-emails-after-order-successful magento Wed, 07 Aug 2013 01:56:10 +0000 http://dltr.org/blog/magento/494/Magento-Automatically-select-shipping-method-based-on-customer-group http://dltr.org/blog/magento/494/Magento-Automatically-select-shipping-method-based-on-customer-group magento Tue, 06 Aug 2013 06:18:18 +0000 http://dltr.org/blog/magento/486/Magento-automatically-assign-product-to-parent-categories http://dltr.org/blog/magento/486/Magento-automatically-assign-product-to-parent-categories magento Mon, 22 Jul 2013 07:08:44 +0000 http://dltr.org/blog/magento/482/Magento-attributes-get-admin-label-for-attribute-options http://dltr.org/blog/magento/482/Magento-attributes-get-admin-label-for-attribute-options magento Tue, 16 Jul 2013 02:12:41 +0000 http://dltr.org/blog/magento/472/Magento-get-current-store-information http://dltr.org/blog/magento/472/Magento-get-current-store-information Load store object with below code. This will load current store by default unless you pass store id.
$store = Mage::app()->getStore(); // see below for magento core function ]]> magento Mon, 08 Jul 2013 02:38:59 +0000 http://dltr.org/blog/magento/457/Magento-admin-redirects-to-dashboard-when-submitting-form-solved http://dltr.org/blog/magento/457/Magento-admin-redirects-to-dashboard-when-submitting-form-solved magento Mon, 24 Jun 2013 05:35:01 +0000 http://dltr.org/blog/magento/439/Integrate-mailchimp-with-magento-using-mageMonkey http://dltr.org/blog/magento/439/Integrate-mailchimp-with-magento-using-mageMonkey magento mailchimp Tue, 28 May 2013 08:40:19 +0000 http://dltr.org/blog/htaccess/436/Redirect-old-website-domain-to-new-domain-using-htaccess http://dltr.org/blog/htaccess/436/Redirect-old-website-domain-to-new-domain-using-htaccess htaccess Mon, 27 May 2013 03:49:14 +0000 http://dltr.org/blog/magento/420/Magento-get-current-url-of-a-page http://dltr.org/blog/magento/420/Magento-get-current-url-of-a-page To get current url in magento you just need one line of code as below:
ref: public function getCurrentUrl()
$magentoCurrentUrl = Mage::helper('core/url')->getCurrentUrl();
You can also get current url as base64 encoded url as: ]]> magento Mon, 13 May 2013 07:19:55 +0000 http://dltr.org/blog/magento/419/Magento-Redirect-Functions http://dltr.org/blog/magento/419/Magento-Redirect-Functions From any of your Magento controller you can redirect user to any url as defined below. If you want to use redirect function in your magento observer model check this Technooze_T404 extension which I created to handle 404 issue in multi-store magento installation as defined here - stackoverflow question. ]]> magento Mon, 13 May 2013 06:30:03 +0000 http://dltr.org/blog/magento/418/Magento-get-url-with-or-without-parameters http://dltr.org/blog/magento/418/Magento-get-url-with-or-without-parameters // get base url
Mage::getUrl()
// {{parse-tag url='/'}} ]]> magento Mon, 13 May 2013 02:52:35 +0000 http://dltr.org/blog/magento/411/Magento-Programmatically-create-a-cms-page http://dltr.org/blog/magento/411/Magento-Programmatically-create-a-cms-page My file path: /magento/cms-page.php ]]> magento Fri, 10 May 2013 07:28:57 +0000