Nolwennig Nolwennig

## Magento simpleCategoryTree.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Nolwennig
                / Magento simpleCategoryTree.md
            
            
              Last active
              December 8, 2020 13:30
            
              
                Magento-{1.{7-9}|2} simpleCategoryTree sql request > .csv
              
          
    Magento simpleCategoryTree.csv

command from cli

mysql -uroot -proot magento -e "here sql query" > category_tree.csv; 
sql query


## countdown.html
<!DOCTYPE HTML>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
p {
  font-family:monospace;
  text-align: center;
  font-size: 60px;
  margin-top: 0px;

## heart_acsii.txt
..010...010
.01011.01100
0110111101110
1100110010101
.11100101101
...1110111
.....010
......1

## readme.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Nolwennig
                / readme.md
            
            
              Last active
              May 26, 2020 04:30
            
              
                Debian 9 : Quick Fix jessie-backports/main 404 Not Found
              
          
    For fix :

http://ftp.debian.org/debian jessie-backports/main amd64 Packages 404 Not Found [IP: 130.89.148.12 80]

On Debian 9 : comment jessie-backports in /etc/apt/sources.list.d/backports.list or in /etc/apt/sources.list

  
## local-xml-template.xml
<config>
    <global>
        <install>
            <date>{{date}}</date>
        </install>
        <crypt>
            <key>{{key}}</key>
        </crypt>
        <disable_local_modules>false</disable_local_modules>
        <resources>

## mise_en_prod_ftp.notice.txt
###############
# Problem:
# faire une mise en prod avec le travail et les fichiers de qqn d'autre
# On a : un dépôt git local, un dépôt git preprod, un accès ftp (ou sftp) en prod

#################
# résolution
# 1*/ trouver la dernière mise en prod sur srv prod
# 1.1*/ cnx ftp -> check last date
# 2*/ faire le diff (git whatchanged) sur la preprod (plus stable que local) entre %last_date_modify_prod% et %now% (ou autre date)

## wp_post_href.sql
SELECT guid, post_title, post_content
FROM `posts`
WHERE post_type = 'post'
AND post_content LIKE '%href%';

## readme.sql.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Nolwennig
                / readme.sql.md
            
            
              Created
              January 22, 2019 15:14
            
              
                Cannot gather stats! Warning!stat(): stat failed for pub/media/catalog/product/i/m/image.jpg
              
          
    Please run below sql code
SET @file = '/i/m/image.jpg';
START TRANSACTION;
DELETE FROM catalog_product_entity_media_gallery WHERE value = @file;
DELETE FROM catalog_product_entity_varchar WHERE value = @file;
COMMIT;

source: https://magento.stackexchange.com/a/165204/24845
author: https://magento.stackexchange.com/users/36750/gelanivishal


## docker_ps.alias.sh
echo 'Docker ps:';\
echo '- run:' $((`docker ps | wc -l` -1));\
echo '--all:' $((`docker ps -a | wc -l`));\
echo '--lastest:' ;\
docker ps -l;

## magento2_tax.sql.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Nolwennig
                / magento2_tax.sql.md
            
            
              Last active
              December 13, 2018 19:33
            
          
    mysql> desc tax_calculation;
+-------------------------+-------------+------+-----+---------+----------------+
| Field                   | Type        | Null | Key | Default | Extra          |
+-------------------------+-------------+------+-----+---------+----------------+
| tax_calculation_id      | int(11)     | NO   | PRI | NULL    | auto_increment |
| tax_calculation_rate.tax_calculation_rate_id | int(11)     | NO   | MUL | NULL    |                |
| tax_calculation_rule.tax_calculation_rule_id | int(11)     | NO   | MUL | NULL    |                |
| tax_class.class_id (customer_tax_class_id)   | smallint(6) | NO   | MUL | NULL    |                |
| tax_class.class_id (product_tax_class_id)    | smallint(6) | NO   | MUL | NULL    |                |
	<!DOCTYPE HTML>
	<html>
	<head>
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<style>
	p {
	font-family:monospace;
	text-align: center;
	font-size: 60px;
	margin-top: 0px;
	..010...010
	.01011.01100
	0110111101110
	1100110010101
	.11100101101
	...1110111
	.....010
	......1
	<config>
	<global>
	<install>
	<date>{{date}}</date>
	</install>
	<crypt>
	<key>{{key}}</key>
	</crypt>
	<disable_local_modules>false</disable_local_modules>
	<resources>
	###############
	# Problem:
	# faire une mise en prod avec le travail et les fichiers de qqn d'autre
	# On a : un dépôt git local, un dépôt git preprod, un accès ftp (ou sftp) en prod

	#################
	# résolution
	# 1*/ trouver la dernière mise en prod sur srv prod
	# 1.1*/ cnx ftp -> check last date
	# 2*/ faire le diff (git whatchanged) sur la preprod (plus stable que local) entre %last_date_modify_prod% et %now% (ou autre date)
	SELECT guid, post_title, post_content
	FROM `posts`
	WHERE post_type = 'post'
	AND post_content LIKE '%href%';
	echo 'Docker ps:';\
	echo '- run:' $((`docker ps \| wc -l` -1));\
	echo '--all:' $((`docker ps -a \| wc -l`));\
	echo '--lastest:' ;\
	docker ps -l;