Skip to content

Instantly share code, notes, and snippets.

View sashas777's full-sized avatar
🌟
Per Aspera Ad Astra!

Alexander Lukyanov sashas777

🌟
Per Aspera Ad Astra!
33 followers · 6 following
View GitHub Profile
@sashas777
sashas777 / shell
Created November 25, 2014 04:31
Magento CE 1.9.1.0 Installation Over ssh
wget http://www.magentocommerce.com/index.php/getmagento/1.9.1.0/magento-1.9.1.0.tar.gz
wget http://www.magentocommerce.com/downloads/assets/1.9.0.0/magento-sample-data-1.9.0.0.tar.gz
tar xvf magento-1.9.1.0.tar.gz
tar xvf magento-sample-data-1.9.0.0.tar.gz
mv magento-sample-data-1.9.0.0/media/* magento/media/
mv magento-sample-data-1.9.0.0/magento_sample_data_for_1.9.0.0.sql magento/data.sql
mv magento/* magento/.htaccess .
mysql -h DBHOST -u DBUSER -pDBPASS DBNAME < data.sql
rm -rf *.sample magento/ magento-sample-data-1.9.0.0/
rm -rf magento-1.9.1.0.tar.gz magento-sample-data-1.9.0.0.tar.gz data.sql\
@sashas777
sashas777 / fix.sql
Last active July 8, 2019 16:14
Magento 2 Admin 404 Not Found Issue
SET FOREIGN_KEY_CHECKS=0;
UPDATE store SET store_id = 0 WHERE code='admin';
UPDATE store_group SET group_id = 0 WHERE name='Default';
UPDATE store_website SET website_id = 0 WHERE code='admin';
UPDATE customer_group SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;
@sashas777
sashas777 / m2
Created July 8, 2019 16:07
M2 Virtual Host
server {
listen 8080;
server_name local.something.com;
set $MAGE_ROOT /usr/share/nginx/html/something;
set $MAGE_RUN_TYPE website;
include /usr/share/nginx/html/something/nginx.conf.sample;
}
@sashas777
sashas777 / m2
Created July 8, 2019 16:07
M2 Virtual Host
server {
listen 8080;
server_name local.something.com;
set $MAGE_ROOT /usr/share/nginx/html/something;
set $MAGE_RUN_TYPE website;
include /usr/share/nginx/html/something/nginx.conf.sample;
}
@sashas777
sashas777 / https
Created July 8, 2019 16:05
/etc/nginx/sashas-config/https
server {
listen 443 ssl http2;
server_name admin.local.xx.com;
ssl on;
ssl_certificate /etc/nginx/ssl/cert.pem;
ssl_certificate_key /etc/nginx/ssl/key.pem;
ssl_session_timeout 24h;
keepalive_timeout 600s;
@sashas777
sashas777 / mapping
Created July 8, 2019 16:02
/etc/nginx/sashas-config/mapping
map $http_host $MAGE_RUN_CODE {
admin.local.x.com admin;
local.a.com websiteA;
local.b.ca websiteB;
default admin;
}
@sashas777
sashas777 / export.sql
Created May 26, 2015 04:12
Export Magento Related, Crosssell, Upsell Products from Database
/* Related Products */
SELECT e.sku as sku, GROUP_CONCAT(ee.sku) as related_product FROM catalog_product_link l
INNER JOIN catalog_product_entity e on e.entity_id=l.product_id
INNER JOIN catalog_product_entity ee on ee.entity_id=l.linked_product_id
WHERE l.link_type_id=1
GROUP BY e.sku
/* Crosssell Products */
SELECT e.sku as sku, GROUP_CONCAT(ee.sku) as crossel_product FROM catalog_product_link l
INNER JOIN catalog_product_entity e on e.entity_id=l.product_id
@sashas777
sashas777 / gist:ee1d771f7c5c9c0d8477bb232a1c54da
Created July 19, 2018 23:51
Magento 2 Cloud Multistore where store set by url /{{store_code}}
Two steps:
1. Setup Multistore at the admin where each store url are the same
2. Create pub/{{store_code}}/index.php
<?php
require realpath(__DIR__) . '/../../app/bootstrap.php';
$params = $_SERVER;
$params[\Magento\Store\Model\StoreManager::PARAM_RUN_CODE] = '{{store_code}}';
$params[\Magento\Store\Model\StoreManager::PARAM_RUN_TYPE] = 'website';
@sashas777
sashas777 / httpd.conf
Created March 4, 2017 06:05
X-Sendfile Apache
#
# X-Sendfile
#
LoadModule xsendfile_module modules/mod_xsendfile.so
XSendFile On
XSendFilePath "/var/www/site/"
@sashas777
sashas777 / InstallData.php
Last active February 5, 2017 02:23
Magento 2.1.3 Make Customer Attribute - InstallData.php
<?php
/**
* @author Sashas IT Support <support@sashas.org>
* @copyright 2017 Sashas IT Support Inc. (http://www.extensions.sashas.org)
* @license http://opensource.org/licenses/GPL-3.0 GNU General Public License, version 3 (GPL-3.0)
*/
namespace Sashas\CustomerAttribute\Setup;