lewisvoncken

diff --git a/app/etc/di.xml b/app/etc/di.xml
index ace043beb62..7751604ea1d 100644
--- a/app/etc/di.xml
+++ b/app/etc/di.xml
@@ -1896,12 +1896,12 @@
     </type>
     <type name="Magento\Framework\Webapi\Validator\EntityArrayValidator">
         <arguments>
-            <argument name="complexArrayItemLimit" xsi:type="number">20</argument>
+            <argument name="complexArrayItemLimit" xsi:type="number">999999</argument>

lewisvoncken

<?php

// use shell_exec("mysql -e '{$sql}'"); for mysql_query or use pdo or something


$catId = 2;

$xml = simplexml_load_file('app/etc/local.xml');
$host = "";
$username = "";

lewisvoncken

<?php

// use shell_exec("mysql -e '{$sql}'"); for mysql_query or use pdo or something

$catId = 2;

$host = "";
$username = "";
$password = "";
$dbname = "";

lewisvoncken

#!/bin/bash
TIME=$(date +%s)
# xp-varnish.vcl is used so it can not be overwritten by the varnish.vcl generated through the admin
varnishadm vcl.load mag2_$TIME /data/web/magento2/var/xp-varnish.vcl
varnishadm vcl.use mag2_$TIME

printf "${YELLOW}NOTICE${NC} - Please ignore the error below.\n";
varnishadm vcl.discard boot

lewisvoncken

sed -i.bak $'s/}/\\\t188.166.64.179 "off"; \# magereport.com\\\n\\\t178.62.230.112 "off"; \# magereport.com\\\n}/g' /data/web/nginx/whitelist-development-exception.conf; hypernode-servicectl reload nginx

lewisvoncken

<?php
/**
 * Copyright © Magento, Inc. All rights reserved.
 * See COPYING.txt for license details.
 */

use Magento\Framework\App\Bootstrap;
use Magento\Framework\DB\Adapter\AdapterInterface;
use Magento\Framework\DB\Query\Generator;
use Magento\Framework\Exception\LocalizedException;

lewisvoncken

SELECT DISTINCT u.url_rewrite_id from store as s 
INNER JOIN store_group as sg
  ON s.group_id = sg.group_id 
INNER JOIN catalog_category_entity as c
  ON sg.root_category_id = SUBSTRING_INDEX(SUBSTRING_INDEX(c.path, '/', 2), '/', -1)
LEFT JOIN url_rewrite as u
  ON c.entity_id = u.entity_id AND s.store_id != u.store_id
WHERE entity_type = 'category'

lewisvoncken

diff --git a/DB/Adapter/Pdo/Mysql.php b/DB/Adapter/Pdo/Mysql.php
index a43f39a..4db98b6 100644
--- a/DB/Adapter/Pdo/Mysql.php
+++ b/DB/Adapter/Pdo/Mysql.php
@@ -2796,7 +2796,7 @@ class Mysql extends \Zend_Db_Adapter_Pdo_Mysql implements AdapterInterface
                 if (isset($condition['to'])) {
                     $query .= empty($query) ? '' : ' AND ';
                     $to     = $this->_prepareSqlDateCondition($condition, 'to');
-                    $query = $this->_prepareQuotedSqlCondition($query . $conditionKeyMap['to'], $to, $fieldName);
+                    $query = $query . $this->_prepareQuotedSqlCondition($conditionKeyMap['to'], $to, $fieldName);

lewisvoncken

From 96be1ce725616f6282636db8630f08f6d068c1e0 Mon Sep 17 00:00:00 2001
From: Lewis Voncken <[email protected]>
Date: Wed, 16 Aug 2017 16:07:17 +0000
Subject: [PATCH] [BUGFIX] Flat Category reindexList of AllChildren if the
 url_key of the current category has changed

---
 vendor/magento/module-catalog/Model/Category.php | 3 +++
 1 file changed, 3 insertions(+)