ошибка #500 после обновления ShopScript Есть решение

сегодня обновился 8.9.0.30 -> 8.21.0.49, после чего приложение Магазин в админке и фронтенд показывают #500

судя по ним, не хватает столбца available_for_sku в таблице shop_feature, но моих познаний не хватает, чтобы правильный запрос сделать. прошу помочь, логи прилагаю

db.log:

2021-11-29 16:56:59 92.248.140.153
Query Error 1054: Unknown column 'available_for_sku' in 'field list'
Query: UPDATE shop_feature SET available_for_sku = 1 WHERE code='weight'
## wa-system/database/waModel.class.php(266)
#0 wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), false)
#7 wa-system/waSystem.class.php(268): wa('shop')
#8 wa-system/config/waSystemConfig.class.php(622): waSystem->getCache('default', 'shop')
#9 wa-apps/installer/lib/classes/installerHelper.class.php(95): waSystemConfig->clearCache()
#10 wa-apps/installer/lib/actions/update/installerUpdateExecute.controller.php(254): installerHelper::flushCache()
#11 wa-apps/installer/lib/actions/update/installerUpdateExecute.controller.php(128): installerUpdateExecuteController->cleanup()
#12 wa-system/controller/waController.class.php(21): installerUpdateExecuteController->execute()
#13 wa-system/controller/waJsonController.class.php(28): waController->run(NULL)
#14 wa-system/controller/waFrontController.class.php(263): waJsonController->run(NULL)
#15 wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(installerUpdateExecuteController), NULL)
#16 wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'update', 'execute')
#17 wa-apps/installer/lib/classes/installerFrontController.class.php(10): waFrontController->dispatch()
#18 wa-system/controller/waDispatch.class.php(162): installerFrontController->dispatch()
#19 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/instal...')
#20 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#21 index.php(7): waSystem->dispatch()
#22 {main}

2021-11-29 16:57:00 92.248.140.153
Query Error 1054: Unknown column 'available_for_sku' in 'field list'
Query: UPDATE shop_feature SET available_for_sku = 1 WHERE code='weight'
## wa-system/database/waModel.class.php(266)
#0 wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), false)
#7 wa-system/waSystem.class.php(268): wa('shop')
#8 wa-system/config/waSystemConfig.class.php(622): waSystem->getCache('default', 'shop')
#9 wa-apps/installer/lib/classes/installerHelper.class.php(95): waSystemConfig->clearCache()
#10 wa-apps/installer/lib/actions/settings/installerSettingsClearCache.controller.php(20): installerHelper::flushCache()
#11 wa-system/controller/waController.class.php(21): installerSettingsClearCacheController->execute()
#12 wa-system/controller/waJsonController.class.php(28): waController->run(NULL)
#13 wa-system/controller/waFrontController.class.php(263): waJsonController->run(NULL)
#14 wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(installerSettingsClearCacheController), NULL)
#15 wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'settings', 'clearCache')
#16 wa-apps/installer/lib/classes/installerFrontController.class.php(10): waFrontController->dispatch()
#17 wa-system/controller/waDispatch.class.php(162): installerFrontController->dispatch()
#18 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/instal...')
#19 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#20 index.php(7): waSystem->dispatch()
#21 {main}

2021-11-29 16:57:03 92.248.140.153
Query Error 1054: Unknown column 'available_for_sku' in 'field list'
Query: UPDATE shop_feature SET available_for_sku = 1 WHERE code='weight'
## wa-system/database/waModel.class.php(266)
#0 wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), 1)
#7 wa-system/controller/waDispatch.class.php(146): wa('shop', 1)
#8 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/shop/')
#9 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#10 index.php(7): waSystem->dispatch()
#11 {main}

2021-11-29 16:57:05 92.248.140.153
Query Error 1054: Unknown column 'available_for_sku' in 'field list'
Query: UPDATE shop_feature SET available_for_sku = 1 WHERE code='weight'
## wa-system/database/waModel.class.php(266)
#0 wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 wa-system/routing/waRouting.class.php(318): waSystem::getInstance('shop', Object(shopConfig), true)
#7 wa-system/routing/waRouting.class.php(237): waRouting->getAppRoutes('shop', Array, true)
#8 wa-system/controller/waDispatch.class.php(282): waRouting->dispatch()
#9 wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('')
#10 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#11 index.php(7): waSystem->dispatch()
#12 {main}

и error.log

