Here’s a quick tutorial on creating foreign keys with MySQL.
Have you discovered how hard it is when testing Magento email? Have you ever tried getting Magento to use a separate SMTP server to send emails? I have, and got very frustrated with it. My solution to testing magento email is to use Mailtrap.io.
Magento 2 comes with built-in functionality to backup and restore the code, media, and database. You can choose to backup and restore code, media, or database separately. Here’s how to backup and restore with Magento 2.
Here’s how to add products and breadcrumb Rich Snippets in Magento.
Here’s how to get and set cookies in Magento.
I’ve recently stumbled across an issue where PHP Imagick can’t open a PDF file despite the file being there and readable. This is using Mac OSX El Capitan with Homebrewed PHP5, Imagemagick, Ghostscript and the PHP55-imagick module. After a bit of searching I found the fix.
Here’s a snippet for using a currency column type with the currency symbol prefix in Magento admin grids.
Like many web professionals, I listen to a lot of podcasts when I have the time. They generally fall into two categories which cover my interests; tech and music, and so I thought I’d list my current podcasts in case anyone else found them interesting.
Today I learned that `FLUSH PRIVILEGES` isn’t needed by Scott Lindsey in the comments. After double checking locally that Scott was correct I looked it up and found a great explanation why MySQL FLUSH PRIVILEGES isn’t needed
I’ve recently been working on a few of our older websites with newer MySQL installations and am coming across the following error:
SQLSTATE[HY000]: General error: 1364 Field ‘delivery_address_id’ doesn’t have a default value
This is caused by MySQL having a strict mode set which won’t allow INSERT or UPDATE commands with empty fields where the schema doesn’t have a default value set.
There are a couple of fixes for this.
Magento Certified Website Developer