Can't assign Products images

-- 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.

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

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,

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

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

Hi Nicolas.

e-mails were send..

Best regards.

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.

Thanks guys.

Don't know why, but it is working now, and we can go forward.

Best regards.

Oscar