Maksold

AUTO_INCREMENT grows on every INSERT ... ON DUPLICATE on InnoDB tables #28387

magento/magento2#28387

Symptom:

General system exception happened. SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'value_id' at row 1, query was: INSERT INTO catalog_product_entity_varchar (entity_id,attribute_id,store_id,value) VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (

Maksold

diff --git a/ext/intl/breakiterator/codepointiterator_internal.cpp b/ext/intl/breakiterator/codepointiterator_internal.cpp
index 723cfd5022..f6f75d2731 100644
--- a/ext/intl/breakiterator/codepointiterator_internal.cpp
+++ b/ext/intl/breakiterator/codepointiterator_internal.cpp
@@ -74,7 +74,11 @@ CodePointBreakIterator::~CodePointBreakIterator()
 	clearCurrentCharIter();
 }
 
+#if U_ICU_VERSION_MAJOR_NUM >= 70
+bool CodePointBreakIterator::operator==(const BreakIterator& that) const

Maksold

diff --git a/ext/intl/breakiterator/codepointiterator_internal.cpp b/ext/intl/breakiterator/codepointiterator_internal.cpp
index 723cfd5022..f6f75d2731 100644
--- a/ext/intl/breakiterator/codepointiterator_internal.cpp
+++ b/ext/intl/breakiterator/codepointiterator_internal.cpp
@@ -74,7 +74,11 @@ CodePointBreakIterator::~CodePointBreakIterator()
 	clearCurrentCharIter();
 }
 
+#if U_ICU_VERSION_MAJOR_NUM >= 70
+bool CodePointBreakIterator::operator==(const BreakIterator& that) const

Maksold

--- /ext/intl/breakiterator/codepointiterator_internal.cpp
+++ /ext/intl/breakiterator/codepointiterator_internal.cpp
@@ -67,21 +67,25 @@
 }

 CodePointBreakIterator::~CodePointBreakIterator()
 {
 	if (this->fText) {
 		utext_close(this->fText);
 	}

Maksold

--- ext/intl/breakiterator/codepointiterator_internal.cpp
+++ ext/intl/breakiterator/codepointiterator_internal.cpp
@@ -67,21 +67,25 @@
 }

 CodePointBreakIterator::~CodePointBreakIterator()
 {
 	if (this->fText) {
 		utext_close(this->fText);
 	}

Maksold

SELECT sub_query.month_ordered,
       sub_query.year_ordered,
       AVG(sub_query.base_subtotal) AS average_base_subtotal,
       AVG(sub_query.discount_amount) AS average_discount_amt,
       AVG(sub_query.order_qty) AS average_total_item_count,
       COUNT(sub_query.entity_id) AS total_orders
FROM
  (SELECT so.entity_id,
          MONTH(so.created_at) AS month_ordered,
          YEAR(so.created_at) AS year_ordered,

Maksold

# This is an annotated subset of the Nginx configuration from our Magento production platform @ www.hypernode.com
# See https://www.byte.nl/blog/magento-cacheleak-issue 

# !!!! If you are a Hypernode customer, do not use this config as it will result in duplicate statements. !!!!!

user app;
worker_processes 4;
pid /var/run/nginx.pid;

events {

Maksold

<?php
/** @var $installer Scandi_Migrations_Model_Resource_Setup */
$installer = $this;
$installer->startSetup();

$templates = array(
    array(
        "name" => "New Invoice",
        "code" => "sales_email_invoice_template",
        "config" => "sales_email/invoice/template",

Maksold

<?php
/**
 * Additional Methods for Mage Core Navigation
 *
 * @category    Scandi
 * @package     Scandi_Extends
 */
class Scandi_Extends_Block_Catalog_Navigation extends Mage_Catalog_Block_Navigation
{
    private function getCategoryByPositionOffset($offset)

Maksold

<?xml version="1.0"?>
<layout>
    <default>
        <!--Root/Default Layouts-->
        <reference name="root">
            <!--Appending Block-->
            <block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/>
        </reference>
 
        <!--CSS and JS Files-->