MySQL Foreign Key Tutorial
Here’s a quick tutorial on creating foreign keys with MySQL.
Testing Magento Email with Mailtrap.io
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.
How to backup and restore with Magento 2
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.
Product and Breadcrumb Rich Snippets in Magento
Here’s how to add products and breadcrumb Rich Snippets in Magento.
Magento Snippet: How to set and get cookies in Magento
Here’s how to get and set cookies in Magento.
Solved: PHP Imagick ‘unable to open image’ PDF
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.
Magento Snippet: Admin grid currency type with currency symbol
Here’s a snippet for using a currency column type with the currency symbol prefix in Magento admin grids.
My Current Podcasts
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.
TIL: MySQL FLUSH PRIVILEGES isn’t needed
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
MySQL fix: Field ‘xxxx’ doesn’t have a default value
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.
Andrew McCombe
Full Stack Web Developer
Based in Staffordshire, UK
Follow @euperia
Latest Posts
- SagePay Test Credit Card Numbers
- Apache: Use .htaccess to redirect non-www to www
- Apache: Use .htaccess to redirect http to https
- How to import a Google Sitemap into a MySQL table
- Magento Admin Invalid Form Key
- How To Clear Google Chrome’s 301 Redirect Cache
- Google Analytics WordPress Plugin
- How to use htaccess to password protect your website
- Magento: remove admin mass action for specific role
- Magento: Remove specific tabs from product edit in admin
- How to upgrade Magento 2 to a later version
- How to get the URL of a CMS page or a static block in Magento
- How to use a different SSH port with rsync
- HEAD request with PHP
- Magento Snippet: Use a Group By clause on a collection model
- Managing Homebrew Services
- I’m a Magento Certified Developer!
- Fix for PHP Composer “????%” issue
- Introducing Hit The Ground: Laravel Edition
- Magento Custom Variables
