Hello,
I have a clean installation of OpenCart 3.0.4.0 and imported all products from (my old) OpenCart 2.0.3.2 into the 3.0.4.0 database.
I can upload and replace the first product image without any issues.
However, when I try to add additional images to an existing product, both on localhost (WAMP) and on an online test shop with Linux, it doesn't work.
Instead, I get the default OpenCart blue product picture.
This is not a permissions issue, nor a caching issue. What could be causing this?
When I create a new product, it works fine and can add a second pica.
Are you out of space? Are the images you're uploading too big? Are they they wrong file type or colour space?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
Hello Paul,paulfeakins wrote: ↑Mon Dec 30, 2024 8:38 pmAre you out of space? Are the images you're uploading too big? Are they they wrong file type or colour space?
Offcourse not, there is lot of space online on the linux host and on my local WAMP.
Images are fine (settings in system updated tot 1 MB (default was 300kB).
Just normal product images as always...
But strange thing. Picture nummer 3 and 4 i can upload and are oke. Only picture nr 2 not?!
When i delete picture 2 afterwards for workarround is oke.
This must be a bug somewhere.
What about the filenames of the images?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
Could have been a corrupted image file.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
No corrupted images, no strange filenames... Guys, come on. We are, of course, using JPG images. Nothing special.
I tried with small images, with/without spaces, underscores, and dashes. The second picture can be uploaded but is does not show up in the backend.
The third and fourth pictures are fine, and then we delete the second one.
Very strange, must be a bug somewhere
I tried with small images, with/without spaces, underscores, and dashes. The second picture can be uploaded but is does not show up in the backend.
The third and fourth pictures are fine, and then we delete the second one.
Very strange, must be a bug somewhere
When you imported your products to the new OC 3.0.4.0, did you make sure to use the correct image paths, they are different compared to OC 2.0.3.2. Assuming you were using our Export/Import tool, the values in the 'image' column in worksheet 'AdditionalImages' usually start with 'catalog/'. And the image files are usually stored in the 'image/catalog' folder.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
The original intention was this:
Export all products from the live shop OC2303 without images.
Because we wanted to redo all the images neatly.
We performed these queries on the old environment:
Remove default pictures with:
UPDATE `oc_product` SET `image` = NULL;
Remove additional pictures with:
DELETE FROM `oc_product_image`;
Then, we exported all `oc_product*` tables using phpMyAdmin.
Afterwards, we imported these `oc_product*` tables back into the new OC3040 shop using phpMyAdmin.
However, when we try to add the first extra (i.e. second) image, it doesn't work.
Did something go wrong in this process?
Export all products from the live shop OC2303 without images.
Because we wanted to redo all the images neatly.
We performed these queries on the old environment:
Remove default pictures with:
UPDATE `oc_product` SET `image` = NULL;
Remove additional pictures with:
DELETE FROM `oc_product_image`;
Then, we exported all `oc_product*` tables using phpMyAdmin.
Afterwards, we imported these `oc_product*` tables back into the new OC3040 shop using phpMyAdmin.
However, when we try to add the first extra (i.e. second) image, it doesn't work.
Did something go wrong in this process?
I can't see anything wrong with this approach, except you should have used
instead of
Code: Select all
TRUNCATE `oc_product_image`
Code: Select all
DELETE FROM `oc_product_image`If your issue is now solved, please add [SOLVED] to the start of this topic title.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Legendary Member
Who is online
Users browsing this forum: Bing [Bot], Semrush [Bot] and 13 guests
