- Posts: 25
- Thank you received: 2
Explorer
10 years 9 months ago - 10 years 9 months ago #224916
by NeleU
Replied by NeleU on topic Explorer: root below category?
Did something wrong when making a new category (named 'lichaamsverzorging'): root is now under the new category - seems not to be normal (see attachement)? This category 'lichaamsverzorging' has to be on the same level as the category 'geneesmiddel' and 'hygiene'.
Cannot remove this category 'lichaamsverzorging'
Tried already to rebuild the category listing, without succes.
Cannot remove this category 'lichaamsverzorging'
Tried already to rebuild the category listing, without succes.
Last edit: 10 years 9 months ago by NeleU. Reason: new title
Please Log in or Create an account to join the conversation.
10 years 9 months ago #224969
by nicolas
Replied by nicolas on topic Explorer: root below category?
Hi,
I've never seen that.
You'll have to edit the hikashop_category table directly via your phpmyadmin and delete that category.
Then, go in the categories listing and click on the "rebuild" button.
You can also click on the "check database" button of the hikaShop configuration.
That should hopefully be enough.
Then, just create your category again in the category where you want it.
I've never seen that.
You'll have to edit the hikashop_category table directly via your phpmyadmin and delete that category.
Then, go in the categories listing and click on the "rebuild" button.
You can also click on the "check database" button of the hikaShop configuration.
That should hopefully be enough.
Then, just create your category again in the category where you want it.
Please Log in or Create an account to join the conversation.
10 years 9 months ago #224974
by NeleU
Replied by NeleU on topic Explorer: root below category?
Hello,
Removed from the database, check database performed in hikashop --> no errors (everything OK)
Rebuild in categories: ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1 SQL=UPDATE persyn_hikashop_category SET category_left=1, category_right=2, category_depth=0 WHERE category_id = LIMIT 1
Please help,
Nele
Removed from the database, check database performed in hikashop --> no errors (everything OK)
Rebuild in categories: ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1 SQL=UPDATE persyn_hikashop_category SET category_left=1, category_right=2, category_depth=0 WHERE category_id = LIMIT 1
Please help,
Nele
Please Log in or Create an account to join the conversation.
10 years 9 months ago #224989
by nicolas
Replied by nicolas on topic Explorer: root below category?
Hi,
Edit the hikashop_category table and check the root category. It should be the first entry. It should have a category_parent_id set to 0. If that's not the case, such issue could happen.
Edit the hikashop_category table and check the root category. It should be the first entry. It should have a category_parent_id set to 0. If that's not the case, such issue could happen.
The following user(s) said Thank You: NeleU
Please Log in or Create an account to join the conversation.
10 years 9 months ago #225094
by NeleU
Replied by NeleU on topic Explorer: root below category?
Great, it works! The difference between a 0 and a 1 is ∞.
Many thanks!
Many thanks!
Please Log in or Create an account to join the conversation.
Time to create page: 0.200 seconds