Error Message in the Configuration

  • Posts: 73
  • Thank you received: 0
7 years 4 months ago #274864

-- url of the page with the problem -- : www.sokart.ch
-- HikaShop version -- : HikaShop Business 3.1.1 [1707191036]
-- Joomla version -- : 3.7.4
-- PHP version -- : 5.6
-- Browser(s) name and version -- : Firefox 54.0.1 (32-Bit)
-- Error-message(debug-mod must be tuned on) -- : Error
It appears the root category has been deleted. That category shouldn't be removed as it is crucial to the proper functioning of the category system. Please click on the "check datbaase" button of the toolbar which will restore it.

Hello

After update from HikaShop Business 2.6.4 [1610211750]

When start HikaShop > System > Configuration then error.
---
Error
It appears the root category has been deleted. That category shouldn't be removed as it is crucial to the proper functioning of the category system. Please click on the "check datbaase" button of the toolbar which will restore it.
---

"Root" category exists!

Greetings
Petar Ristanovic

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

  • Posts: 73
  • Thank you received: 0
7 years 4 months ago #274870

In the meantime I updated the PHP to V7.x
-- PHP version -- : 5.6

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 4 months ago #274873

Hello,

Are you really sure that your root category is right has it should be ?

SELECT category_id FROM hikashop_category WHERE category_type = 'root' AND category_parent_id = 0

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: 73
  • Thank you received: 0
7 years 3 months ago #274926

Hello

This response (table prefix added) was empty and there isn't "category_type = 'root'" and "category_parent_id = 0"!

How may I fix it?

Regards
PR

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #274928

Hello,

Just quoting the message you got:

When start HikaShop > System > Configuration then error.
---
Error
It appears the root category has been deleted. That category shouldn't be removed as it is crucial to the proper functioning of the category system. Please click on the "check database" button of the toolbar which will restore it.
---


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: 73
  • Thank you received: 0
7 years 3 months ago #274972

Hello

I already (days ago) clicked "Check database", all tables are "OK" but the message still appears. That is the cause I generated the ticket?

Regards
PR

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #274985

Hello,

You should have precise it in your first message.
So there is something missing in the check database for the restore of the root category in your specific case.

Please process that SQL query in your PHPMyAdmin (just replace the " #_ " with your database prefix).

INSERT IGNORE INTO `#__hikashop_category` (`category_id`, `category_parent_id`, `category_type`, `category_name`, `category_description`, `category_published`, `category_ordering`, `category_left`, `category_right`, `category_depth`, `category_namekey`) VALUES (1, 0, 'root', 'ROOT', '', 0, 0, 1, 22, 0, 'root'),(2, 1, 'product', 'product category', '', 1, 1, 2, 3, 1, 'product'),(3, 1, 'tax', 'taxation category', '', 1, 2, 4, 7, 1, 'tax');
Afterwards you might need to perform a "rebuild tree" via the HikaShop category listing toolbar.

But if you have purge your hikashop_category table ; I'm afraid that you might have other side effects.

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: 73
  • Thank you received: 0
7 years 3 months ago #275403

Hello

On "Afterwards you might need to perform a "rebuild tree" via the HikaShop category listing toolbar." I got following error message (before and after execution of recommended SQL script):
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

And Error
---
It appears the root category has been deleted. That category shouldn't be removed as it is crucial to the proper functioning of the category system. Please click on the "check datbaase" button of the toolbar which will restore it.
---
still appears in Configuration.

Regards,
PR

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 3 months ago #275417

Hello,

Please provide concret details about the content in your "hikashop_category" 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: 73
  • Thank you received: 0
7 years 3 months ago #275463

Hi

It's attached...

Regards, PR

Attachments:

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
7 years 3 months ago #275466

Hi,

The problem is indeed the ROOT category there.
It's category_parent_id is linked to a category with the id 133 which doesn't exist instead of being 0 and its category_type should be "root" instead of "product".
Please change these for that entry, then use the "rebuild" button of the categories listing and it should all work fine again.

The following user(s) said Thank You: sokartch

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

  • Posts: 73
  • Thank you received: 0
7 years 3 months ago #275519

Ok, it seems to work. Thank you!

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

Time to create page: 0.075 seconds
Powered by Kunena Forum