Nolwennig Nolwennig

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

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

## 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    |                |

  
## tips.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Nolwennig
                / tips.md
            
            
              Last active
              December 11, 2018 08:59
            
              
                Magento2 > adminhtml > product > view 
              
          
    Cannot gather stats! Warning!stat(): stat failed for /var/www/html/magento2/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;


## test-checkbox.md

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              0 stars
            
          
                Nolwennig
                / test-checkbox.md
            
            
              Last active
              December 3, 2018 10:41
            
          
    Test CheckBox
- [ ]

 text


checked

  
## mysql_splitdump.sh
#!/bin/bash

####
# Split MySQL dump SQL file into one file per table
# based on http://blog.tty.nl/2011/12/28/splitting-a-database-dump
####

if [ $# -lt 1 ] ; then
  echo "USAGE $0 DUMP_FILE [TABLE]"
  exit

## html5-structure.html
<!doctype html>
<html lang="fr">
<head>
  <meta charset="utf-8">
  <title>Titre de la page</title>
  <link rel="stylesheet" href="style.css">
  <script src="script.js"></script>
</head>
<body>
  ...

## Layout.php
<?php
// app/code/LayoutLogger/PageXml/Model/Layout.php
namespace LayoutLogger\PageXml\Model;

use Magento\Framework\Event\Observer;
use Magento\Framework\Event\ObserverInterface;

class Layout  implements ObserverInterface {
    protected $_logger;
	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` -1));
	echo '--lastest:' ;\docker ps -l;
	echo 'Docker ps:';\
	echo '- run:' $((`docker ps \| wc -l` -1));\
	echo '--all:' $((`docker ps -a \| wc -l`));\
	echo '--lastest:' ;\
	docker ps -l;
	#!/bin/bash

	####
	# Split MySQL dump SQL file into one file per table
	# based on http://blog.tty.nl/2011/12/28/splitting-a-database-dump
	####

	if [ $# -lt 1 ] ; then
	echo "USAGE $0 DUMP_FILE [TABLE]"
	exit
	<!doctype html>
	<html lang="fr">
	<head>
	<meta charset="utf-8">
	<title>Titre de la page</title>
	<link rel="stylesheet" href="style.css">
	<script src="script.js"></script>
	</head>
	<body>
	...
	<?php
	// app/code/LayoutLogger/PageXml/Model/Layout.php
	namespace LayoutLogger\PageXml\Model;

	use Magento\Framework\Event\Observer;
	use Magento\Framework\Event\ObserverInterface;

	class Layout implements ObserverInterface {
	protected $_logger;