Dzień dobry,

po aktualizacji z 1.7.4.1 do 1.7.5.1 Presta ma problem z zapisem ilości produktów. Aktualizacja była przeprowadzona przez Installatron z Direct Admina, bo 1 Click Upgrade się wieszał. Niezależnie czy tworzę nowy produkt czy edytuję istniejący, po dodaniu ilości produktu i kliknięciu zapisz, mimo komunikatu o powodzeniu ilość nadal jest taka sama. Próbowałem czyścić cache sklepu i przeglądarki. Po włączeniu trybu debugowania otrzymuję taki błąd zaraz po wejściu w produkt:
 

Quote

Nieznana kolumna 'location' w field list<br /><br /><pre>SELECT location
FROM `pr_stock_available`
WHERE (id_product = 560) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1</pre>

Quote

PrestaShopDatabaseException

in classes/db/Db.php (line 769)

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.             }
772.             throw new PrestaShopDatabaseException($this->getMsgError());
773.         }
774.     }

DbCore->displayError('SELECT locationFROM `pr_stock_available`WHERE (id_product = 560) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1')in classes/db/Db.php (line 385)

380.                 $this->result = $this->_query($sql);
381.             }
382.         }
384.         if (_PS_DEBUG_SQL_) {
385.             $this->displayError($sql);
386.         }
388.         return $this->result;
389.     }

DbCore->query('SELECT locationFROM `pr_stock_available`WHERE (id_product = 560) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1')in classes/db/Db.php (line 663)

659.                 return $result;
660.             }
661.         }
663.         $this->result = $this->query($sql);
664.         if (!$this->result) {
665.             $result = false;
666.         } else {
667.             $result = $this->nextRow($this->result);
668.         }

DbCore->getRow('SELECT locationFROM `pr_stock_available`WHERE (id_product = 560) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1', true)in classes/db/Db.php (line 697)

692.     {
693.         if ($sql instanceof DbQuery) {
694.             $sql = $sql->build();
695.         }
697.         if (!$result = $this->getRow($sql, $use_cache)) {
698.             return false;
699.         }
701.         return array_shift($result);
702.     }

DbCore->getValue('SELECT locationFROM `pr_stock_available`WHERE (id_product = 560) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0)')in classes/stock/StockAvailable.php (line 782)

777.         $query->where('id_product = ' . $id_product);
778.         $query->where('id_product_attribute = ' . $id_product_attribute);
780.         $query = StockAvailable::addSqlShopRestriction($query, $id_shop);
782.         return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
783.     }
785.     /**
786.      * Add an sql restriction for shops fields - specific to StockAvailable.
787.      *

StockAvailableCore::getLocation(560)in classes/Product.php (line 6522)

6518.         // Default product quantity is available quantity to sell in current shop
6519.         $this->quantity = StockAvailable::getQuantityAvailableByProduct($this->id, 0);
6520.         $this->out_of_stock = StockAvailable::outOfStock($this->id);
6521.         $this->depends_on_stock = StockAvailable::dependsOnStock($this->id);
6522.         $this->location = StockAvailable::getLocation($this->id);
6524.         if (Context::getContext()->shop->getContext() == Shop::CONTEXT_GROUP && Context::getContext()->shop->getContextShopGroup()->share_stock == 1) {
6525.             $this->advanced_stock_management = $this->useAdvancedStockManagement();
6526.         }
6527.     }

ProductCore->loadStockData()in src/PrestaShopBundle/Model/Product/AdminModelAdapter.php (line 443)

438.      *
439.      * @return array Transformed model data to form attempt
440.      */
441.     public function getFormData(Product $product)
442.     {
443.         $product->loadStockData();
444.         $this->productPricePriority = $this->adminProductWrapper->getPricePriority($product->id);
446.         $this->formData['id_product'] = $product->id;
447.         $this->formData['step1'] = $this->mapStep1FromData($product);
448.         $this->formData['step2'] = $this->mapStep2FormData($product);

AdminModelAdapter->getFormData(object(Product))in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 661)

656.      * @throws \Symfony\Component\Process\Exception\LogicException
657.      */
658.     private function createProductForm(Product $product, AdminModelAdapter $modelMapper)
659.     {
660.         $formBuilder = $this->createFormBuilder(
661.             $modelMapper->getFormData($product),
662.             ['allow_extra_fields' => true]
663.         )
664.             ->add('id_product', HiddenType::class)
665.             ->add('step1', ProductInformation::class)
666.             ->add('step2', ProductPrice::class, ['id_product' => $product->id])

ProductController->createProductForm(object(Product), object(AdminModelAdapter))in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 452)

447.         $isMultiShopContext = count($shopContext->getContextListShopID()) > 1;
449.         $modelMapper = $this->get('prestashop.adapter.admin.model.product');
450.         $adminProductWrapper = $this->get('prestashop.adapter.admin.wrapper.product');
452.         $form = $this->createProductForm($product, $modelMapper);
454.         $formBulkCombinations = $this->createForm(
455.             ProductCombinationBulk::class,
456.             null,
457.             [

ProductController->formAction('560', object(Request))in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)

146.         $this->dispatcher->dispatch(KernelEvents::CONTROLLER_ARGUMENTS, $event);
147.         $controller = $event->getController();
148.         $arguments = $event->getArguments();
150.         // call controller
151.         $response = \call_user_func_array($controller, $arguments);
153.         // view
154.         if (!$response instanceof Response) {
155.             $event = new GetResponseForControllerResultEvent($this, $request, $type, $response);
156.             $this->dispatcher->dispatch(KernelEvents::VIEW, $event);

HttpKernel->handleRaw(object(Request), 1)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)

63.     public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
64.     {
65.         $request->headers->set('X-Php-Ob-Level', ob_get_level());
67.         try {
68.             return $this->handleRaw($request, $type);
69.         } catch (\Exception $e) {
70.             if ($e instanceof RequestExceptionInterface) {
71.                 $e = new BadRequestHttpException($e->getMessage(), $e);
72.             }
73.             if (false === $catch) {

HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)

195.         $this->boot();
196.         ++$this->requestStackSize;
197.         $this->resetServices = true;
199.         try {
200.             return $this->getHttpKernel()->handle($request, $type, $catch);
201.         } finally {
202.             --$this->requestStackSize;
203.         }
204.     }

Kernel->handle(object(Request), 1, false)in adrespaneluadmina/index.php (line 88)

83. $request = Request::createFromGlobals();
84. Request::setTrustedProxies([], Request::HEADER_X_FORWARDED_ALL);
86. try {
87.     require_once __DIR__.'/../autoload.php';
88.     $response = $kernel->handle($request, HttpKernelInterface::MASTER_REQUEST, false);
89.     $response->send();
90.     $kernel->terminate($request, $response);
91. } catch (NotFoundHttpException $exception) {
92.     define('ADMIN_LEGACY_CONTEXT', true);
93.     // correct Apache charset (except if it's too late)

Ma ktoś pomysł jak to naprawić bez przywracania poprzedniej wersji? Na tej już mam paru nowych klientów i zamówień i nie chciałbym musieć robić backupu :)