Month: November 2012

Install PHP mcrypt on UNIX server

In this quick tip I’ll show you how to install the PHP extensionmcrypt. This is needed for Magento to run properly otherwise you’ll get an error like: [cc type=”text” escaped=”true”]Fatal error: Call to undefined function mcrypt_create_iv() in lib/Varien/Crypt/Mcrypt.php on line 64[/cc]

Tagged with: ,

SQL: Remove HTML with procidure

I had a problem with client’s data that was saved as HTML in the database and I needed it in plain format. Many would say this is very inefficient way of doing it but sometimes desperate time call for desperate

Tagged with: , ,

How to Move Magento to a New Server or Domain

Magento is one of the fastest growing eCommerce platforms on the internet and with its recent acquisition by eBay it promises to stay on the lead and keep growing with even faster pace than before.  It’s been choice for a

Tagged with: , ,

Magento: How to reset admin pssword

If you forget your admin password for Magento and you can’t remember the email or just want quick fix you can use one line of SQL to sort that issue out. [cc lang=”sql”]UPDATE admin_user SET password=CONCAT(MD5(‘qXpassword’), ‘:qX’) WHERE username=’admin’;[/cc] All

Tagged with: , ,

Serve main domain from subdirectory with .htaccess

If you are running your site on a shared hosting and you have multiple domain installed as subdirectories the things could go out of hand really fast. In my specific case I have multiple installs of different CMS and one

Tagged with: , ,

How to read STDIN with PHP script from terminal

In console environment PHP could be very useful especially running long tasks or for CRON jobs. You can execute your script like: [cc lang=”text”]php scriptName.php[/cc] You can also pass some parameters like: [cc lang=”text”]php scriptName.php param1 param2[/cc] Those can be

Migrate Prestashop to another server

If you need to migrate a PrestaShop website from a local to a remote installation or just change the domain name, you need to follow these steps: 0. For security reasons, make a backup of all files and database 1.

Tagged with: , ,