Fehlermeldung seit Update auf 1.7.5

[Heikman]

hallo zusammen, ich habe ein Problem seit dem update auf Version 1.7.5.
Die folgende Fehlermeldung erscheint wenn ich meinen Webshop aufrufen will:
Was kann ich tun um das Problem zu lösen? Vielen Dank im Voraus und einen schönen Heiligabend.

[PrestaShopDatabaseException]

Unknown column 'location' in 'field list'
 

SELECT location
FROM `othe_stock_available`
WHERE (id_product = 34) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1

at line 769 in file classes/db/Db.php

 

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768.             if ($sql) {
769.                 throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770.             }
771. 
772.             throw new PrestaShopDatabaseException($this->getMsgError());
773.         }
774.     }

• DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 663 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 697 - classes/db/Db.php] - [2 Arguments]
• DbCore->getValue - [line 782 - classes/stock/StockAvailable.php] - [1 Arguments]

  Argument [0]
  SELECT location
  FROM `othe_stock_available`
  WHERE (id_product = 34) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0)
  
  

• StockAvailableCore::getLocation - [line 6522 - classes/Product.php] - [1 Arguments]
• ProductCore->loadStockData - [line 164 - classes/Pack.php]
• PackCore::getItems - [line 131 - classes/Pack.php]- [2 Arguments]
• PackCore::noPackPrice - [line 4853 - classes/Product.php] - [1 Arguments]
• ProductCore::getProductProperties - [line 4924 - classes/Product.php] - [2 Arguments]
• ProductCore::getProductsProperties - [line 1021 - classes/Category.php] - [2 Arguments]
• CategoryCore->getProducts - [line 79 - src/Adapter/Category/CategoryProductSearchProvider.php] - [9 Arguments]
• PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->getProductsOrCount - [line 105 - src/Adapter/Category/CategoryProductSearchProvider.php] - [3 Arguments]
• PrestaShop\PrestaShop\Adapter\Category\CategoryProductSearchProvider->runQuery - [line 299 - modules/ps_featuredproducts/ps_featuredproducts.php] - [2 Arguments]
• Ps_FeaturedProducts->getProducts - [line 257 - modules/ps_featuredproducts/ps_featuredproducts.php]
• Ps_FeaturedProducts->getWidgetVariables - [line 243 - modules/ps_featuredproducts/ps_featuredproducts.php] - [2 Arguments]
• Ps_FeaturedProducts->renderWidget - [line 971 - classes/Hook.php] - [2 Arguments]
• HookCore::coreRenderWidget - [line 923 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments]
• IndexControllerCore->initContent - [line 281 - classes/controller/Controller.php]
• ControllerCore->run - [line 509 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

[Heikman]

4 hours ago, Crezzur said:

Your database table "othe_stock_available" does not have a row called " location " import it from your MYSQL backup.

thank you very much... but how can I do that in the PHPmyAdmin?

[Heikman]

I have this new error when I try to update to 1.7.5. Can anyone help please?

[INTERNAL] /hp/bh/aa/ak/www/moviepropstore/shop/app/AppKernel.php line 60 - Error: Class 'League\Tactician\Bundle\TacticianBundle' not found #0 /hp/bh/aa/ak/www/moviepropstore/shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(488): AppKernel->registerBundles() #1 /hp/bh/aa/ak/www/moviepropstore/shop/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(132): Symfony\Component\HttpKernel\Kernel->initializeBundles() #2 /hp/bh/aa/ak/www/moviepropstore/shop/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php(148): Symfony\Component\HttpKernel\Kernel->boot() #3 /hp/bh/aa/ak/www/moviepropstore/shop/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php(135): Symfony\Bundle\FrameworkBundle\Console\Application->registerCommands() #4 /hp/bh/aa/ak/www/moviepropstore/shop/src/PrestaShopBundle/Service/Database/Upgrade.php(40): Symfony\Bundle\FrameworkBundle\Console\Application->add(Object(PrestaShopBundle\Command\UpdateSchemaCommand)) #5 /hp/bh/aa/ak/www/moviepropstore/shop/modules/autoupgrade/classes/UpgradeTools/SymfonyAdapter.php(74): PrestaShopBundle\Service\Database\Upgrade->addDoctrineSchemaUpdate() #6 /hp/bh/aa/ak/www/moviepropstore/shop/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader17.php(54): PrestaShop\Module\AutoUpgrade\UpgradeTools\SymfonyAdapter->runSchemaUpgradeCommand() #7 /hp/bh/aa/ak/www/moviepropstore/shop/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(81): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader17->upgradeDb('1.7.4.4') #8 /hp/bh/aa/ak/www/moviepropstore/shop/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(41): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade() #9 /hp/bh/aa/ak/www/moviepropstore/shop/qc5shpqsedfd5jzq/autoupgrade/ajax-upgradetab.php(52): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #10 {main}

[carras]

Hi there,

 

Were you able to solve this? I think I have the same error.

 

Thanks.