Skip to content

Instantly share code, notes, and snippets.

View shinesoftware's full-sized avatar

Shine Software shinesoftware

View GitHub Profile
@shinesoftware
shinesoftware / it_IT.csv
Last active September 8, 2017 08:09
Emipro - TicketSystem - Italian Translation
My Support Tickets Le Mie Segnalazioni
Create New Ticket Nuova Segnalazione
You have not created any support ticket. Non hai ancora creato alcuna segnalazione.
Department Categoria
Please Select Department Seleziona la Categoria
Please Select Priority Seleziona la Priorità
Please Select Order Id Seleziona il tuo Codice Ordine
Order Id Codice Ordine
Add Attachment Aggiungi Allegato
Submit Ticket Crea Segnalazione
@shinesoftware
shinesoftware / varnish.vcl
Created December 22, 2017 14:19
Varnish configuration file for Magento 2
vcl 4.0;
import std;
# The minimal Varnish version is 4.0
# For SSL offloading, pass the following header in your proxy server or load balancer: 'X-Forwarded-Proto: https'
backend default {
.host = "127.0.0.1";
.port = "8080";
}
<?php
namespace Shinesoftware\Bnl\Cron;
use Shinesoftware\Bnl\Model\Utils;
class CheckPayments
{
/**
@shinesoftware
shinesoftware / fix-serializer.php
Created November 12, 2019 09:50
Magento Migration: Fixing the Magento 2.1 and Magento 2.2 serialization fields.
<?php
$conn = mysqli_connect("HOST", "USER", "PASS", "DBNAME");
var_dump($conn->get_charset());
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;
@shinesoftware
shinesoftware / fix-duplicates-product-entity-varchar.php
Last active August 20, 2021 14:10
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;
}
@shinesoftware
shinesoftware / _Magento2_DeleteTestData.md
Created September 8, 2021 14:13 — forked from leek/_Magento2_DeleteTestData.md
Magento 2 - Delete All Test Data

These set of scripts are for Magento 2. For Magento 1, see this Gist.