[Skip to main content](#vessel-content) # Can't assign Products images ## - **[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")** - [![O87H_n4's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Topic Author - [ Offline](/forum/user/29280-o87h-n4) Less More - Posts: 5 - Thank you received: 0 - - 12 years 6 months ago - 12 years 4 months ago [\#150356](#150356) by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#150356 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* was created by *[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")* -- url of the page with the problem -- : [ www.casadeltennis.com](http://www.casadeltennis.com) -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file Last edit: 12 years 4 months ago by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 6 months ago [\#150404](#150404) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#150404 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* I just tested it and it worked fine, so can you : - Active the Joomla debug mode ("Administration->Global configuration->System->Debug System/Language") - Set the "error reporting" option of the Joomla configuration to "maximum" - Test it again so that we can see if it display an error message through your product page. The following user(s) said Thank You: [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")** - [![O87H_n4's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Topic Author - [ Offline](/forum/user/29280-o87h-n4) Less More - Posts: 5 - Thank you received: 0 - - 12 years 6 months ago [\#150504](#150504) by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Replied by *[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#150504 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* Hi Mr Mohamed. Debug Mode and Error display are now enabled. The following proccess was performed. 1. All products were deleted. 2. One New product was uploaded trough CSV import 3. An image was uploaded to the product trough Hikashop upload tool 4. Save& close operation performed. I realize that one of the database opperations shows a delete statement at hikashop_file table, not sure if just temporary info was deleted or if information regarding product image was deleted. 50. **Query Time: 0.54 ms** **After last query: 9.95 ms** DELETE   FROM jos_hikashop_file   WHERE file_ref_id = 413   AND file_type='product'   AND SUBSTRING(file_path,1,1) != '@'   AND file_id NOT IN (4018) **Explain** **Profile** **Call Stack** Best regards. Oscar Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 6 months ago [\#151789](#151789) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#151789 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* Hi, The SQL request you pasted is a query which delete "other" products images. Like you can see, the last line said that the "file_id" should not be "4018". It is the image that the product will kept. I checked your screenshot which gave some information but unfortunately, not enough. We can't know when the screenshot have been made, we don't have full data. The two first screenshot talk about the product "413" but the database does not show any information for this product (file_ref_id). But I can see an image which does not have product assigned (where file_ref_id is 0). Is it possible to have the data for the product 413 just after the CSV import ? At this moment we might be able to understand why the image is removed. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")** - [![O87H_n4's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Topic Author - [ Offline](/forum/user/29280-o87h-n4) Less More - Posts: 5 - Thank you received: 0 - - 12 years 6 months ago - 12 years 4 months ago [\#153419](#153419) by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Replied by *[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#153419 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* Thanks Mr Jerome. Don't know why attachements didn't upload lasta time, please find them here. I'm currently uploading 147 products information trought CSV, and images trough FTP. If need me to do anything else please let me know, this is of the most importance for us. Also, all information regarding products characteristics were uploaded, in order to perform product comparrison, but doesn't work, I'll take a look to other cases, before create a new case. Thanks a lot. Oscar Last edit: 12 years 4 months ago by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 12 years 6 months ago [\#153440](#153440) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#153440 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* Hi, Unfortunately, that doesn't provide relevant information. Let's do differently. Please provide the CSV that you're using, step by step instructions of what you're doing, indicating the relative issue, and a backend access to your website so that we can reproduce the issue. You can use our contact form for the backend access: [ www.hikashop.com/contact-us.html](http://www.hikashop.com/contact-us.html) The following user(s) said Thank You: [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")** - [![O87H_n4's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Topic Author - [ Offline](/forum/user/29280-o87h-n4) Less More - Posts: 5 - Thank you received: 0 - - 12 years 5 months ago - 12 years 5 months ago [\#154171](#154171) by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Replied by *[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#154171 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* Hi Nicolas. e-mails were send.. Best regards. Last edit: 12 years 5 months ago by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile"). Reason: I was wrong Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 12 years 5 months ago [\#154249](#154249) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#154249 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* Hi, I got the access and the CSV. I did some tests with the products and I was able to upload images, attach them to products via the interface and via the CSV import. The CSV looks good too. I was also able to delete the products I had created and it successfully deleted the images of these products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")** - [![O87H_n4's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Topic Author - [ Offline](/forum/user/29280-o87h-n4) Less More - Posts: 5 - Thank you received: 0 - - 12 years 5 months ago [\#154322](#154322) by [O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile") Replied by *[O87H\_n4](/forum/user/29280-o87h-n4 "View O87H_n4's Profile")* on topic *[Can't assign Products images](/forum/37-import-export-csv-xls/867067-cant-assign-products-images#154322 "-- url of the page with the problem -- : www.casadeltennis.com -- HikaShop version -- : HikaShop Business: 2.3.0 -- Joomla version -- : Joomla! 3.2.3 -- PHP version -- : 5.2.17 -- Browser(s) name and version -- : Google Chrome 33.0.1750.154 m -- Error-message(debug-mod must be tuned on) -- : already existing products Hi. I have been trying to upload products trought CSV, but have the foollowing issues *When create a product manually, I upload the image file, but as soon as save the product, image gets deleted from "HikaShop Images" folder. *No matter if products get deleted, when Import from csv message says, "already existing products". *Table "jos_hikashop_file" on database, has all products image file-names, even after delete products. *both joomla and hikashop were updated, but when check database the following message is shown. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3). Attachments: *adding_product_image *Product_list_after_save (no image shown) *jos_hikashop_file table_image (contains deleted products info). *CSV file")* Thanks guys. Don't know why, but it is working now, and we can go forward. Best regards. Oscar Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjcwNjctY2FudC1hc3NpZ24tcHJvZHVjdHMtaW1hZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.155 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)