[SOLVED] Too many keys specified; max 64 keys allowed

Code: Select all

	  	 <!--update cost after product import-->
		<operation error="log">
			<search><![CDATA[$this->load->model('extension/module/adv_profit_module');]]></search>
			<add position="replace" offset="1"><![CDATA[
//<!-- MY CUSTOM ----------------------"MY CUSTOM Admin Product List"------------------- -->
			$results2 = $this->model_catalog_product->custom_getProductsCostCompare();
			$data['countDifference'] = $results2["productCount"] - $results2["costCount"];

			$this->load->model('extension/module/adv_profit_module');
			$data['categories'] = $this->model_extension_module_adv_profit_module->getProductsCategories(0);

			$this->load->controller('extension/module/adv_profit_module');
			$data['custom_update_adv'] = str_replace('&amp;', '&', $this->url->link('extension/module/adv_profit_module/custom_ProductImportRefresh', 'user_token=' . $this->session->data['user_token'] . $url, true));
//<!-- MY CUSTOM ----------------------"MY CUSTOM Admin Product List"------------------- -->
			]]></add>
		</operation>
	   <!--update cost after product import-->

Code: Select all

  
	 <!--update cost after product import-->
		<operation>
			<search><![CDATA[public function uninstall() {]]></search>
			<add position="before"><![CDATA[
	public function custom_ProductImportRefresh() {
	//<!-- MY CUSTOM BEGIN ----------------------"MY CUSTOM Admin Product List"------------------- -->
	
		$query_product = $this->db->query("SELECT p.product_id, isbn FROM `" . DB_PREFIX . "product` p WHERE p.product_id NOT IN (SELECT p.product_id FROM " . DB_PREFIX . "product_cost pc, " . DB_PREFIX . "product p WHERE pc.product_id = p.product_id)");
		foreach ($query_product->rows as $result) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "product_cost SET product_id = '" . (int)$result['product_id'] . "', supplier_id = '0', cost = '" . (int)$result['isbn'] . "', cost_amount = '" . (int)$result['isbn'] . "', cost_percentage = '0.00', cost_additional = '0.0000', costing_method = '0'");
		}

		$query_option = $this->db->query("SELECT pov.product_option_value_id, pov.product_id FROM `" . DB_PREFIX . "product_option_value` pov WHERE pov.product_option_value_id NOT IN (SELECT pov.product_option_value_id FROM " . DB_PREFIX . "product_option_cost poc, " . DB_PREFIX . "product_option_value pov WHERE poc.product_option_value_id = pov.product_option_value_id)");
		foreach ($query_option->rows as $result) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "product_option_cost SET product_option_value_id = '" . (int)$result['product_option_value_id'] . "', product_id = '" . (int)$result['product_id'] . "', cost = '0.0000', cost_amount = '0.0000', cost_prefix = '', costing_method = '0', sku = ''");
		}

		$query_order_product = $this->db->query("SELECT op.order_product_id, op.order_id, op.product_id, op.price FROM `" . DB_PREFIX . "order_product` op, `" . DB_PREFIX . "order` o WHERE o.order_id = op.order_id AND o.order_status_id > 0 AND op.order_product_id NOT IN (SELECT op.order_product_id FROM " . DB_PREFIX . "order_product_cost opc, " . DB_PREFIX . "order_product op WHERE opc.order_product_id = op.order_product_id)");
		foreach ($query_order_product->rows as $result) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "order_product_cost SET order_product_id = '" . (int)$result['order_product_id'] . "', order_id = '" . (int)$result['order_id'] . "', product_id = '" . (int)$result['product_id'] . "', supplier_id = '0', cost = '0.0000', base_price = '" . (float)$result['price'] . "'");
		}
	
		$this->db->query("ALTER TABLE `" . DB_PREFIX . "order_product_cost` ADD INDEX (order_id);");

		$query_order = $this->db->query("SELECT o.order_id FROM `" . DB_PREFIX . "order` o WHERE order_status_id > 0 AND o.order_id NOT IN (SELECT oc.order_id FROM " . DB_PREFIX . "order_cost oc)");
		foreach ($query_order->rows as $result) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "order_cost SET order_id = '" . (int)$result['order_id'] . "', payment_cost = '0.0000', shipping_cost = '0.0000', extra_cost = '0.0000'");
		}

		$query_return = $this->db->query("SELECT r.return_id, r.order_id FROM `" . DB_PREFIX . "return` r WHERE r.return_id NOT IN (SELECT r.return_id FROM " . DB_PREFIX . "return_cost rc, " . DB_PREFIX . "return r WHERE rc.return_id = r.return_id)");
		foreach ($query_return->rows as $result) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "return_cost SET return_id = '" . (int)$result['return_id'] . "', order_id = '" . (int)$result['order_id'] . "', cost = '0.0000'");
		}

		$this->response->redirect($this->url->link('catalog/product', 'user_token=' . $this->session->data['user_token'] . '&type=module', true));

	}
//<!-- MY CUSTOM END ----------------------"MY CUSTOM Admin Product List"------------------- -->

			]]></add>
		</operation>	  
	   <!--update cost after product import-->

Code: Select all

$this->db->query("ALTER TABLE `" . DB_PREFIX . "order_product_cost` ADD INDEX (order_id);");