After changing folders or moving to development site. You will need to update the pear.ini file.

“ERROR: failed to mkdir”

Admin penal fix:

Rename or Delete the old pear.ini
(magento/downloader/pearlib/pear.ini)

Log in to Admin Panel.
Navigate to Magento Connect Manager and log in.
Go to: System -> Extensions -> PEAR Configuration
set: Preferred State from Stable to Beta – Click Save.
Magneto will generate a new pear.ini file now with the correct path. – Revert back to Stable.

For importing large sql dump files with the command line.

$ cd

$ mysql --username=INSERT --password=INSERT DATABASENAME < sqlfile.sql

In order to change the order of blocks in your sidebar/left column layout you will have to edit the Catalog.xml file.

File Located: app/design/frontend/default/(Your Template)/layout/catalog.xml

In this file locate the left column : (reference name’”left”). Magento also does a good job at commenting out the blocks for you (refer to the comments). It is the “before” and “after” parameters that influence the order in your sidebar.

phpMyAdmin has problems when working with large Mysql database imports. If you are getting the following error try following the steps below to fix it.

Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin

Locate your phpMyAdmin folder and find the file: config.default.php.
I am currently working with XAMPP and the following file can be located: C:\xampp\phpMyAdmin\libraries\config.default.php
Once you have this open in a text editor located this line of code:

$cfg['ExecTimeLimit'] = 300;

and replace it with:

$cfg['ExecTimeLimit'] = 3500;

This will add additional time! Save the file and upload you sql file.

This is a quick “how to” for making a Windows 7 boot disc or recovery disc. This disc will come in handy to anyone who is having issues booting into Windows 7. I have posted some quick snapshots below for visuals.

• First: Head over to your Control Panel
• Next: Under System and Security click “Back up your Computer”.
• Then Click “Create a system repair disc”
• Once the windows pops up insert a blank CD and click Create Disc.

That’s it!

Edit* – If you need to download a Windows 7 Boot Disc you can download one from this site here – http://win7recovery.com/

This is a possible solution to fix the lockout error:

\\SERVER_NAME is not accessible. You might not have permission to use this network resource. Contact the administrator of this server to find out if you have access permissions.

The referenced account is currently locked out and may not be logged on to.

• The first thing you must do is open your windows home server in a remote desktop protocol (RDP): Start > All Programs > Accessories > Remote Desktop Connection. Login to your account as “Administrator” your password should be the same as your WHS.
• Next click the Start Menu and right click on My Computer and select Manager.
• Select Local Users and Groups in the left column. Now double click users in the right column.
• Select the user name you want to unlock and right click to select properties.
• Finally click the Checkbox in the bottom of the windows that read “Account is Locked Out“.



After following the steps you should be able to now connect to your shared folders!

Complete these simple tasks and instantly boost your Dropbox space free!

Dropbox link

• Connect your Twitter account with Dropbox -128MB
• Connect your Facebook account with Dropbox -128MB
• Follow @Dropbox on Twitter -128MB
• Tell us why you love Dropbox -128MB
• Like Dropbox? Tell your friends on Facebook -128MB
• Tweet about Dropbox for more free space! -128MB

Don’t have a Dropbox account? Sign up here!

Thank You YCombinator and Dropbox!

XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. I need to run both XAMPP and IIS (Internet Information Services) together. I use IIS to run 3CX VoIP Software and XAMPP for local development.

The conflict is with Apache and IIS using the same ports (port:80).

You will need to access 2 files and make the following changes to the ports:

Navigate to your XAMPP folder in your C: drive – C:\xampp\apache\conf\httpd.conf

Search for “Listen 80” and change this to “Listen 81”
Search for “localhost:80” and change this to “localhost:81”

Navigate to your XAMPP folder in your C: drive – C:\xampp\apache\conf\extra\httpd-ssl.conf

Search for “Listen 443” and change this to “Listen 4499”
Search for “localhost:80” and change this to “localhost:4499”
Search for “VirtualHost _default_:443” and change this to “VirtualHost _default_:4499”

You have to change both files inorder for this to work correctly. This was used for XAMPP version 1.7.3

Starting Ova!