erikhansen

[xdebug]
xdebug.profiler_enable_trigger=on
xdebug.remote_autostart=off
xdebug.remote_enable=1
xdebug.remote_host=127.0.0.1
xdebug.remote_port=9000
xdebug.remote_handler=dbgp
xdebug.idekey=ECLIPSE_XDEBUG
xdebug.collect_vars=on
xdebug.collect_params=4

erikhansen

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

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

-- The change log table used for Magento EE partial index functionality
select * from catalog_category_product_index_cl where product_id = '218';

-- The cron job that gets executed on each cron execution - check for errors

erikhansen

<?php
return array (
  'backend' =>
    array (
      'frontName' => 'backend',
    ),
  'crypt' =>
    array (
      'key' => '<KEY>',
    ),

erikhansen

# Setup local directory with braintree example and libraries
git clone git@github.com:braintree/braintree_php_example.git
cd braintree_php_example
composer install

# Create and define configuration options
echo '
BT_ENVIRONMENT=sandbox
BT_MERCHANT_ID=xxxxxxxxxxxx
BT_PUBLIC_KEY=xxxxxxxxxxxx

erikhansen

// /**
//  * Copyright © 2015 Magento. All rights reserved.
//  * See COPYING.txt for license details.
//  */

//
//  Responsive
//  _____________________________________________

//

erikhansen

How to create a global git commit hook by Matt Venables

1 Enable git templates (This tells git to copy everything in ~/.git-templates to your per-project .git/ directory when you run git init):

git config --global init.templatedir '~/.git-templates'

2 Create a directory to hold the global hooks:

mkdir -p ~/.git-templates/hooks

erikhansen

From 3523dd79d949f93e31fc675b190f17baf66f36c3 Mon Sep 17 00:00:00 2001
From: Erik Hansen <erikpallhansen@gmail.com>
Date: Wed, 1 Feb 2017 13:20:02 -0600
Subject: [PATCH] Edit the 'URL key for specified store already exists' message

---
 Model/Storage/AbstractStorage.php | 5 ++++-
 Model/Storage/DbStorage.php       | 5 ++++-
 2 files changed, 8 insertions(+), 2 deletions(-)

erikhansen

Index: Model/SalesRule/Calculator.php
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
--- Model/SalesRule/Calculator.php	(date 1513354238000)
+++ Model/SalesRule/Calculator.php	(date 1513354238000)
@@ -45,6 +45,17 @@
                     break;
 

erikhansen

<?php
return array (
  'backend' =>
    array (
      'frontName' => 'backend',
    ),
  'crypt' =>
    array (
      'key' => '<KEY>',
    ),

erikhansen

SET SESSION group_concat_max_len = 1000000;
SELECT job_code, count(job_code) AS how_many_times_did_job_run_more_than_once, SUM(count) AS total_number_of_times_job_ran, GROUP_CONCAT(executed_at_group) AS executed_at FROM (
    SELECT cron_schedule.*, GROUP_CONCAT(cron_schedule.executed_at) AS executed_at_group, count(job_code) AS count FROM cron_schedule WHERE executed_at IS NOT NULL GROUP BY job_code, executed_at HAVING count(job_code) > 1 ORDER BY executed_at DESC
) AS duplicate_crons
GROUP BY job_code
ORDER BY count(job_code) DESC;