tegansnyder

; Enable Zend OPcache extension module
zend_extension=opcache.so

; Determines if Zend OPCache is enabled
opcache.enable=1

; Determines if Zend OPCache is enabled for the CLI version of PHP
;opcache.enable_cli=0

; The OPcache shared memory storage size.

tegansnyder

SELECT *
FROM `catalog_product_entity` AS a
LEFT JOIN `catalog_product_entity_media_gallery` AS b ON a.entity_id = b.entity_id
WHERE b.value IS NULL

tegansnyder

I'm recieving a strange error on a new install of Spark. I have setup a small 3 node spark cluster on top of an existing hadoop instance. The error I get is the same for any command I try to run on pyspark shell I get the following error:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/opt/spark/python/pyspark/rdd.py", line 1041, in count
    return self.mapPartitions(lambda i: [sum(1 for _ in i)]).sum()
  File "/opt/spark/python/pyspark/rdd.py", line 1032, in sum
    return self.mapPartitions(lambda x: [sum(x)]).fold(0, operator.add)
  File "/opt/spark/python/pyspark/rdd.py", line 906, in fold

tegansnyder

#!/bin/bash -       
#title           :magedev_db.sh
#description     :For those times when n98-magerun db:dump is unavailable
#author		 	 :Tegan Snyder
#notes           :dev db backups in Magento via bash (no production data)
#==============================================================================

current_time=$(date "+%Y.%m.%d-%H.%M.%S")

# clean up tmp files

tegansnyder

SELECT `main_table`.*, (main_table.base_subtotal_with_discount*main_table.base_to_global_rate) AS `subtotal`, `cust_email`.`email`, `cust_fname`.`value` AS `firstname`, `cust_lname`.`value` AS `lastname`, CONCAT_WS(' ', cust_fname.value, cust_lname.value) AS `customer_name` FROM `sales_flat_quote` AS `main_table`
INNER JOIN `customer_entity` AS `cust_email` ON cust_email.entity_id = main_table.customer_id
INNER JOIN `customer_entity_varchar` AS `cust_fname` ON cust_fname.entity_id = main_table.customer_id AND cust_fname.attribute_id = 5
INNER JOIN `customer_entity_varchar` AS `cust_lname` ON cust_lname.entity_id = main_table.customer_id AND cust_lname.attribute_id = 7 WHERE (items_count != '0') AND (main_table.is_active = '1') AND (main_table.created_at >= '2014-06-15 00:00:00') ORDER BY updated_at DESC

tegansnyder

<?php

/*
Author: Tegan Snyder <tsnyder@tegdesign.com>
Example of running a Dataflow profile via command line
you can change the profile_id to the one you want to 
run and issue:
time php manual-dataflow-profile.php
note you may need to increase the memory_limit in php cli's php_cli.ini
RHEL linux copy /etc/php.ini to /etc/php_cli.ini and make changes there then restart Apache.

tegansnyder

#NameVirtualHost *:80
<VirtualHost *:80>
    ServerName "www.domain.com"
    ServerAlias domain.com
	ErrorLog logs/error_log
	TransferLog logs/access_log
	LogLevel warn
	ServerAdmin admin@domain.com
	DocumentRoot /sites/magento
	DirectoryIndex index.php index.html

tegansnyder

Create a file called abstract.php and place it in your root Magento folder:

abstract.php

<?php
use \Magento\Framework\AppInterface as AppInterface;
use \Magento\Framework\App\Http as Http;

use Magento\Framework\ObjectManager\ConfigLoaderInterface;
use Magento\Framework\App\Request\Http as RequestHttp;

tegansnyder

<?php
$order = Mage::getResourceModel('sales/order_collection')
  	   ->addFieldToFilter('customer_id', $customer_id)
		   ->addRecurringProfilesFilter($profile->getProfileId())
		   ->setOrder('entity_id', 'desc')
		   ->getFirstItem();
		   
echo '<pre>';
print_r($order->getData());
echo '</pre>';

tegansnyder

SELECT `main_table`.*,
       (main_table.base_subtotal_with_discount*main_table.base_to_global_rate) AS `subtotal`,
       `cust_email`.`email`,
       `cust_fname`.`value` AS `firstname`,
       `cust_lname`.`value` AS `lastname`,
       CONCAT_WS(' ', cust_fname.value, cust_lname.value) AS `customer_name`
FROM `sales_flat_quote` AS `main_table`
INNER JOIN `customer_entity` AS `cust_email` ON cust_email.entity_id = main_table.customer_id
INNER JOIN `customer_entity_varchar` AS `cust_fname` ON cust_fname.entity_id = main_table.customer_id
AND cust_fname.attribute_id = 5