2021-11-29 16:56:59 92.248.140.153
Error running update of shop: /wa-apps/shop/lib/updates/8.10/1589384656.php
Database error. See log for details. (1054)
#0 /wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 /wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 /wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 /wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 /wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 /wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 /wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), false)
#7 /wa-system/waSystem.class.php(268): wa('shop')
#8 /wa-system/config/waSystemConfig.class.php(622): waSystem->getCache('default', 'shop')
#9 /wa-apps/installer/lib/classes/installerHelper.class.php(95): waSystemConfig->clearCache()
#10 /wa-apps/installer/lib/actions/update/installerUpdateExecute.controller.php(254): installerHelper::flushCache()
#11 /wa-apps/installer/lib/actions/update/installerUpdateExecute.controller.php(128): installerUpdateExecuteController->cleanup()
#12 /wa-system/controller/waController.class.php(21): installerUpdateExecuteController->execute()
#13 /wa-system/controller/waJsonController.class.php(28): waController->run(NULL)
#14 /wa-system/controller/waFrontController.class.php(263): waJsonController->run(NULL)
#15 /wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(installerUpdateExecuteController), NULL)
#16 /wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'update', 'execute')
#17 /wa-apps/installer/lib/classes/installerFrontController.class.php(10): waFrontController->dispatch()
#18 /wa-system/controller/waDispatch.class.php(162): installerFrontController->dispatch()
#19 /wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/instal...')
#20 /wa-system/waSystem.class.php(610): waDispatch->dispatch()
#21 /index.php(7): waSystem->dispatch()
#22 {main}

2021-11-29 16:57:00 92.248.140.153
Error running update of shop: /wa-apps/shop/lib/updates/8.10/1589384656.php
Database error. See log for details. (1054)
#0 /wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 /wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 /wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 /wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 /wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 /wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 /wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), false)
#7 /wa-system/waSystem.class.php(268): wa('shop')
#8 /wa-system/config/waSystemConfig.class.php(622): waSystem->getCache('default', 'shop')
#9 /wa-apps/installer/lib/classes/installerHelper.class.php(95): waSystemConfig->clearCache()
#10 /wa-apps/installer/lib/actions/settings/installerSettingsClearCache.controller.php(20): installerHelper::flushCache()
#11 /wa-system/controller/waController.class.php(21): installerSettingsClearCacheController->execute()
#12 /wa-system/controller/waJsonController.class.php(28): waController->run(NULL)
#13 /wa-system/controller/waFrontController.class.php(263): waJsonController->run(NULL)
#14 /wa-system/controller/waFrontController.class.php(190): waFrontController->runController(Object(installerSettingsClearCacheController), NULL)
#15 /wa-system/controller/waFrontController.class.php(84): waFrontController->execute(NULL, 'settings', 'clearCache')
#16 /wa-apps/installer/lib/classes/installerFrontController.class.php(10): waFrontController->dispatch()
#17 /wa-system/controller/waDispatch.class.php(162): installerFrontController->dispatch()
#18 /wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/instal...')
#19 /wa-system/waSystem.class.php(610): waDispatch->dispatch()
#20 /index.php(7): waSystem->dispatch()
#21 {main}

2021-11-29 16:57:03 92.248.140.153
Error running update of shop: /wa-apps/shop/lib/updates/8.10/1589384656.php
Database error. See log for details. (1054)
#0 /wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 /wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 /wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 /wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 /wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 /wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 /wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), 1)
#7 /wa-system/controller/waDispatch.class.php(146): wa('shop', 1)
#8 /wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/shop/')
#9 /wa-system/waSystem.class.php(610): waDispatch->dispatch()
#10 /index.php(7): waSystem->dispatch()
#11 {main}

2021-11-29 16:57:03 92.248.140.153
webasyst/shop/
Uncaught exception waException:
Error running update of application shop: /wa-apps/shop/lib/updates/8.10/1589384656.php (500)
## wa-system/config/waAppConfig.class.php(348)
#0 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#1 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#2 wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), 1)
#3 wa-system/controller/waDispatch.class.php(146): wa('shop', 1)
#4 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/shop/')
#5 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#6 index.php(7): waSystem->dispatch()
#7 {main}

Next waDbException with message 'Database error. See log for details.':
## wa-system/database/waModel.class.php(266)
#0 wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 wa-system/waSystem.class.php(1481): waSystem::getInstance('shop', Object(shopConfig), 1)
#7 wa-system/controller/waDispatch.class.php(146): wa('shop', 1)
#8 wa-system/controller/waDispatch.class.php(32): waDispatch->dispatchBackend('webasyst/shop/')
#9 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#10 index.php(7): waSystem->dispatch()
#11 {main}

