Jump to content

Product images not showing in frontend


Danmant_DK

Recommended Posts

Hi

I'm having an issue after changing product ID numbers, due to having too high values that reached the ps limit. I have used the TRUNCATE and imported the products again. But the image links refer to the old ones and i don't know how to change this. Regeneration of images and on/off of the user-friendly-url dosen't help too

PS version 1.7.8.11, PHP-version: 7.4.33, webshop: billigbyggemarked.dk

Any help is appreciated

Link to comment
Share on other sites

Regenerating images does not work simply because the images are based on the initial image upload (original product image) that is also linked to the product ID that it is uploaded for.

You have the mapping of image and product id in the ps_image table, but unfortunately you have changed the original product IDs that the mappings are based on.

Do you have some backup of the previous db? If not, you cannot solve too much. 

If you have managed hosting ask their support if they have a database backup for your domain.

Edited by QuickUpdate.net (see edit history)
  • Like 1
Link to comment
Share on other sites

14 hours ago, QuickUpdate.net said:

Regenerating images does not work simply because the images are based on the initial image upload (original product image) that is also linked to the product ID that it is uploaded for.

You have the mapping of image and product id in the ps_image table, but unfortunately you have changed the original product IDs that the mappings are based on.

Do you have some backup of the previous db? If not, you cannot solve too much. 

If you have managed hosting ask their support if they have a database backup for your domain.

Hi, i do not have the ps_image table in the SQL. I do have previous backups but in complete sql files.

What can the ps_image table be used for?

Link to comment
Share on other sites

Hi,

If you have backup you could try to restore the whole database and get back to the previous store data, but don't do anymore operations like regenerate images etc. because you will mess the product id  - image id relations (if you did not already mess that up)

Link to comment
Share on other sites

Reaching ps product ID limit is pretty rare ...

Never seen this before even on huge stores with more than 1M products.

Did you try to regenerate miniatures in backoffice, empty server cache and then reload to see changes ?

(If navigator cache enabled by 3rd party module, you must empty it before reloading as images paths are part of nav cache).

Ensure through Inspection Tool (in Chrome for exemple) that product image path is correct (ID, rewrite if used, etc.).

Link to comment
Share on other sites

17 hours ago, AfterGlow93 said:

Reaching ps product ID limit is pretty rare ...

Never seen this before even on huge stores with more than 1M products.

Did you try to regenerate miniatures in backoffice, empty server cache and then reload to see changes ?

(If navigator cache enabled by 3rd party module, you must empty it before reloading as images paths are part of nav cache).

Ensure through Inspection Tool (in Chrome for exemple) that product image path is correct (ID, rewrite if used, etc.).

I have used the supplier 9 digit product number as ID number. Now they have reached 10 digits

Yes, regenerate and empty server cache. No images

How can i know if 3rd party module cache is enabled?

When i export products from BO, the image link is not equal to the ID number. How can i change this?

Link to comment
Share on other sites

How and where creates the image link? And how and where to change it?

I have TRUNCATE the ps_image, ps_image_lang and ps_image_shop. Deleted images by csv import and created new also by csv import. But the image link and name is wrong. The new image is created as https://billigbyggemarked.dk/1/lang-bojning-90-sort-3-8-muffe-nippel.jpg, but the image name is 1.jpg When typing the link with the correct ID and name, the image does not show - https://billigbyggemarked.dk/1/1.jpg

Any help is appreciated

Link to comment
Share on other sites

Just now, Danmant_DK said:

How and where creates the image link? And how and where to change it?

I have TRUNCATE the ps_image, ps_image_lang and ps_image_shop. Deleted images by csv import and created new also by csv import. But the image link and name is wrong. The new image is created as https://billigbyggemarked.dk/1/lang-bojning-90-sort-3-8-muffe-nippel.jpg, but the image name is 1.jpg When typing the link with the correct ID and name, the image does not show - https://billigbyggemarked.dk/1/1.jpg

Any help is appreciated

Besides the 3 ps_image files above, I do only have ps_image_type

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...