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.
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.
The MySQL error “28 from storage engine” basically means “not enough disk space”.
Short and sweet.
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
- highlight the cells you want to quote-up
- right-click on them and choose “format cells”
- choose custom from the “Category” list (under the number tab)
- in the “Type” box type the following: \”@\”
- 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.
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.
When your Magento installation has multiple sites set up within it, you will probably want to change which site shows based on domain or subdomain URL. You can do this via .htaccess or your httpd virtual hosts config. Continue reading Set Magento website based on URL
You can add a couple of tags to your page html to instruct Google to not index certain parts of your content or to not use certain bits of your content for the snippets shown in the SERPs.
I was just debugging a Magento problem and thought I would list out all the available methods for the category objects I was working through. Quite handy to have as a reference I thought, so here they are.
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.
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.