Skip to content

Instantly share code, notes, and snippets.

@fnogatz
fnogatz / fix-duplicates-product-entity-varchar.php
Created May 14, 2020 12:32 — forked from shinesoftware/fix-duplicates-product-entity-varchar.php
Magento 2: Reindex Error - 1062 Duplicate entry `catalog_product_index_eav_temp` (?, ?, ?, ?, ?)...
<?php
$conn = mysqli_connect("HOST", "USER", "PASS", "DATABASE");
if (!$conn) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
var context = (function () {
function fire (str) {
console.log(str)
}
function getFire () {
return fire
}
return {
@fnogatz
fnogatz / testscript_locations.js
Created September 24, 2011 11:33
Script to test three algorithms for SQL-based area search
var mysql = require('mysql'),
assert = require('assert'),
util = require('util'),
sys = require('sys');
var client = mysql.createClient({
user: 'root',
password: null,
database: 'tests'
});
body {
color: #fff;
}