Fabrizio Balliano fballiano

## magento-composer-issues.md

      
              1 file
            
          
              0 forks
            
          
              7 comments
            
          
              16 stars
            
          
                Vinai
                / magento-composer-issues.md
            
            
              Last active
              April 15, 2020 03:09
            
              
                My beef with composer and Magento
              
          
    My beef with composer and Magento

Magento has recently merged an architecture proposal with the goal of removing non-composer modules.

At first this seems like a good idea, but I think there are some problems.
Community Bias

Magento listens to the community. That is a good thing.

  
## Magento 1.x Orphaned Records Cleanup.md

      
              2 files
            
          
              4 forks
            
          
              7 comments
            
          
              14 stars
            
          
                dfelton
                / Magento 1.x Orphaned Records Cleanup.md
            
            
              Last active
              May 24, 2021 19:23
            
              
                Deletes orphaned records from a Magento 1.x database.
              
          
    Purpose

The purpose of this SQL script is to clean up a Magento 1.x database by deleting orphaned
records from database tables which cause foreign key contraint failures. This happens when
at some point in time records where deleted from the database while FOREIGN_KEY_CHECKS = 0
and the person performing the delete operations failed to delete all related records
pertaining to related tables of the primary table.
This script can be helpful when encountering foreign key constraint failures using the
Data Migration Tool to migrate your

  
## removeOrphanImages.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>Remove Magento's orphan images web console</title>
    <link href='https://fonts.googleapis.com/css?family=Open+Sans+Condensed:300,700' rel='stylesheet' type='text/css'>
    <link href='https://fonts.googleapis.com/css?family=Inconsolata:400,700&subset=latin,latin-ext' rel='stylesheet'
          type='text/css'>
    <style type="text/css">

## prefixed-office-properties.md

      
              1 file
            
          
              29 forks
            
          
              1 comment
            
          
              121 stars
            
          
                p3t3r67x0
                / prefixed-office-properties.md
            
            
              Last active
              February 20, 2024 19:15
            
              
                MS Office prefixed style properties can be used for older versions of MS Excel, MS PowerPoint or MS Word when you want to save a document, presentation, workbook, or worksheet as a web document, or even in older versions for MS Outlook.
              
          
    MS Office prefixed style properties

mso-ansi-font-size

Note: Office only
mso-ansi-font-size: large | larger | <length> | medium | <percentage> | small | smaller | x-large | x-small | xx-large | xx-small


## gist:7645313
truncate catalog_product_flat_cl;
truncate catalog_category_product_index_cl;
truncate catalog_category_product_cat_cl;
truncate catalog_category_flat_cl;
truncate catalogsearch_fulltext_cl;
truncate cataloginventory_stock_status_cl;
truncate catalog_product_flat_cl;
truncate catalog_product_index_price_cl;
truncate enterprise_url_rewrite_category_cl;
truncate enterprise_url_rewrite_product_cl;

## mysql_monitor.sh
#!/bin/bash
#
# Monitor MySQL queries
# @author Colin Mollenhour

set -e

mysql="mysql"
test="test"
bash="bash"

## cleanCache.php
<?php
/**
 * Set global/skip_process_modules_updates to '1' in app/etc/local.xml and
 * then use this script to apply updates and refresh the config cache without
 * causing a stampede on the config cache.
 *
 * @author Colin Mollenhour
 */
umask(0);
ini_set('memory_limit','512M');
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
	<title>Remove Magento's orphan images web console</title>
	<link href='https://fonts.googleapis.com/css?family=Open+Sans+Condensed:300,700' rel='stylesheet' type='text/css'>
	<link href='https://fonts.googleapis.com/css?family=Inconsolata:400,700&subset=latin,latin-ext' rel='stylesheet'
	type='text/css'>
	<style type="text/css">
	truncate catalog_product_flat_cl;
	truncate catalog_category_product_index_cl;
	truncate catalog_category_product_cat_cl;
	truncate catalog_category_flat_cl;
	truncate catalogsearch_fulltext_cl;
	truncate cataloginventory_stock_status_cl;
	truncate catalog_product_flat_cl;
	truncate catalog_product_index_price_cl;
	truncate enterprise_url_rewrite_category_cl;
	truncate enterprise_url_rewrite_product_cl;
	#!/bin/bash
	#
	# Monitor MySQL queries
	# @author Colin Mollenhour

	set -e

	mysql="mysql"
	test="test"
	bash="bash"
	<?php
	/**
	* Set global/skip_process_modules_updates to '1' in app/etc/local.xml and
	* then use this script to apply updates and refresh the config cache without
	* causing a stampede on the config cache.
	*
	* @author Colin Mollenhour
	*/
	umask(0);
	ini_set('memory_limit','512M');