как удалить категории

Здравствуйте, удалил все товары с сайта, а категории остались, пытаюсь их удалить , пишет ошибку: 

Query Error 1062: Duplicate entry 'malyarnye-kisti' for key 'full_url'
Query: UPDATE shop_category
SET `full_url` = 'malyarnye-kisti'
WHERE `id` = '2912' code 1062

# wa-system/database/waModel.class.php(266) #0 wa-system/database/waModel.class.php(321): waModel->run('UPDATE shop_cat...') #1 wa-system/database/waModel.class.php(444): waModel->exec('UPDATE shop_cat...') #2 wa-system/database/waModel.class.php(385): waModel->updateByField('id', 'malyarnye-kisti', Array, NULL, false) #3 wa-apps/shop/lib/model/shopCategory.model.php(512): waModel->updateById('2912', Array) #4 wa-apps/shop/lib/model/shopCategory.model.php(255): shopCategoryModel->correctFullUrlOfDescendants(Array, 'malyarnye-kisti') #5 wa-apps/shop/lib/actions/products/shopProductsDeleteList.controller.php(80): shopCategoryModel->delete(3800) #6 wa-apps/shop/lib/actions/products/shopProductsDeleteList.controller.php(14): shopProductsDeleteListController->deleteList(Array) #7 wa-system/controller/waController.class.php(21): shopProductsDeleteListController->execute() #8 wa-system/controller/waJsonController.class.php(28): waController->run(NULL) #9 wa-system/controller/waFrontController.class.php(263): waJsonController->run(NULL) #10 wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(shopProductsDeleteListController), NULL) #11 wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'products', 'deleteList') #12 wa-system/controller/waDispatch.class.php(157): waFrontController->dispatch() #13 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('super-guper2020...') #14 wa-system/waSystem.class.php(603): waDispatch->dispatch() #15 index.php(7): waSystem->dispatch() #16 {main}
GET
[  'module' => 'products',  'action' => 'deleteList', ]
POST
[  'hash' => 'category/3800',  'remove' => [    0 => 'list',  ],  '_csrf' => '[hidden]', ]
Params
[]
ПОДСКАЖИТЕ ПОЖАЛУЙСТА КАК БЫТЬ?

1 ответ

Добавить ответ

Чтобы добавить комментарий, зарегистрируйтесь или войдите