2021-11-29 16:57:05 92.248.140.153
Error running update of shop: /wa-apps/shop/lib/updates/8.10/1589384656.php
Database error. See log for details. (1054)
#0 /wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 /wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 /wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 /wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 /wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 /wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 /wa-system/routing/waRouting.class.php(318): waSystem::getInstance('shop', Object(shopConfig), true)
#7 /wa-system/routing/waRouting.class.php(237): waRouting->getAppRoutes('shop', Array, true)
#8 /wa-system/controller/waDispatch.class.php(282): waRouting->dispatch()
#9 /wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('')
#10 /wa-system/waSystem.class.php(610): waDispatch->dispatch()
#11 /index.php(7): waSystem->dispatch()
#12 {main}

2021-11-29 16:57:05 92.248.140.153

Uncaught exception waException:
Error running update of application shop: /wa-apps/shop/lib/updates/8.10/1589384656.php (500)
## wa-system/config/waAppConfig.class.php(348)
#0 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#1 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#2 wa-system/routing/waRouting.class.php(318): waSystem::getInstance('shop', Object(shopConfig), true)
#3 wa-system/routing/waRouting.class.php(237): waRouting->getAppRoutes('shop', Array, true)
#4 wa-system/controller/waDispatch.class.php(282): waRouting->dispatch()
#5 wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('')
#6 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#7 index.php(7): waSystem->dispatch()
#8 {main}

Next waDbException with message 'Database error. See log for details.':
## wa-system/database/waModel.class.php(266)
#0 wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 wa-system/routing/waRouting.class.php(318): waSystem::getInstance('shop', Object(shopConfig), true)
#7 wa-system/routing/waRouting.class.php(237): waRouting->getAppRoutes('shop', Array, true)
#8 wa-system/controller/waDispatch.class.php(282): waRouting->dispatch()
#9 wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('')
#10 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#11 index.php(7): waSystem->dispatch()
#12 {main}

2021-11-29 16:57:14 144.76.36.146
Error running update of shop: /wa-apps/shop/lib/updates/8.10/1589384656.php
Database error. See log for details. (1054)
#0 /wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 /wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 /wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 /wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 /wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 /wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 /wa-system/routing/waRouting.class.php(318): waSystem::getInstance('shop', Object(shopConfig), true)
#7 /wa-system/routing/waRouting.class.php(237): waRouting->getAppRoutes('shop', Array, true)
#8 /wa-system/controller/waDispatch.class.php(282): waRouting->dispatch()
#9 /wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('product/olimp-l...')
#10 /wa-system/waSystem.class.php(610): waDispatch->dispatch()
#11 /index.php(7): waSystem->dispatch()
#12 {main}

2021-11-29 16:57:14 144.76.36.146
product/olimp-labs-kolagen-activ-plus-80-tab/
Uncaught exception waException:
Error running update of application shop: /wa-apps/shop/lib/updates/8.10/1589384656.php (500)
## wa-system/config/waAppConfig.class.php(348)
#0 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#1 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#2 wa-system/routing/waRouting.class.php(318): waSystem::getInstance('shop', Object(shopConfig), true)
#3 wa-system/routing/waRouting.class.php(237): waRouting->getAppRoutes('shop', Array, true)
#4 wa-system/controller/waDispatch.class.php(282): waRouting->dispatch()
#5 wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('product/olimp-l...')
#6 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#7 index.php(7): waSystem->dispatch()
#8 {main}

Next waDbException with message 'Database error. See log for details.':
## wa-system/database/waModel.class.php(266)
#0 wa-system/database/waModel.class.php(367): waModel->run('UPDATE shop_fea...')
#1 wa-apps/shop/lib/updates/8.10/1589384656.php(6): waModel->query('UPDATE shop_fea...')
#2 wa-system/config/waAppConfig.class.php(389): include('/var/www/sports...')
#3 wa-system/config/waAppConfig.class.php(341): waAppConfig->includeUpdate('/var/www/sports...')
#4 wa-apps/shop/lib/config/shopConfig.class.php(17): waAppConfig->checkUpdates()
#5 wa-system/waSystem.class.php(102): shopConfig->checkUpdates()
#6 wa-system/routing/waRouting.class.php(318): waSystem::getInstance('shop', Object(shopConfig), true)
#7 wa-system/routing/waRouting.class.php(237): waRouting->getAppRoutes('shop', Array, true)
#8 wa-system/controller/waDispatch.class.php(282): waRouting->dispatch()
#9 wa-system/controller/waDispatch.class.php(34): waDispatch->dispatchFrontend('product/olimp-l...')
#10 wa-system/waSystem.class.php(610): waDispatch->dispatch()
#11 index.php(7): waSystem->dispatch()
#12 {main}

2 ответа

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

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