Error on creating new category

  • Posts: 2
  • Thank you received: 0
8 years 2 months ago #249708

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.5.38
-- Browser(s) name and version -- : Chrome 52.0.2743.116
-- Error-message(debug-mod must be tuned on) -- : Erreur lors de la sauvegarde

2 requêtes dupliquées: #15 #18

SELECT *
FROM _hikashop_category
WHERE category_id = '62'
LIMIT 1

Hello there,

Here's what i done: I edited a category by assigning it at the root by mistake ; actually, i wanted assign it in "product category".
Then, i read this topic and this , i changed the IDs category in database and rebuilt category tree in backend. Everything seems work except that i cannot create a new category anymore (saving an existing category works).
Debug mode shown me duplicated queries (please see in "Error message on the page" field above), but don't understand, i'm not a developer.

Help please.

Last edit: 8 years 2 months ago by hergy7.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 2 months ago #249717

Hi,

I'm afraid that if you just select a wrong parent category ; the easier would be to re-edit the category and change his parent.
By editing directly the data in the database I think you broke the nested set model tree and the "rebuild tree" cannot fix it.
en.wikipedia.org/wiki/Nested_set_model

Please revert the modifications you made in the database and check that the nested set model values are right.
Otherwise, you should delete all your categories and restart from a clean data (with correct IDs).

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.

Time to create page: 0.054 seconds
Powered by Kunena Forum