timbroder

var menu = [
	{title:'Menu 1',},
	{title:'Menu 2',},
	{title:'Menu 3',}
];

var tableview = Titanium.UI.createTableView({
	data:menu,
});

timbroder

[adorama@time shell]$ php indexer.php --reindexall
Cannot load the ionCube PHP Loader - it was built with configuration 2.2.0, whereas running engine is API220090626,NTS
PHP Warning:  PHP Startup: apc.shm_size now uses M/G suffixes, please update your ini files in Unknown on line 0
Product Attributes index was rebuilt successfully
Product Prices index was rebuilt successfully
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index was rebuilt successfully
Category Flat Data index process unknown error:
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`store_id` smallint(5) unsigned not null default '0',

timbroder

				$product = Mage::getModel('catalog/product')->loadByAttribute('sku',$fieldMap['sku']);
				
	
					$product->save();

timbroder

1hi

Warning: Invalid argument supplied for foreach()  in /Users/broderboy/workspace/adorama-magento/app/code/core/Mage/Eav/Model/Entity/Abstract.php on line 1070

#0 /Users/broderboy/workspace/adorama-magento/app/code/core/Mage/Eav/Model/Entity/Abstract.php(1070): mageCoreErrorHandler(2, 'Invalid argumen...', '/Users/broderbo...', 1070, Array)
#1 /Users/broderboy/workspace/adorama-magento/app/code/core/Mage/Eav/Model/Entity/Abstract.php(1012): Mage_Eav_Model_Entity_Abstract->_collectSaveData(Object(Ai_Catalog_Model_Product))
#2 /Users/broderboy/workspace/adorama-magento/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Eav_Model_Entity_Abstract->save(Object(Ai_Catalog_Model_Product))
#3 /Users/broderboy/workspace/adorama-magento/app/code/local/Ai/Catalog/Model/Imageingest.php(118): Mage_Core_Model_Abstract->save()
#4 /Users/broderboy/workspace/adorama-magento/app/code/local/Ai/Catalog/Model/Imageingest.php(55): Ai_Catalog_Model_Imageingest->_processUploadedProductImages('ABMCCS55WSV-1-s...')
#5 /Users/br

timbroder

update catalog_product_entity_int i, eav_attribute a set i.value = 1 where a.attribute_code = "status" and i.attribute_id = a.attribute_id;
update catalog_product_entity_int i, eav_attribute a set i.value = 2 where a.attribute_code = "visibility" and i.attribute_id = a.attribute_id;
update catalog_product_entity_int i, eav_attribute a set i.value = 2 where a.attribute_code = "tax_class_id" and i.attribute_id = a.attribute_id;

timbroder

drop table if exists ai_brands_entered;
drop table if exists ai_brands_new;

create table ai_brands_entered as
select * from ai_brands 
where brands_id in (select brands_id from ai_jumboni_brands_assoc)
or brands_id in (select brands_id from ai_megadrops_brands_assoc)
or brands_id in (select brand_id from ai_used)
;

timbroder

    protected function _matchAttribute(Varien_Object $attribute, $item)
    {
        $code  = $attribute->getAttributeCode();
        $value = $item->getData($code);
		Mage::log("Mapping Price code/value ".$code."/".$value, null, "migration.log");
		Mage::log($item, null, "migration.log");

        if ($code == 'entity_type_id') {
            $value = $attribute->getEntityTypeId();
        } elseif ($code == 'attribute_set_id') {

timbroder

SET FOREIGN_KEY_CHECKS=0;
 
TRUNCATE `sales_order`;
TRUNCATE `sales_order_datetime`;
TRUNCATE `sales_order_decimal`;
TRUNCATE `sales_order_entity`;
TRUNCATE `sales_order_entity_datetime`;
TRUNCATE `sales_order_entity_decimal`;
TRUNCATE `sales_order_entity_int`;
TRUNCATE `sales_order_entity_text`;

timbroder

if($_product->getAdrIsRefurbished() == 1) { ?>
<li><a href="#" class="lb_waystosave"
	rel="refurbished_products"><?php echo $refurbished['count']?>
		Refurbished <?php if($pricecount==0){if($refurbished['count']>1) { echo 'from ';}else{ echo 'for ';}?>
		<?php echo Mage::helper('core')->currency($pricepointdata['adr_is_refurbished']['lowest_price'],true,false);$pricecount=1;}?>
</a></li>
<?php }

timbroder

#INSERT INTO `core_url_rewrite` (`store_id`, `category_id`, `product_id`, `id_path`, `request_path`, `target_path`, `is_system`) 
SELECT 1 AS `store_id`, 
  `sub`.`category_id`, 
  `sub`.`entity_id` AS `product_id`, 
  CONCAT('product', '/', `entity_id`, '/', `category_id`) AS `id_path`, 
  `value` AS `request_path`, 
  CONCAT('catalog/product/view/id/', `entity_id`, '/category/', `category_id`) AS `target_path`, 
  1 AS `is_system` 
FROM 
 (SELECT