I can't change product and categories images on opencart 2.2

straightlight wrote:Then, I guess it is time for some troubleshooting. Go back to your admin - > systems - > settings - > edit store - > server tab - > Error Handling - > Display Error Logs, save the changes. Then, in your admin/model/catalog/product.php file, since you are editing a product,

find the 2nd instance of:

Code: Select all

$this->cache->delete('product');

add above:

Code: Select all

exit;

Save the changes. Go back to your admin products page and try to edit another product and see if you notice any error messages once you submitted the changes.

I add the "exit;" but i am not see anything different... and i am not sure if i put this command in right place.

My code was before like below:
----------------------------------
}

$this->cache->delete('product');
}
----------------------------------
and now it is like below:
----------------------------------
}
exit;
$this->cache->delete('product');
}
----------------------------------

It is correct?

The exit command location is under the right spot. Although, the second instance is for the edit product, not the add product. If you didn't noticed any difference, it means you were adding a product rather than edit. If you want to add a product, add the exit command above the first instance as well. Then, add a product again to see if you notice any error messages after submission.

straightlight wrote:The exit command location is under the right spot. Although, the second instance is for the edit product, not the add product. If you didn't noticed any difference, it means you were adding a product rather than edit. If you want to add a product, add the exit command above the first instance as well. Then, add a product again to see if you notice any error messages after submission.

What you mean "spot"? Sorry but i don't understnad you very well because my english isn't good. Can you send me ready examples with code? Like these i send you before?

Thank you.

To add a product with exit:

straightlight wrote:To add a product with exit:

Code: Select all

