Can't assign Products images

  • Posts: 5
  • Thank you received: 0
10 years 7 months ago #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

Last edit: 10 years 5 months ago by O87H_n4.

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
10 years 7 months ago #150404

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

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
10 years 7 months ago #150504

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 or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 7 months ago #151789

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: O87H_n4

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
10 years 7 months ago #153419

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: 10 years 5 months ago by O87H_n4.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #153440

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

The following user(s) said Thank You: O87H_n4

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
10 years 6 months ago #154171

Hi Nicolas.

e-mails were send..

Best regards.

Last edit: 10 years 6 months ago by O87H_n4. Reason: I was wrong

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #154249

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 or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
10 years 6 months ago #154322

Thanks guys.

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

Best regards.

Oscar

Please Log in or Create an account to join the conversation.

Time to create page: 0.076 seconds
Powered by Kunena Forum