ateg Posted March 25, 2014 Share Posted March 25, 2014 Witam serdecznie podczas zapisywania produktu w panelu, bądź jakichkolwiek stron wyskakuje biała strona. Błąd, który otrzymuje po włączeniu raportowania to: [PrestaShopDatabaseException]Powt�rzone wyst?pienie '27-1-0-0-0-0-0-0-1-2014-03-07 00:00:00-2014-03-09 00:00:00' dla klucza 'id_product_2' INSERT INTO `ps_specific_price` (`id_shop_group`, `id_shop`, `id_cart`, `id_product`, `id_product_attribute`, `id_currency`, `id_specific_price_rule`, `id_country`, `id_group`, `id_customer`, `price`, `from_quantity`, `reduction`, `reduction_type`, `from`, `to`) VALUES ('0', '1', '0', '27', '0', '0', '2', '0', '0', '0', '-1', '1', '0.1', 'percentage', '2014-03-07 00:00:00', '2014-03-09 00:00:00') at line 606 in file classes/db/Db.php600. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);601. }602. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))603. {604. if ($sql)605. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');606. throw new PrestaShopDatabaseException($this->getMsgError());607. }608. }609. 610. /** DbCore->displayError - [line 308 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 582 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 373 - classes/db/Db.php] - [2 Arguments] DbCore->insert - [line 465 - classes/ObjectModel.php] - [3 Arguments] ObjectModelCore->add - [line 95 - classes/SpecificPrice.php] - [2 Arguments] SpecificPriceCore->add - [line 293 - classes/SpecificPriceRule.php] - [0 Argument] SpecificPriceRuleCore::applyRuleToProduct - [line 125 - classes/SpecificPriceRule.php] - [3 Arguments] SpecificPriceRuleCore->apply - [line 140 - classes/SpecificPriceRule.php] - [1 Arguments] SpecificPriceRuleCore::applyAllRules - [line 1408 - classes/Product.php] - [1 Arguments] ProductCore->deleteProductAttributes - [line 657 - classes/Product.php] - [0 Argument] ProductCore->delete - [line 533 - controllers/admin/AdminProductsController.php] - [0 Argument] AdminProductsControllerCore->processDelete - [line 509 - classes/controller/AdminController.php] - [0 Argument] AdminControllerCore->postProcess - [line 1158 - controllers/admin/AdminProductsController.php] - [0 Argument] AdminProductsControllerCore->postProcess - [line 159 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 43 - admin2/index.php] - [0 Argument] bardzo proszę o pomoc Link to comment Share on other sites More sharing options...
0 vekia Posted March 25, 2014 Share Posted March 25, 2014 to co bym zrobił ja, o ile nie będzie to problematyczne z punktu widzenia poświęconego czasu na ustalanie cen (o ile to było robione), to przeczyścił całą tabelę - ps_specific_price po przeczyszczeniu (truncate) wszystko powinno wrócić do normy. Link to comment Share on other sites More sharing options...
0 vekia Posted March 25, 2014 Share Posted March 25, 2014 jaka to wersja presty? czy produkt posiada jakieś warunki nałożone na cenę? (zniżki?) Link to comment Share on other sites More sharing options...
0 ateg Posted March 25, 2014 Author Share Posted March 25, 2014 PrestaShop 1.5.0.17 - problem dotyczy nawet nowych produktów, w których nie ustaliłem jeszcze ceny Link to comment Share on other sites More sharing options...
0 ateg Posted March 26, 2014 Author Share Posted March 26, 2014 (edited) Tabela przeczyszczona, niestety wciąż ten sam błąd.. jednak się udało - została jeszcze jedna reguła koszyka, którą usunąłem - teraz wszystko jest ok wielkie dzięki za pomoc! Edited March 26, 2014 by ateg (see edit history) Link to comment Share on other sites More sharing options...
Question
ateg
Witam serdecznie
podczas zapisywania produktu w panelu, bądź jakichkolwiek stron wyskakuje biała strona.
Błąd, który otrzymuje po włączeniu raportowania to:
Powt�rzone wyst?pienie '27-1-0-0-0-0-0-0-1-2014-03-07 00:00:00-2014-03-09 00:00:00' dla klucza 'id_product_2'
INSERT INTO `ps_specific_price` (`id_shop_group`, `id_shop`, `id_cart`, `id_product`, `id_product_attribute`, `id_currency`, `id_specific_price_rule`, `id_country`, `id_group`, `id_customer`, `price`, `from_quantity`, `reduction`, `reduction_type`, `from`, `to`) VALUES ('0', '1', '0', '27', '0', '0', '2', '0', '0', '0', '-1', '1', '0.1', 'percentage', '2014-03-07 00:00:00', '2014-03-09 00:00:00')at line 606 in file classes/db/Db.php600. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);601. }602. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))603. {604. if ($sql)605. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');606. throw new PrestaShopDatabaseException($this->getMsgError());607. }608. }609. 610. /**bardzo proszę o pomoc
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now