public function addProduct($data) {
		$this->db->query("INSERT INTO " . DB_PREFIX . "product SET model = '" . $this->db->escape($data['model']) . "', sku = '" . $this->db->escape($data['sku']) . "', upc = '" . $this->db->escape($data['upc']) . "', ean = '" . $this->db->escape($data['ean']) . "', jan = '" . $this->db->escape($data['jan']) . "', isbn = '" . $this->db->escape($data['isbn']) . "', mpn = '" . $this->db->escape($data['mpn']) . "', location = '" . $this->db->escape($data['location']) . "', quantity = '" . (int)$data['quantity'] . "', minimum = '" . (int)$data['minimum'] . "', subtract = '" . (int)$data['subtract'] . "', stock_status_id = '" . (int)$data['stock_status_id'] . "', date_available = '" . $this->db->escape($data['date_available']) . "', manufacturer_id = '" . (int)$data['manufacturer_id'] . "', shipping = '" . (int)$data['shipping'] . "', price = '" . (float)$data['price'] . "', points = '" . (int)$data['points'] . "', weight = '" . (float)$data['weight'] . "', weight_class_id = '" . (int)$data['weight_class_id'] . "', length = '" . (float)$data['length'] . "', width = '" . (float)$data['width'] . "', height = '" . (float)$data['height'] . "', length_class_id = '" . (int)$data['length_class_id'] . "', status = '" . (int)$data['status'] . "', tax_class_id = '" . (int)$data['tax_class_id'] . "', sort_order = '" . (int)$data['sort_order'] . "', date_added = NOW()");

		$product_id = $this->db->getLastId();

		if (isset($data['image'])) {
			$this->db->query("UPDATE " . DB_PREFIX . "product SET image = '" . $this->db->escape($data['image']) . "' WHERE product_id = '" . (int)$product_id . "'");
		}

		foreach ($data['product_description'] as $language_id => $value) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '" . (int)$product_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', description = '" . $this->db->escape($value['description']) . "', tag = '" . $this->db->escape($value['tag']) . "', meta_title = '" . $this->db->escape($value['meta_title']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', meta_keyword = '" . $this->db->escape($value['meta_keyword']) . "'");
		}

		if (isset($data['product_store'])) {
			foreach ($data['product_store'] as $store_id) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_to_store SET product_id = '" . (int)$product_id . "', store_id = '" . (int)$store_id . "'");
			}
		}

		if (isset($data['product_attribute'])) {
			foreach ($data['product_attribute'] as $product_attribute) {
				if ($product_attribute['attribute_id']) {
					// Removes duplicates
					$this->db->query("DELETE FROM " . DB_PREFIX . "product_attribute WHERE product_id = '" . (int)$product_id . "' AND attribute_id = '" . (int)$product_attribute['attribute_id'] . "'");

					foreach ($product_attribute['product_attribute_description'] as $language_id => $product_attribute_description) {
						$this->db->query("DELETE FROM " . DB_PREFIX . "product_attribute WHERE product_id = '" . (int)$product_id . "' AND attribute_id = '" . (int)$product_attribute['attribute_id'] . "' AND language_id = '" . (int)$language_id . "'");

						$this->db->query("INSERT INTO " . DB_PREFIX . "product_attribute SET product_id = '" . (int)$product_id . "', attribute_id = '" . (int)$product_attribute['attribute_id'] . "', language_id = '" . (int)$language_id . "', text = '" .  $this->db->escape($product_attribute_description['text']) . "'");
					}
				}
			}
		}

		if (isset($data['product_option'])) {
			foreach ($data['product_option'] as $product_option) {
				if ($product_option['type'] == 'select' || $product_option['type'] == 'radio' || $product_option['type'] == 'checkbox' || $product_option['type'] == 'image') {
					if (isset($product_option['product_option_value'])) {
						$this->db->query("INSERT INTO " . DB_PREFIX . "product_option SET product_id = '" . (int)$product_id . "', option_id = '" . (int)$product_option['option_id'] . "', required = '" . (int)$product_option['required'] . "'");

						$product_option_id = $this->db->getLastId();

						foreach ($product_option['product_option_value'] as $product_option_value) {
							$this->db->query("INSERT INTO " . DB_PREFIX . "product_option_value SET product_option_id = '" . (int)$product_option_id . "', product_id = '" . (int)$product_id . "', option_id = '" . (int)$product_option['option_id'] . "', option_value_id = '" . (int)$product_option_value['option_value_id'] . "', quantity = '" . (int)$product_option_value['quantity'] . "', subtract = '" . (int)$product_option_value['subtract'] . "', price = '" . (float)$product_option_value['price'] . "', price_prefix = '" . $this->db->escape($product_option_value['price_prefix']) . "', points = '" . (int)$product_option_value['points'] . "', points_prefix = '" . $this->db->escape($product_option_value['points_prefix']) . "', weight = '" . (float)$product_option_value['weight'] . "', weight_prefix = '" . $this->db->escape($product_option_value['weight_prefix']) . "'");
						}
					}
				} else {
					$this->db->query("INSERT INTO " . DB_PREFIX . "product_option SET product_id = '" . (int)$product_id . "', option_id = '" . (int)$product_option['option_id'] . "', value = '" . $this->db->escape($product_option['value']) . "', required = '" . (int)$product_option['required'] . "'");
				}
			}
		}

		if (isset($data['product_discount'])) {
			foreach ($data['product_discount'] as $product_discount) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_discount SET product_id = '" . (int)$product_id . "', customer_group_id = '" . (int)$product_discount['customer_group_id'] . "', quantity = '" . (int)$product_discount['quantity'] . "', priority = '" . (int)$product_discount['priority'] . "', price = '" . (float)$product_discount['price'] . "', date_start = '" . $this->db->escape($product_discount['date_start']) . "', date_end = '" . $this->db->escape($product_discount['date_end']) . "'");
			}
		}

		if (isset($data['product_special'])) {
			foreach ($data['product_special'] as $product_special) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_special SET product_id = '" . (int)$product_id . "', customer_group_id = '" . (int)$product_special['customer_group_id'] . "', priority = '" . (int)$product_special['priority'] . "', price = '" . (float)$product_special['price'] . "', date_start = '" . $this->db->escape($product_special['date_start']) . "', date_end = '" . $this->db->escape($product_special['date_end']) . "'");
			}
		}

		if (isset($data['product_image'])) {
			foreach ($data['product_image'] as $product_image) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_image SET product_id = '" . (int)$product_id . "', image = '" . $this->db->escape($product_image['image']) . "', sort_order = '" . (int)$product_image['sort_order'] . "'");
			}
		}

		if (isset($data['product_download'])) {
			foreach ($data['product_download'] as $download_id) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_to_download SET product_id = '" . (int)$product_id . "', download_id = '" . (int)$download_id . "'");
			}
		}

		if (isset($data['product_category'])) {
			foreach ($data['product_category'] as $category_id) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_to_category SET product_id = '" . (int)$product_id . "', category_id = '" . (int)$category_id . "'");
			}
		}

		if (isset($data['product_filter'])) {
			foreach ($data['product_filter'] as $filter_id) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_filter SET product_id = '" . (int)$product_id . "', filter_id = '" . (int)$filter_id . "'");
			}
		}

		if (isset($data['product_related'])) {
			foreach ($data['product_related'] as $related_id) {
				$this->db->query("DELETE FROM " . DB_PREFIX . "product_related WHERE product_id = '" . (int)$product_id . "' AND related_id = '" . (int)$related_id . "'");
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_related SET product_id = '" . (int)$product_id . "', related_id = '" . (int)$related_id . "'");
				$this->db->query("DELETE FROM " . DB_PREFIX . "product_related WHERE product_id = '" . (int)$related_id . "' AND related_id = '" . (int)$product_id . "'");
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_related SET product_id = '" . (int)$related_id . "', related_id = '" . (int)$product_id . "'");
			}
		}

		if (isset($data['product_reward'])) {
			foreach ($data['product_reward'] as $customer_group_id => $product_reward) {
				if ((int)$product_reward['points'] > 0) {
					$this->db->query("INSERT INTO " . DB_PREFIX . "product_reward SET product_id = '" . (int)$product_id . "', customer_group_id = '" . (int)$customer_group_id . "', points = '" . (int)$product_reward['points'] . "'");
				}
			}
		}

		if (isset($data['product_layout'])) {
			foreach ($data['product_layout'] as $store_id => $layout_id) {
				$this->db->query("INSERT INTO " . DB_PREFIX . "product_to_layout SET product_id = '" . (int)$product_id . "', store_id = '" . (int)$store_id . "', layout_id = '" . (int)$layout_id . "'");
			}
		}

		if (isset($data['keyword'])) {
			$this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET query = 'product_id=" . (int)$product_id . "', keyword = '" . $this->db->escape($data['keyword']) . "'");
		}

		if (isset($data['product_recurrings'])) {
			foreach ($data['product_recurrings'] as $recurring) {
				$this->db->query("INSERT INTO `" . DB_PREFIX . "product_recurring` SET `product_id` = " . (int)$product_id . ", customer_group_id = " . (int)$recurring['customer_group_id'] . ", `recurring_id` = " . (int)$recurring['recurring_id']);
			}
		}

                exit;
		$this->cache->delete('product');

		return $product_id;
	}

