Applying Magento SUPEE Patches on a Windows environment

Ok, for reasons of general simplicity and familiarity I like to develop my php applications in a Windows environment using WAMP.  However, this can be problematic when needing to apply SUPEE patches to development instances of Magento projects.

Continue reading Applying Magento SUPEE Patches on a Windows environment

Facebook Comments

Red Hat / Centos: Web services not starting up on a server reboot

Ok, so your webserver has crashed. You reboot it and…and…nothing. No website.  Your apache / httpd and mysqld services have not restarted along with the server.  Here is how to check if they should and make them do so if they aren’t.

Continue reading Red Hat / Centos: Web services not starting up on a server reboot

Facebook Comments

MS Excel: Adding quotes round text for .csv export

Just a quick one this.  When exporting columns of text for .csv files you will probably want to have the text blocks encased in double quotes.  To do this in excel, before saving as .csv, simply

  1. highlight the cells you want to quote-up
  2. right-click on them and choose “format cells”
  3. choose custom from the “Category” list (under the number tab)
  4. in the “Type” box type the following:   \”@\”
  5. hit ok

The backslash is the escape character used to say “use the symbol that comes next” and the @ can be considered to be the wildcard or placeholder for the current contents.

Saves having to use your code/text editor to add in all the quotes.

Facebook Comments

Magento – Making add to cart urls use https when site is secure

So you have got your site all nicely working with your ssl certificate ready for your site to run fully in https:// to appease Google but your padlock never stays green.  For my setup I traced this down to the various form submission URLs such as “add to cart”. Here is how I finally solved it.

Continue reading Magento – Making add to cart urls use https when site is secure

Facebook Comments

Magento admin on localhost gives ERROR_CONNECTION_RESET message (winamp)

This was a curious and frustrating problem to fix.  After updating the local dev copy of a a magento site, and changing a few local folder permissions the admin area stopped working, giving instead an error message of:  ERROR_CONNECTION_RESET.

Continue reading Magento admin on localhost gives ERROR_CONNECTION_RESET message (winamp)

Facebook Comments

Archive An Entire Web Folder Using Tar Via SSH

Before performing any major operations on a site it is great to have the reassurance that you have a complete back up. ALWAYS do this when taking over a new project and, even though you may have your files in a .git or svn system it can be a real livesaver to just turn time back a few minutes if your major update goes pear shaped. One of my colleagues refers to this as the “get out of jail free card”. You can also use this to take a copy of the entire site when you want to move it – to a development server for example.

Continue reading Archive An Entire Web Folder Using Tar Via SSH

Facebook Comments