Environments Mac 10.10 Parallels Desktop 9 Windows 7 Issue & Solutions When I try to install MS SQL Express 2012, the installer shows an error like “No room is available to display rows”. The reason was screen resolution in Mac retina display. Open Parallels Desktop -> Virtual Machine -> Configure -> Hardware -> Video -> Change…
Year: 2014
Magento Creare SEO overrides default page titles
I had installed Magento Creare SEO extensions (http://www.magentocommerce.com/magento-connect/creare-seo.html) The extension is good and did what I wanted to achieve. However, the extension override the page title to default page title in these pages, such as Login, Signup, Popular Search Terms, Search Results, etc. So it created duplicate page titles. After researching the code, I found…
Sample XAMPP MySql my.ini Fast Performance
Only use in local test MySQL. # Example MySQL config file for large systems. # # This is for a large system with memory = 512M where the system runs mainly # MySQL. # # MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You…
SmartOptimizer with CS-Cart optimization
Reference: http://forum.cs-cart.com/topic/29499-speed-up-and-optimise-cs-cart-version-3/ In store root .htaccess DirectoryIndex index.html index.php <IfModule mod_rewrite.c> RewriteEngine on # Pleas note that RewriteBase setting is obsolete use it only in case you experience some problems with SEO addon. # Some hostings require RewriteBase to be uncommented # Example: # Your store url is http://www.yourcompany.com/store/cart # So “RewriteBase” should be: #…
페이스북 그룹 사진 모두 다운받기
페이스북 그룹안의 사진을 한꺼번에 다운받을 수 있는 툴 http://www.picknzip.com/
Javascript Skill Test
Found this test from the internet (Download: JavaScript_Skill_Test-blank) Tried to solve without using Google. FAILED. With help from Google, solved questions. There was someone’s solution for exact same questions; I resisted a lot to not see his solution. Some questions are referred to understand what question was. If I get this test in the interview without…
Run Internet Explorer in Mac using VirtualBox
Reference: http://osxdaily.com/2011/09/04/internet-explorer-for-mac-ie7-ie8-ie-9-free/ curl -s https://raw.githubusercontent.com/xdissent/ievms/master/ievms.sh | bash Or just download https://raw.githubusercontent.com/xdissent/ievms/master/ievms.sh and execute downloaded shell program.
Mangeto Delete Order Extension
Set a variable in Django template
Summary 1. Create “templatetags” folder at the same level as models.py, views.py. 2. Create “__init__.py” file in “templatetags” folder. The content will be empty. 3. Create “set_var.py” file in “templatetags” folder. And copy and paste below code from django import template register = template.Library() class SetVarNode(template.Node): def __init__(self, var_name, var_value): self.var_name = var_name self.var_value =…
money_format_alt
Alternative code snippet for money_format function money_format_alt($amount, $decimal, $symbol = ‘$’, $symbol_right = ”, $symbol_thousands = ‘,’, $symbol_decimal = ‘.’) { if ($amount < 0) return ‘-‘.$symbol . (number_format(abs($amount), $decimal, $symbol_decimal, $symbol_thousands)) . $symbol_right; return $symbol.number_format($amount, $decimal, $symbol_decimal, $symbol_thousands).$symbol_right; }
Magento – Add Open Graph Tags in Meta
Ah…. Big mistake. Magento has good plugin called Creare SEO (http://www.magentocommerce.com/magento-connect/creare-seo.html). It has Twitter Cards and Open Graph. Install above plugin. —— Discard below contents Open template’s header file and add below after any existing meta tag. Change ‘images/logo.png’ to your logo. Other meta tags will be automatically filled. <meta property=”og:title” content=”<?php echo $this->getTitle() ?>”…
EnvironmentError: mysql_config not found
I am using Mac OS X 10.9, MAMP 1.9 (MySQL 5.1.44), Python 2.7.5. Got this error when I change database configuration in settings.py. I felt this issue can make me painful, so I start logging what happened and how I fixed. Do not follow below steps. Just go straightly bottom of article and read last…
Thunderbird Extensions
Expression Search /GMailUI: https://addons.mozilla.org/en-US/thunderbird/addon/gmailui/
Magento Installation – Fresh Start
1. Install Magento, Theme 2. Set up .htaccess 3. Install SMTP Pro Extension: http://www.magentocommerce.com/magento-connect/aschroder-com-smtp-pro-email-free-and-easy-magento-emailing-for-smtp-gmail-or-google-apps-email.html 4. Install Fontis Australia Extension Extension: http://www.magentocommerce.com/magento-connect/fontis-australia.html 5. Tax Configuration – Go to System -> Sales -> Tax Tax Classes Tax Class for Shipping: Shipping Calculation Settings Tax Calculation Method Based On: Total Tax Calculation Based On: Shipping Address Catalog Prices:…
Slow Android Emulator, install Intel x64 Emulator Accelerator (HAXM)
일단 먼저 읽어봐야할것들 Is your Android emulator just too slow? https://www.infinum.co/the-capsized-eight/articles/is-your-android-emulator-just-too-slow Why is the Android emulator so slow? http://stackoverflow.com/questions/1554099/why-is-the-android-emulator-so-slow 8 Tips to Speed Up Your Android ARM Emulator (AVD) http://delphi.org/2013/11/8-tips-to-speed-up-your-android-arm-emulator-avd/ 안드로이드 에뮬레이터가 느릴 때, Intel x64 Emulator Accelerator (HAXM)를 설치하기 Open Android SDK Manager and install Install “Extras” -> “intel x86 Emulator Accelerator (HAXM)” Execute <sdk>/extras/intel/Hardware_Accelerated_Execution_Manager/IntelHAXM.dmg. in the MAC….
VPS – Apache & MySQL Performance Tuning
Apache 1. Open/Create /var/www/vhosts/{hostname}/conf/vhosts.conf 2. Add oradjust below code KeepAlive On MaxKeepAliveRequests 29 KeepAliveTimeout 15 3. Copy to make backup of apache configuration # cp -p /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.YYYY-MM-DD.bak 4. Execute below shell script one by one # ramCount=`awk ‘match($0,/vmguar/) {print $4}’ /proc/user_beancounters` # ramBase=-16 && for ((;ramCount>1;ramBase++)); do ramCount=$((ramCount/2)); done # perl -0 -p -i…
.htaccess GZIP Compression & Enable Keep-alive
To make faster webpage loading, use Gzip compress and Enable keep-alive in htaccess <ifModule mod_deflate.c> AddOutputFilterByType DEFLATE text/text text/html text/plain text/xml text/css application/x-javascript application/javascript </ifModule> <ifModule mod_headers.c> Header set Connection keep-alive </ifModule> In Plesk Control Panel, follow below steps Access SSH as root user Go to /var/www/vhosts/{domain}/conf Create or Modify vhosts.conf Add following code…
Test website speed in various server location 웹사이트 속도 체크
Test website speed in various server location 웹사이트 속도 체크 http://www.webpagetest.org/
Duplicate Cleaner 중복된 파일/노래 찾기
Recommend to find duplicate file 중복된 파일/노래 찾기 http://www.digitalvolcano.co.uk/duplicatecleaner.html
Revo Uninstaller
Recommended Uninstaller Program in Windows http://www.revouninstaller.com/
Malwarebytes Cameleon
When the computer is infected by Malware and it prevents to execute or install Anti-virus program, use Malwarebytes Cameleon to scan the computer without interrupting by Malware. Download: http://www.malwarebytes.org/chameleon/ How to Use: 1. Download Malwarebytes Chameleon 2. Extract downloaded zip file 3. Execute svchost.exe with Administrator permission. 4. The program will start installing driver, Anti-Malware and run…
Detect when scroll is reached end of scroll
Using jQuery, determine that user has been scrolled until the end of element. Reference: http://stackoverflow.com/questions/6271237/detecting-when-user-scrolls-to-bottom-of-div-with-jquery $(‘.scrollable’).bind(‘scroll’, function(){ if($(this).scrollTop() + $(this).innerHeight() >= $(this)[0].scrollHeight) { alert(‘end reached’); } });
Chrome Adblock Plus 사용법 (부제: 호주바다 광고없애기)
1. Chrome을 연다 2. Adblock Plus 플러그인을 설치한다. https://chrome.google.com/webstore/detail/adblock-plus/cfhdojbkjhnklbpkdaibdccddilifddb 3. 오른쪽 상단 바에 설치된 Adblock Plus 아이콘을 누르고, Options를 선택한다. 4. “Add your own filters” 탭을 클릭하고 다음을 추가한다. 주의: 주소 맨 뒤에 * (별표)를 빼먹지 말자. http://hojubada.com/banner/* 5. 호주바다 사이트로 들어가 확인해본다. 적용후 적용전 참고: Adblock Plus는 사이트에서 광고가 없어진게 아니라, 클라이언트 단에서…