Jump to content
  • 0

Problem z zapisywaniem ilości produktów

Waflu

Asked by Waflu,

 Share

Question

Waflu Newbie

Waflu

Posted
Posted (edited)

Dzień dobry,

po aktualizacji z 1.7.4.4 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)
  1.         if ($webservice_call && $errno) {
  2.             $dbg = debug_backtrace();
  3.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
  4.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
  5.             if ($sql) {
  6.                 throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
  7.             }
  9.             throw new PrestaShopDatabaseException($this->getMsgError());
  10.         }
  11.     }
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)
  1.                 $this->result = $this->_query($sql);
  2.             }
  3.         }
  5.         if (_PS_DEBUG_SQL_) {
  6.             $this->displayError($sql);
  7.         }
  9.         return $this->result;
  10.     }
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)
  2.                 return $result;
  3.             }
  4.         }
  6.         $this->result = $this->query($sql);
  7.         if (!$this->result) {
  8.             $result = false;
  9.         } else {
  10.             $result = $this->nextRow($this->result);
  11.         }
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)
  1.     {
  2.         if ($sql instanceof DbQuery) {
  3.             $sql = $sql->build();
  4.         }
  6.         if (!$result = $this->getRow($sql, $use_cache)) {
  7.             return false;
  8.         }
  10.         return array_shift($result);
  11.     }
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)
  1.         $query->where('id_product = ' . $id_product);
  2.         $query->where('id_product_attribute = ' . $id_product_attribute);
  4.         $query = StockAvailable::addSqlShopRestriction($query, $id_shop);
  6.         return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
  7.     }
  9.     /**
  10.      * Add an sql restriction for shops fields - specific to StockAvailable.
  11.      *
StockAvailableCore::getLocation(560)in classes/Product.php (line 6522)
  2.         // Default product quantity is available quantity to sell in current shop
  3.         $this->quantity = StockAvailable::getQuantityAvailableByProduct($this->id, 0);
  4.         $this->out_of_stock = StockAvailable::outOfStock($this->id);
  5.         $this->depends_on_stock = StockAvailable::dependsOnStock($this->id);
  6.         $this->location = StockAvailable::getLocation($this->id);
  8.         if (Context::getContext()->shop->getContext() == Shop::CONTEXT_GROUP && Context::getContext()->shop->getContextShopGroup()->share_stock == 1) {
  9.             $this->advanced_stock_management = $this->useAdvancedStockManagement();
  10.         }
  11.     }
ProductCore->loadStockData()in src/PrestaShopBundle/Model/Product/AdminModelAdapter.php (line 443)
  1.      *
  2.      * @return array Transformed model data to form attempt
  3.      */
  4.     public function getFormData(Product $product)
  5.     {
  6.         $product->loadStockData();
  7.         $this->productPricePriority = $this->adminProductWrapper->getPricePriority($product->id);
  9.         $this->formData['id_product'] = $product->id;
  10.         $this->formData['step1'] = $this->mapStep1FromData($product);
  11.         $this->formData['step2'] = $this->mapStep2FormData($product);
AdminModelAdapter->getFormData(object(Product))in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 661)
  1.      * @throws \Symfony\Component\Process\Exception\LogicException
  2.      */
  3.     private function createProductForm(Product $product, AdminModelAdapter $modelMapper)
  4.     {
  5.         $formBuilder = $this->createFormBuilder(
  6.             $modelMapper->getFormData($product),
  7.             ['allow_extra_fields' => true]
  8.         )
  9.             ->add('id_product', HiddenType::class)
  10.             ->add('step1', ProductInformation::class)
  11.             ->add('step2', ProductPrice::class, ['id_product' => $product->id])
ProductController->createProductForm(object(Product), object(AdminModelAdapter))in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 452)
  1.         $isMultiShopContext = count($shopContext->getContextListShopID()) > 1;
  3.         $modelMapper = $this->get('prestashop.adapter.admin.model.product');
  4.         $adminProductWrapper = $this->get('prestashop.adapter.admin.wrapper.product');
  6.         $form = $this->createProductForm($product, $modelMapper);
  8.         $formBulkCombinations = $this->createForm(
  9.             ProductCombinationBulk::class,
  10.             null,
  11.             [
ProductController->formAction('560', object(Request))in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)
  1.         $this->dispatcher->dispatch(KernelEvents::CONTROLLER_ARGUMENTS, $event);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = \call_user_func_array($controller, $arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new GetResponseForControllerResultEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch(KernelEvents::VIEW, $event);
HttpKernel->handleRaw(object(Request), 1)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)
  1.     public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
  2.     {
  3.         $request->headers->set('X-Php-Ob-Level', ob_get_level());
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle(object(Request), 1, false)in adrespaneluadmina/index.php (line 88)
  1. $request = Request::createFromGlobals();
  2. Request::setTrustedProxies([], Request::HEADER_X_FORWARDED_ALL);
  4. try {
  5.     require_once __DIR__.'/../autoload.php';
  6.     $response = $kernel->handle($request, HttpKernelInterface::MASTER_REQUEST, false);
  7.     $response->send();
  8.     $kernel->terminate($request, $response);
  9. } catch (NotFoundHttpException $exception) {
  10.     define('ADMIN_LEGACY_CONTEXT', true);
  11.     // 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 :)

Edited by Waflu (see edit history)
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing
×
×
  • Create New...