What the *** did my client mess up? How to solve?

  • Posts: 246
  • Thank you received: 9
  • Hikashop Business Hikashop Essential
8 years 6 months ago #240491

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.6
-- Error-message(debug-mod must be tuned on) -- : Catgories messed up



I don't know what my client did, he wanted to seperate some categories and made new ones. Now it seems I have double listing(aliassen). See Image.

How can I restore to original?

So
  • ROOT
  • Product Catgories
  • Brand
Please help, don't know how to remove Spreien etc. Also can't find why it is displayed like this. The both Product Category have same content.

I'll keep on trying!
Attachments:
Last edit: 8 years 6 months ago by gasoline.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 6 months ago #240498

Hi,

Please go in "Products > Categories" and then click on the "rebuild" button that you will find in the toolbar.
It should fix the category tree structure.

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: 246
  • Thank you received: 9
  • Hikashop Business Hikashop Essential
8 years 6 months ago #240559

IHi Jerome,
I already did that, and tried again. Makes no difference.


I'll keep on trying!
Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 6 months ago #240601

Hi,

Then, open the hikashop_category table of the database via your phpMyAdmin. There, make sure that the category_parent_id of the categories not at the right place is equal to the category_id of their parent category.
Once that's done, click on the "rebuild" button and it should put everything back in place.

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

  • Posts: 246
  • Thank you received: 9
  • Hikashop Business Hikashop Essential
8 years 6 months ago #240634

Hi Nicolas,

Thanks for your comment. If it was HTML, CSS or even JS I could follow you, but MySQL is a bit difficult for me. I tried several things but did not work. In the images the 2 lines (I Assume) where the problem lays (ROOT & Spreien)

Could you please suggest which columns I should alter and with what numbers. That would be awesome.




PS
Hi Nicolas,
I changed ROOT to 0 and removed spreien. Now I got this, does that look good to you?


I'll keep on trying!
Attachments:
Last edit: 8 years 6 months ago by gasoline. Reason: changed dbase info

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 6 months ago #240656

Hi,

Yes. That looks great now.
I guess that the problem is solved now.
It seems that the spreien category had been placed as parent of the root category and thus it messed the category tree.

The following user(s) said Thank You: gasoline

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

  • Posts: 246
  • Thank you received: 9
  • Hikashop Business Hikashop Essential
8 years 6 months ago #240667

Hi Nicolas,

Still don't know how my client did it (will speak to him later today), but appearantly the solution was to make ROOT category_parent_id 0. After that I was able to delete the Spreien (only from dbase).

Site works fine now so problem seems to be solved. Very happy with that. Thanks for the support.

I'll keep on trying!
Last edit: 8 years 6 months ago by gasoline.

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

Time to create page: 0.084 seconds
Powered by Kunena Forum