Danmant_DK Posted November 22 Share Posted November 22 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 More sharing options...
Prestashop Addict Posted November 22 Share Posted November 22 Hi, bad news, if you import directly products it creates new ids, and relation image product table is out of integrity with orphans ids! Link to comment Share on other sites More sharing options...
Danmant_DK Posted November 22 Author Share Posted November 22 10 hours ago, Prestashop Addict said: Hi, bad news, if you import directly products it creates new ids, and relation image product table is out of integrity with orphans ids! How can i fix this? Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted November 23 Share Posted November 23 (edited) 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 November 23 by QuickUpdate.net (see edit history) 1 Link to comment Share on other sites More sharing options...
Danmant_DK Posted November 23 Author Share Posted November 23 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 More sharing options...
Danmant_DK Posted November 24 Author Share Posted November 24 I have deleted all products (in the csv import back office) and importet all with images again. Still no images in front. There are images in back office Link to comment Share on other sites More sharing options...
QuickUpdate.net Posted November 24 Share Posted November 24 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 More sharing options...
AfterGlow93 Posted November 24 Share Posted November 24 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 More sharing options...
Danmant_DK Posted November 25 Author Share Posted November 25 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 More sharing options...
Danmant_DK Posted November 27 Author Share Posted November 27 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 More sharing options...
Danmant_DK Posted November 27 Author Share Posted November 27 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 More sharing options...
Danmant_DK Posted November 30 Author Share Posted November 30 When user friendly url is deactivated, images are shown. How can i have user friendly url activated and images shown? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now