Product missing after update the latest version

  • Posts: 20
  • Thank you received: 0
10 years 11 months ago #174561

-- url of the page with the problem -- : www.ierror.ch
-- HikaShop version -- : latest
-- Joomla version -- : 3.x.x

Hi together,

I had over 50 products on my WebShop.
After installing the latest version of HikaShop all products are gone. :(

So I set the Shop offline because the costumers shouldn't see the problem...


Thanks for help

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

  • Posts: 13201
  • Thank you received: 2322
10 years 11 months ago #174598

Hi,

Could you try to re install it ?
Are the categories still correct ? Please try to use the "rebuild" button present in the category listing.

And could you give us a screenshot of one product configuration ?

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

  • Posts: 20
  • Thank you received: 0
10 years 11 months ago #174697

Hi Xavier

Thanks for the answer :)

Everything is good except the products. The Kategirien are still correct.
I have no backup .. Should I still reinstall?

I have not found this rebuild button.


Attachments:
Last edit: 10 years 11 months ago by sommi.

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

  • Posts: 13201
  • Thank you received: 2322
10 years 11 months ago #174742

Hi,

You can do a backup now, and install HikaShop over the current version.

What was you previous version before updating ? 2.3.2 ?
I ask that because the 2.3.3 was just a security release so that should not impact the products.
If it was working in 2.3.2, that should work now unless you done something wrong.

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

  • Posts: 20
  • Thank you received: 0
10 years 11 months ago #174749

Hi,

Ok I try it.
I think it was 2.3.2

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

  • Posts: 20
  • Thank you received: 0
10 years 11 months ago #175011

It doesn't work.
I try it twice.. :(

What can I else do?

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

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 11 months ago #175013

Hi,

What do you mean with "gone" ?
The update can't delete a product, so I guess that the problem is link to the display.
Please check your products in the HikaShop backend and if possible, provide a screenshot and more details about them.
You deactivate the store but we don't have at this moment the possibility to check if the problem could come from a menu or a product listing module. We don't have any information about how your products are displayed.

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.

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

  • Posts: 20
  • Thank you received: 0
10 years 10 months ago #175430

Hi,

the products are away...
I don't know. Here are the picture.

I'v you want I can give you a backend account

regards,




Attachments:

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

  • Posts: 13201
  • Thank you received: 2322
10 years 10 months ago #175459

Hi,

Could you check via your phpMyAdmin interface if the entries are correct in the table "#__hikashop_product_category" ?

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

  • Posts: 20
  • Thank you received: 0
10 years 10 months ago #175584

Hi,

The file is there but I don't know if it is correct.

Attachments:

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

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 10 months ago #175607

Hi,

The table is the right one. You need to display the content of the tab (the first tab, near "Struture").
You will see the links between the products and the categories, you can make a search (using the "search" tab) in order to only display the lines with the product_id that you want to check (the id of the missing products).
If there is no entries for that products, if the table does not have links between products and categories, we will have to recreate them !
But first, we have to know the content of the table.

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.

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

  • Posts: 20
  • Thank you received: 0
10 years 10 months ago #175727

hello
Thank you for your response.
Unfortunately I am not familiar with MySql. And I'm still a beginner. I'm sending you a few pictures.
perhaps you can help me so.

Thanks again.








Attachments:

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

  • Posts: 20
  • Thank you received: 0
10 years 10 months ago #176026

After looking on the homepage I found some products. But these are not listed in the HikaShop component.

I made this product new:
www.ierror.ch/index.php/store-iphone-men...-4s-reparaturen.html

This one is not listed in the HikaShop but on the Page:
www.ierror.ch/index.php/store-ipad-menue...ckcover-wechsel.html

Why? How can that be?

Last edit: 10 years 10 months ago by sommi.

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

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 10 months ago #178427

Hi,

The table is the right one. You need to display the content of the tab (the first tab, near "Struture").

The tab name is "Anzeigen" ; it display the content of the database table ; allowing to see the different elements which symbolize the links between the product and the categories.

My idea was that some of your products does not have a link to a category anymore.
If a product does not have any link with a category ; HikaShop won't be able to display it under a category.
I created an issue for the HikaShop team in order to make a button to find the "lost" products and attach them to the "product category" category. I hope that such feature could help you (and other users).

But if my idea is right ; the reason why you should have lost these links is still a mystery.
There is no code in HikaShop why can do that except maybe a mass action...

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.

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

  • Posts: 20
  • Thank you received: 0
10 years 10 months ago #178574

hi Jerome

Thanks for the answer.

here is a picture from the tab "Anzeigen":





A button for this would be perfect. :-)

Attachments:
Last edit: 10 years 10 months ago by sommi.

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

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
10 years 10 months ago #178606

Hi,

Okay, it looks like you have very few product category links ; the table is not empty but we can make better tests.
Can you please click on the tab "SQL" and paste that query

SELECT p.* FROM `hjquf_hikashop_product` AS p 
LEFT JOIN `hjquf_hikashop_product_category` AS pc 
ON p.product_id = pc.product_id
WHERE p.product_type = 'main' AND pc.category_id IS NULL;
If the query return you some elements, these element will be the "lost" products.

So you will be able to use that query
INSERT INTO `hjquf_hikashop_product_category` (category_id, product_id, ordering)
SELECT 2, p.product_id, 1 FROM `hjquf_hikashop_product` AS p 
LEFT JOIN `hjquf_hikashop_product_category` AS pc 
ON p.product_id = pc.product_id
WHERE p.product_type = 'main' AND pc.category_id IS NULL;
and it will put every "lost" products into the category "product category" (which have by default the id "2").

It's not a real button but the effect will be quite the same :)

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: sommi

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

  • Posts: 20
  • Thank you received: 0
10 years 10 months ago #178620

Yeeees perfekt it Works!! Thanks a lot!! :cheer: :cheer:

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

Time to create page: 0.136 seconds
Powered by Kunena Forum