mttjohnson

In .phtml tempalte file:

<?php echo $block->getLayout()->createBlock('Magento\Cms\Block\Block')->setBlockId('block_identifier')->toHtml();?>

In CMS content:

{{block class="Magento\\Cms\\Block\\Block" block_id="block_identifier"}}

In layout .xml file:

<referenceContainer name="content">
  <block class="Magento\Cms\Block\Block" name="block_identifier">

mttjohnson

#!/bin/bash

# stop on errors
set -e
# turn on debugging
set -x

mysql -e "DROP DATABASE IF EXISTS \`test_import\`; CREATE DATABASE IF NOT EXISTS \`test_import\` DEFAULT CHARACTER SET utf8;"
START_TIME=$(date -u +"%s")

mttjohnson

<IfModule mod_rewrite.c>

    RewriteEngine on

############################################
## Define some initial variables for use in RewriteRules later

    ## Sets an env var on secure page loads for www redirects ##
    RewriteCond %{HTTPS} on [OR]
    RewriteCond %{HTTP:X-Forwarded-Proto} https [NC]

mttjohnson

In order to find this broken symbolic link I ran a command from the shell

find . -type l -exec sh -c "file -b {} | grep -q ^broken" \; -print

http://magento.stackexchange.com/questions/91184/missing-write-permissions-in-directory-pub-static-when-run-bin-magento-setupupg

mttjohnson

Multi word search anywhere in a file:

(text1)[\s\S]*(text2)|\2[\s\S]*\1

Mulit word search on the same line in a file

^.*text1.+?text2

mttjohnson

-- When products are added/removed from a category this table stores all the relation data
select * from catalog_category_product where product_id = '24526';

-- The index that is used for presenting products in a category on the frontend
select * from catalog_category_product_index where product_id = '24526';

-- The change log table used for Magento EE partial index functionality
select * from catalog_category_product_index_cl where product_id = '24526' and version_id > (select version_id from enterprise_mview_metadata where changelog_name = 'catalog_category_product_index_cl');

mttjohnson

Print Dialog

A Pen by Matt Johnson on CodePen.

License.

mttjohnson

sed -i .bak -e "s/openssl.cafile/max_input_vars = 16384\\
openssl.cafile/" /server/vagrant/etc/php.d/00-php.ini
cd /server/
vagrant ssh
sudo sed -i -e "s/openssl.cafile/max_input_vars = 16384\\
openssl.cafile/" /etc/php.d/00-php.ini
sudo apachectl restart

mttjohnson

# clear the entire cache
varnishadm "ban req.url ~ /"

# monitor varnish stats
varnishstat -n prod

# monitor varnish log with multiple patterns
varnishlog | grep 'eqURL\|Age:\|VCL_call\|TTL\|Expires:\|Cache-Control:'

# Use a query with varnishlog to watch requests from a specific IP

mttjohnson

Notes from conversations with David Alger and Zach Nanninga about Magento 1.x cron jobs runnign duplicate processes

running double cron jobs because of this section in cron.php:

if ($isShellDisabled) {
        Mage::dispatchEvent('always');
        Mage::dispatchEvent('default');
    } else {
        Mage::dispatchEvent($cronMode);
    }