Query Error 1137

Очередная, не очень понятная ошибка в бд. 

Если ктонибудь подскажет - какой это плагин "косячит" или в чем дело - буду сильно благодарен )

2019-10-21 21:32:07 188.127.236.17
Query Error 1137: Can't reopen table: 'pppt1'
Query: SELECT c1.*,  ipppptiiii1.count 
FROM shop_product p
        LEFT JOIN shop_product_promo_price_tmp pppt1
                ON p.id = pppt1.product_id AND p.sku_id = pppt1.sku_id AND pppt1.storefront = 'www.petxp.ru'
        left JOIN shop_category c1
                ON p.category_id = c1.id
        left JOIN  (SELECT p.category_id, COUNT(p.id) AS count FROM shop_product p
        LEFT JOIN shop_product_promo_price_tmp pppt1
                ON p.id = pppt1.product_id AND p.sku_id = pppt1.sku_id AND pppt1.storefront = 'www.petxp.ru'
WHERE p.status = 1
        AND p.id IN (14113,7545,7544,14114,9013)
GROUP BY p.category_id )  ipppptiiii1
                ON p.category_id =  ipppptiiii1.category_id
WHERE p.status = 1
        AND p.id IN (14113,7545,7544,14114,9013)
GROUP BY p.category_id
## wa-system/database/waModel.class.php(257)
#0 wa-system/database/waModel.class.php(357): waModel->run('SELECT c1.*,  i...')
#1 wa-apps/shop/plugins/searchpro/lib/classes/util/shopSearchproUtil.class.php(90): waModel->query('SELECT c1.*,  i...')
#2 wa-apps/shop/plugins/searchpro/lib/actions/frontend/shopSearchproPluginFrontendPage.action.php(447): shopSearchproUtil->getCollectionCategories(Object(shopProductsCollection))
#3 wa-apps/shop/plugins/searchpro/lib/actions/frontend/shopSearchproPluginFrontendPage.action.php(423): shopSearchproPluginFrontendPageAction->getCategories()
#4 wa-apps/shop/plugins/searchpro/lib/actions/frontend/shopSearchproPluginFrontendPage.action.php(367): shopSearchproPluginFrontendPageAction->workupCategories()
#5 wa-apps/shop/plugins/searchpro/lib/actions/frontend/shopSearchproPluginFrontendPage.action.php(247): shopSearchproPluginFrontendPageAction->executeDefault()
#6 wa-system/controller/waViewAction.class.php(160): shopSearchproPluginFrontendPageAction->execute()
#7 wa-apps/shop/lib/actions/frontend/shopFrontend.action.php(139): waViewAction->display(false)
#8 wa-system/controller/waViewController.class.php(86): shopFrontendAction->display()
#9 wa-system/controller/waDefaultViewController.class.php(48): waViewController->executeAction(Object(shopSearchproPluginFrontendPageAction))
#10 wa-system/controller/waController.class.php(21): waDefaultViewController->execute()
#11 wa-system/controller/waViewController.class.php(46): waController->run(NULL)
#12 wa-system/controller/waFrontController.class.php(255): waViewController->run(NULL)
#13 wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(waDefaultViewController), NULL)
#14 wa-system/controller/waFrontController.class.php(84): waFrontController->execute('searchpro', 'frontend', 'page')
#15 wa-system/waSystem.class.php(884): waFrontController->dispatch()
#16 wa-system/waSystem.class.php(578): waSystem->dispatchFrontend('search/118/%D0%...')
#17 index.php(7): waSystem->dispatch()
#18 {main}

1 ответ

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

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