Skip to main content

Error on creating new category

More
10 years 3 weeks ago - 10 years 3 weeks ago #249708 by hergy7
-- 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: 10 years 3 weeks ago by hergy7.

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

More
10 years 3 weeks ago #249717 by Jerome
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.

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

Time to create page: 0.181 seconds
Powered by Kunena Forum