Skip to content

Instantly share code, notes, and snippets.

View gygi's full-sized avatar

Ted gygi

View GitHub Profile
@gygi
gygi / SiteMapSQL Error
Created April 11, 2015 16:23
Magento Sitemap SQL error
Sitemap generate warnings: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query, query was: SELECT `main_table`.`entity_id`, `url_rewrite`.`request_path` FROM `catalog_product_entity` AS `main_table` INNER JOIN `catalog_product_website` AS `w` ON main_table.entity_id = w.product_id LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.product_id = main_table.entity_id AND url_rewrite.is_system = 1 AND url_rewrite.category_id IS NULL AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'product/%' INNER JOIN `catalog_product_entity_int` AS `t1_visibility` ON main_table.entity_id=t1_visibility.entity_id AND t1_visibility.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `t2_visibility` ON t1_visibility.entity_id = t2_visibility.entity_id AND t1_visibility.attribute_id = t2_visibility.attribute_id AND t2_visibility.store_id = 1 INNER JOIN `catalog_product_entity_int` AS `t1_status` ON main_table.entity_id=t1_status.entity_id AND t1_status.store_id=0 LEFT JOIN `catalog_
@gygi
gygi / SiteMapSQL Error
Created April 11, 2015 16:25
Sitemap generate warnings:
SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query, query was: SELECT `main_table`.`entity_id`, `url_rewrite`.`request_path` FROM `catalog_product_entity` AS `main_table` INNER JOIN `catalog_product_website` AS `w` ON main_table.entity_id = w.product_id LEFT JOIN `core_url_rewrite` AS `url_rewrite` ON url_rewrite.product_id = main_table.entity_id AND url_rewrite.is_system = 1 AND url_rewrite.category_id IS NULL AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'product/%' INNER JOIN `catalog_product_entity_int` AS `t1_visibility` ON main_table.entity_id=t1_visibility.entity_id AND t1_visibility.store_id=0 LEFT JOIN `catalog_product_entity_int` AS `t2_visibility` ON t1_visibility.entity_id = t2_visibility.entity_id AND t1_visibility.attribute_id = t2_visibility.attribute_id AND t2_visibility.store_id = 1 INNER JOIN `catalog_product_entity_int` AS `t1_status` ON main_table.entity_id=t1_status.entity_id AND t1_status.store_id=0 LEFT JOIN `catalog
@gygi
gygi / one_year_events.php
Created April 13, 2015 20:54
one year events
<?php
/**
* Created by PhpStorm.
* User: Ted
* Date: 4/13/15
* Time: 2:53 PM
*/
//show more events on the events list pages
add_action( 'pre_get_posts', 'show_one_year_of_events' );
@gygi
gygi / system.log
Created April 16, 2015 15:08
system.log errors - mostly pointing back to magenthemes responsive.cless file which is non-existent.
This file has been truncated, but you can view the full file.
2015-04-16T07:50:07+00:00 ERR (3): Notice: Undefined variable: _count_thumb in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/cloudzoom/product/view/media.phtml on line 84
2015-04-16T07:50:07+00:00 ERR (3): Notice: Undefined variable: _count_thumb in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/cloudzoom/product/view/media.phtml on line 84
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: _count_thumb in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/cloudzoom/product/view/media.phtml on line 84
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: storeId in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/layerslideshow/default.phtml on line 2
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: storeId in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/layerslideshow/default.phtml on line 3
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: storeId i
@gygi
gygi / system.log
Created April 16, 2015 15:25
system log document
This file has been truncated, but you can view the full file.
2015-04-16T07:50:07+00:00 ERR (3): Notice: Undefined variable: _count_thumb in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/cloudzoom/product/view/media.phtml on line 84
2015-04-16T07:50:07+00:00 ERR (3): Notice: Undefined variable: _count_thumb in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/cloudzoom/product/view/media.phtml on line 84
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: _count_thumb in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/cloudzoom/product/view/media.phtml on line 84
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: storeId in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/layerslideshow/default.phtml on line 2
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: storeId in /home/gygi/www/app/design/frontend/gygi/default/template/magenthemes/layerslideshow/default.phtml on line 3
2015-04-16T07:50:18+00:00 ERR (3): Notice: Undefined variable: storeId i
@gygi
gygi / updated_Files_1.90.php
Created April 16, 2015 16:30
updated files from host
<?php
/**
* Created by PhpStorm.
* User: Ted
* Date: 4/16/15
* Time: 10:30 AM
*/
On Fri Feb 27 2015 12:10PM support@lexiconn.com wrote:
@gygi
gygi / woocommerce_inventory.php
Created April 16, 2015 21:18
gist to share with friends and family
<?php
/**
* Created by PhpStorm.
* User: Ted Sanders Digital Marketing Manager not Developer put smiley face here
* Date: 3/23/15
* Time: 10:50 AM
*/
// Simple script to push inventory from Mage:: getModel to gygicookingclases.com
// Attributes included are quantity ("inventory_qty") and sku ("sku")
@gygi
gygi / Unknown_custom_css
Created April 20, 2015 15:51
This file is neither in the custom.css or the styles.css
<!-- Custom CSS Styling -->
<style type="text/css">
#logo .site-title, #logo .site-description { display:none; }
body {background-repeat:no-repeat;background-position:top center;background-attachment:scroll;border-top:0px solid #000000;}
a:link, a:visited, #loopedSlider a.flex-prev:hover, #loopedSlider a.flex-next:hover {color:#000000} .quantity .plus, .quantity .minus {background-color: #000000;}
a:hover, .post-more a:hover, .post-meta a:hover, .post p.tags a:hover {color:#000000}
#header {background-repeat:no-repeat;background-position:left top;margin-top:0px;margin-bottom:-2px;padding-top:2px;padding-bottom:10px;border:0px solid ;}
#logo {padding-left:419px;}.header-widget {padding-right:419px;}
#logo .site-title a {font:bold 40px/1em Arial, sans-serif;color:#222222;}
#logo .site-description {font:300 13px/1em Arial, sans-serif;color:#999999;}
@gygi
gygi / gist:69c85aa9144dec6065d2
Created April 20, 2015 18:53
New_Order_confirmation Email
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>{{config path="general/store_information/name"}} Order Confirmation</title>
</head>
<body>
@gygi
gygi / gist:b6e70861f0748022fdb4
Created April 20, 2015 19:14
New_Order_confirmation_Email (in transition )
<div dir="ltr"><div class="gmail_quote">
<div marginwidth="0" marginheight="0" style="margin:0;padding:0;background-color:#f2f2f2;min-height:100%!important;width:637px">
<center>
<table align="center" border="0" cellpadding="0" cellspacing="0" height="100%" width="637px"style="border-collapse:collapse;margin:0;padding:0;background-color:#f2f2f2;height:100%!important;width:100%!important">
<tbody><tr>
<td align="center" valign="top" style="margin:0;padding:20px;border-top:0;height:100%!important;width:100%!important">
<table border="0" cellpadding="0" cellspacing="0" width=100% style="border-collapse:collapse;border:0">
<tbody><tr>
<td align="center" valign="top">