- Posts: 2
- Thank you received: 0
Error on creating new category
10 years 3 weeks ago - 10 years 3 weeks ago #249708
by hergy7
Error on creating new category was created 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.
-- 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.
10 years 3 weeks ago #249717
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Error on creating new category
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,
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