I add a test product after the exit in my code and i do not see anything into log console... and ofc the proble is the same with the image... can't change it.

After submitting the form with the new product, did you notice an error message on screen or the screen just went blank?

straightlight wrote:After submitting the form with the new product, did you notice an error message on screen or the screen just went blank?

I am sorry man... i put exit on 2nd line (that you told me before) but lastly the right line isn't the 2nd in my code but the 1st. So i put it now again there, and if i try to import a new product, the screen was white!... but if i edit a another product, saved normally.

dimitrishalkida wrote:

straightlight wrote:After submitting the form with the new product, did you notice an error message on screen or the screen just went blank?

I am sorry man... i put exit on 2nd line (that you told me before) but lastly the right line isn't the 2nd in my code but the 1st. So i put it now again there, and if i try to import a new product, the screen was white!... but if i edit a another product, saved normally.

The exit command location is under the right spot. Although, the second instance is for the edit product, not the add product. If you didn't noticed any difference, it means you were adding a product rather than edit. If you want to add a product, add the exit command above the first instance as well. Then, add a product again to see if you notice any error messages after submission.

What if you now re-add the exit command on the top of the 2nd instance and edit the product, do you also see the page blank after submitting the form?

straightlight wrote:

dimitrishalkida wrote:

straightlight wrote:After submitting the form with the new product, did you notice an error message on screen or the screen just went blank?

I am sorry man... i put exit on 2nd line (that you told me before) but lastly the right line isn't the 2nd in my code but the 1st. So i put it now again there, and if i try to import a new product, the screen was white!... but if i edit a another product, saved normally.

The exit command location is under the right spot. Although, the second instance is for the edit product, not the add product. If you didn't noticed any difference, it means you were adding a product rather than edit. If you want to add a product, add the exit command above the first instance as well. Then, add a product again to see if you notice any error messages after submission.

What if you now re-add the exit command on the top of the 2nd instance and edit the product, do you also see the page blank after submitting the form?

I am sorry... i am not understand you very well. Please see the print screen that i send you.

