Table 'shop_promo_rules' doesn't exist Есть решение

1

После обновления фреймворка перестал работать магазин

2019-12-03 18:07:51
Table 'shop_promo_rules' doesn't exist
## wa-system/database/waDbMysqliAdapter.class.php(491)
#0 wa-system/database/waDbMysqliAdapter.class.php(189): waDbMysqliAdapter->exception()
#1 wa-system/database/waModel.class.php(194): waDbMysqliAdapter->schema('shop_promo_rule...', false)
#2 wa-system/database/waModel.class.php(149): waModel->describe()
#3 wa-system/database/waModel.class.php(99): waModel->getFields()
#4 wa-system/database/waModel.class.php(78): waModel->getMetadata()
#5 wa-apps/shop/lib/classes/marketing/promo/shopPromoProductPrices.class.php(54): waModel->__construct()
#6 wa-apps/shop/lib/classes/marketing/promo/shopPromoProductPrices.class.php(125): shopPromoProductPrices->loadPromoPrices()
#7 wa-apps/shop/lib/classes/shopProductsCollection.class.php(1867): shopPromoProductPrices->workupPromoProducts(Array)
#8 wa-apps/shop/lib/classes/shopProductsCollection.class.php(1721): shopProductsCollection->workupProducts(Array, false)
#9 wa-apps/shop/plugins/yandexmarket/lib/actions/backend/shopYandexmarketPluginRun.controller.php(1632): shopProductsCollection->getProducts('*,count,id,fron...', 0, 500, false)
#10 wa-apps/shop/plugins/yandexmarket/lib/actions/backend/shopYandexmarketPluginRun.controller.php(1091): shopYandexmarketPluginRunController->stepProduct(0, Array, 0)
#11 wa-apps/shop/plugins/yandexmarket/lib/actions/backend/shopYandexmarketPluginRun.controller.php(996): shopYandexmarketPluginRunController->step()
#12 wa-apps/shop/plugins/yandexmarket/lib/actions/frontend/shopYandexmarketPluginFrontend.actions.php(26): shopYandexmarketPluginRunController->fastExecute(3)
#13 wa-system/controller/waActions.class.php(25): shopYandexmarketPluginFrontendActions->catalogAction()
#14 wa-system/controller/waActions.class.php(44): waActions->execute('catalog')
#15 wa-system/controller/waFrontController.class.php(263): waActions->run('catalog')
#16 wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(shopYandexmarketPluginFrontendActions), 'catalog')
#17 wa-system/controller/waFrontController.class.php(84): waFrontController->execute('yandexmarket', 'frontend', 'catalog')
#18 wa-system/waSystem.class.php(922): waFrontController->dispatch()
#19 wa-system/waSystem.class.php(596): waSystem->dispatchFrontend('yandexmarket/5c...')
#20 index.php(7): waSystem->dispatch()
#21 {main}

2 комментария

  • +3
    Михаил Ушенин Михаил Ушенин Webasyst 3 декабря 2019 18:31 #

    Выполните SQL-запрос с помощью phpMyAdmin в контрольной панели хостинга, чтобы добавить отсутствующую таблицу:

    CREATE TABLE `shop_promo_rules` (
      `id` int(11) UNSIGNED NOT NULL,
      `promo_id` int(10) UNSIGNED NOT NULL,
      `rule_type` varchar(32) NOT NULL,
      `rule_params` longtext
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    
    ALTER TABLE `shop_promo_rules`
      ADD PRIMARY KEY (`id`),
      ADD KEY `promo_id` (`promo_id`),
      ADD KEY `rule_type` (`rule_type`);
    
    ALTER TABLE `shop_promo_rules`
      MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

  • +1
    Владислав Владислав 6 декабря 2019 15:17 #

    Помогло. Спасибо!

    Добавить комментарий

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