So far, it may look like either a database permission issue or might also be related to ENGINE database type that might not match your server. Revert the changes in your product.php file and go to your cPanel. Under the cPanel - > databases icon, verify that all the database permissions are checked mark under the privileges.

Afterwards, go to your PHPMyAdmin console and see if your database tables engine either shows as MyISAM or InnoDB which should be located under your selected Opencart database name and look to your right on the: Type field. See if they all match the same names or if you also have different names on the list. Right aside, you will also notice the: Collation field.

Note: There might be more than one page results of your database tables. Make sure to visit all pages for both columns information. Once both information captured, could you provide both fields match information that you see?

straightlight wrote:So far, it may look like either a database permission issue or might also be related to ENGINE database type that might not match your server. Revert the changes in your product.php file and go to your cPanel. Under the cPanel - > databases icon, verify that all the database permissions are checked mark under the privileges.

Afterwards, go to your PHPMyAdmin console and see if your database tables engine either shows as MyISAM or InnoDB which should be located under your selected Opencart database name and look to your right on the: Type field. See if they all match the same names or if you also have different names on the list. Right aside, you will also notice the: Collation field.

Note: There might be more than one page results of your database tables. Make sure to visit all pages for both columns information. Once both information captured, could you provide both fields match information that you see?

I have 1 database and 1 user with all priv and full access. But when i go via PHPMyAdmin in tables with names like these: INNODB_....., i see a message like this: "#1227 - Access denied; you need (at least one of) the PROCESS privilege(s) for this operation". It is normally?

Here we go, we found a clue.

According to this article, and according to my previous post above, it is about privileges issues:

http://stackoverflow.com/questions/7797 ... reate-user

This link provides steps on how to resolve these issues. If you don't have the access or do not know how to resolve these problems by following the technical steps, contact your host and paste in the error message with the access denied on their support ticket. Someone on their end should be able to assist you as soon as they humanly or un-humanly can.

straightlight wrote:Here we go, we found a clue.

According to this article, and according to my previous post above, it is about privileges issues:

http://stackoverflow.com/questions/7797 ... reate-user

This link provides steps on how to resolve these issues. If you don't have the access or do not know how to resolve these problems by following the technical steps, contact your host and paste in the error message with the access denied on their support ticket. Someone on their end should be able to assist you as soon as they humanly or un-humanly can.

Thank you very much for your fast responses and support! You are the best!

I contacted with them and if this problem resolve, i be back to post the solution here.

Have a nice night!

Hello,

Today i found why this problem happening! It is happening because i use the latest version of Mozilla Firefox and maybe some compatibility bug exist between Firefox and Opencart 2.2.0.0??... really i am not sure why this happening only in 2.2.0.0 version of Opencart under Firefox!

With this latest version of Firefox, i am working fine in another versions of Opencart in same web server!? I try it from 3 different pcs and same happens!? If i try to edit my new Opencart e-shop (2.2.0.0) with Google Chrome, working fine!?

I try hard refresh, clear dns (although not save cookies) and the problem (in Firefox) still the same.

So, what do you think? It is a bug of Opencart and not working with all new versions of Firefox or it is a bug of Firefox?

Thank you very much for your time to support me.

Best Regards.

dimitrishalkida wrote:
So, what do you think? It is a bug of Opencart and not working with all new versions of Firefox or it is a bug of Firefox?

.NET Framework installation / Windows Update / Firefox update issues. Not a related OC issue when it comes to host consoles.

I have the same problem,
but on PC , I have problem where I try to change the image, the option to choose a file does not pop up
while when I try in on my phone, the mobile version of the admin, the folder of the images do pop up.
this happened after and update to the most recent version, which I did not do myself, just received a notification that there is an update and I clicked OK
on my website, I have not ever installed anything other than what the program come with, and never made any changes in coding, because of past experienced, i prefer to leave it as is, and if there is any update it as it is provide automatically, but it seems that auto update also causes problem,
it seems to be a glitch on the updates that opencart has done, and needs to be fixed and send a new update so that the correction is made automatically without twirking codes.

jiohbyun wrote: ↑

Thu Jul 25, 2019 4:09 am

.. this happened after and update to the most recent version, which I did not do myself, just received a notification that there is an update and I clicked OK ..

About which Update you are talking?
OpenCart does not update itself automatically.