Currency
GBP - British Pound
Toggle Nav
My Cart
Menu
2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (`enabled` = '1') AND (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('1',' at line 2, query was: SELECT COUNT(*) FROM `mgtg_mageplaza_blog_post` AS `main_table` INNER JOIN `mgtg_mageplaza_blog_post_product` AS `related` ON related.post_id=main_table.post_id AND related.entity_id= WHERE (`enabled` = '1') AND (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('1', `store_ids`)))) AND (`publish_date` <= '2026-04-01 23:07:04') Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (`enabled` = '1') AND (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('1',' at line 2 Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (`enabled` = '1') AND (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('1',' at line 2, query was: SELECT COUNT(*) FROM `mgtg_mageplaza_blog_post` AS `main_table` INNER JOIN `mgtg_mageplaza_blog_post_product` AS `related` ON related.post_id=main_table.post_id AND related.entity_id= WHERE (`enabled` = '1') AND (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('1', `store_ids`)))) AND (`publish_date` <= '2026-04-01 23:07:04') 
#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:313]
#2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:564]
#5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:634]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:828]
#7 Zend_Db_Adapter_Abstract->fetchOne() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:222]
#8 Magento\Framework\Data\Collection\AbstractDb->getSize() called at [generated/code/Mageplaza/Blog/Model/ResourceModel/Post/Collection/Interceptor.php:329]
#9 Mageplaza\Blog\Model\ResourceModel\Post\Collection\Interceptor->getSize() called at [vendor/mageplaza/magento-2-blog-extension/Block/Post/RelatedPost.php:140]
#10 Mageplaza\Blog\Block\Post\RelatedPost->setTabTitle() called at [vendor/mageplaza/magento-2-blog-extension/Block/Post/RelatedPost.php:81]
#11 Mageplaza\Blog\Block\Post\RelatedPost->__construct() called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121]
#12 Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject() called at [vendor/magento/framework/ObjectManager/Factory/Compiled.php:108]
#13 Magento\Framework\ObjectManager\Factory\Compiled->create() called at [vendor/magento/framework/ObjectManager/ObjectManager.php:56]
#14 Magento\Framework\ObjectManager\ObjectManager->create() called at [vendor/magento/framework/View/Element/BlockFactory.php:44]
#15 Magento\Framework\View\Element\BlockFactory->createBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:272]
#16 Magento\Framework\View\Layout\Generator\Block->getBlockInstance() called at [vendor/magento/framework/View/Layout/Generator/Block.php:252]
#17 Magento\Framework\View\Layout\Generator\Block->createBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:229]
#18 Magento\Framework\View\Layout\Generator\Block->generateBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:134]
#19 Magento\Framework\View\Layout\Generator\Block->process() called at [vendor/magento/framework/View/Layout/GeneratorPool.php:93]
#20 Magento\Framework\View\Layout\GeneratorPool->process() called at [vendor/magento/framework/View/Layout.php:365]
#21 Magento\Framework\View\Layout->generateElements() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#22 Magento\Framework\View\Layout\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#23 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#24 Magento\Framework\View\Layout\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:68]
#25 Magento\Framework\View\Layout\Interceptor->generateElements() called at [vendor/magento/framework/View/Layout/Builder.php:129]
#26 Magento\Framework\View\Layout\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Page/Builder.php:65]
#27 Magento\Framework\View\Page\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Layout/Builder.php:65]
#28 Magento\Framework\View\Layout\Builder->build() called at [vendor/magento/framework/View/Page/Config.php:227]
#29 Magento\Framework\View\Page\Config->build() called at [vendor/magento/framework/View/Page/Config.php:240]
#30 Magento\Framework\View\Page\Config->publicBuild() called at [generated/code/Magento/Framework/View/Page/Config/Interceptor.php:32]
#31 Magento\Framework\View\Page\Config\Interceptor->publicBuild() called at [vendor/magento/framework/App/View.php:170]
#32 Magento\Framework\App\View->loadLayoutUpdates() called at [vendor/magento/framework/App/View.php:114]
#33 Magento\Framework\App\View->loadLayout() called at [vendor/magento/module-page-cache/Controller/Block.php:86]
#34 Magento\PageCache\Controller\Block->_getBlocks() called at [vendor/magento/module-page-cache/Controller/Block/Esi.php:19]
#35 Magento\PageCache\Controller\Block\Esi->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#36 Magento\PageCache\Controller\Block\Esi\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#37 Magento\PageCache\Controller\Block\Esi\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#38 Magento\PageCache\Controller\Block\Esi\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Controller/Block/Esi/Interceptor.php:23]
#39 Magento\PageCache\Controller\Block\Esi\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:111]
#40 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#41 Magento\PageCache\Controller\Block\Esi\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#42 Magento\PageCache\Controller\Block\Esi\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Webkul/Marketplace/Plugin/App/Action/Context.php:56]
#43 Webkul\Marketplace\Plugin\App\Action\Context->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#44 Magento\PageCache\Controller\Block\Esi\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#45 Magento\PageCache\Controller\Block\Esi\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Controller/Block/Esi/Interceptor.php:32]
#46 Magento\PageCache\Controller\Block\Esi\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:245]
#47 Magento\Framework\App\FrontController->getActionResponse() called at [vendor/magento/framework/App/FrontController.php:212]
#48 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:147]
#49 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#50 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#51 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99]
#52 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#53 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Litespeed/Litemage/Model/App/FrontController/LitemagePlugin.php:54]
#54 Litespeed\Litemage\Model\App\FrontController\LitemagePlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#55 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:71]
#56 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#57 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#58 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:23]
#59 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116]
#60 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#61 Magento\Framework\App\Http\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#62 Magento\Framework\App\Http\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/graycore/magento2-cors/Plugin/FastLauncher.php:70]
#63 Graycore\Cors\Plugin\FastLauncher->aroundLaunch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#64 Magento\Framework\App\Http\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#65 Magento\Framework\App\Http\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:23]
#66 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:264]
#67 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:26]
Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (`enabled` = '1') AND (((FIND_IN_SET(0, `store_ids`)) OR (FIND_IN_SET('1',' at line 2 
#1 Magento\Framework\DB\Statement\Pdo\Mysql->Magento\Framework\DB\Statement\Pdo\{closure}() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:106]
#2 Magento\Framework\DB\Statement\Pdo\Mysql->tryExecute() called at [vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91]
#3 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:313]
#4 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#5 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#6 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:564]
#7 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:634]
#8 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:828]
#9 Zend_Db_Adapter_Abstract->fetchOne() called at [vendor/magento/framework/Data/Collection/AbstractDb.php:222]
#10 Magento\Framework\Data\Collection\AbstractDb->getSize() called at [generated/code/Mageplaza/Blog/Model/ResourceModel/Post/Collection/Interceptor.php:329]
#11 Mageplaza\Blog\Model\ResourceModel\Post\Collection\Interceptor->getSize() called at [vendor/mageplaza/magento-2-blog-extension/Block/Post/RelatedPost.php:140]
#12 Mageplaza\Blog\Block\Post\RelatedPost->setTabTitle() called at [vendor/mageplaza/magento-2-blog-extension/Block/Post/RelatedPost.php:81]
#13 Mageplaza\Blog\Block\Post\RelatedPost->__construct() called at [vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121]
#14 Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject() called at [vendor/magento/framework/ObjectManager/Factory/Compiled.php:108]
#15 Magento\Framework\ObjectManager\Factory\Compiled->create() called at [vendor/magento/framework/ObjectManager/ObjectManager.php:56]
#16 Magento\Framework\ObjectManager\ObjectManager->create() called at [vendor/magento/framework/View/Element/BlockFactory.php:44]
#17 Magento\Framework\View\Element\BlockFactory->createBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:272]
#18 Magento\Framework\View\Layout\Generator\Block->getBlockInstance() called at [vendor/magento/framework/View/Layout/Generator/Block.php:252]
#19 Magento\Framework\View\Layout\Generator\Block->createBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:229]
#20 Magento\Framework\View\Layout\Generator\Block->generateBlock() called at [vendor/magento/framework/View/Layout/Generator/Block.php:134]
#21 Magento\Framework\View\Layout\Generator\Block->process() called at [vendor/magento/framework/View/Layout/GeneratorPool.php:93]
#22 Magento\Framework\View\Layout\GeneratorPool->process() called at [vendor/magento/framework/View/Layout.php:365]
#23 Magento\Framework\View\Layout->generateElements() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#24 Magento\Framework\View\Layout\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#25 Magento\Framework\View\Layout\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#26 Magento\Framework\View\Layout\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/View/Layout/Interceptor.php:68]
#27 Magento\Framework\View\Layout\Interceptor->generateElements() called at [vendor/magento/framework/View/Layout/Builder.php:129]
#28 Magento\Framework\View\Layout\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Page/Builder.php:65]
#29 Magento\Framework\View\Page\Builder->generateLayoutBlocks() called at [vendor/magento/framework/View/Layout/Builder.php:65]
#30 Magento\Framework\View\Layout\Builder->build() called at [vendor/magento/framework/View/Page/Config.php:227]
#31 Magento\Framework\View\Page\Config->build() called at [vendor/magento/framework/View/Page/Config.php:240]
#32 Magento\Framework\View\Page\Config->publicBuild() called at [generated/code/Magento/Framework/View/Page/Config/Interceptor.php:32]
#33 Magento\Framework\View\Page\Config\Interceptor->publicBuild() called at [vendor/magento/framework/App/View.php:170]
#34 Magento\Framework\App\View->loadLayoutUpdates() called at [vendor/magento/framework/App/View.php:114]
#35 Magento\Framework\App\View->loadLayout() called at [vendor/magento/module-page-cache/Controller/Block.php:86]
#36 Magento\PageCache\Controller\Block->_getBlocks() called at [vendor/magento/module-page-cache/Controller/Block/Esi.php:19]
#37 Magento\PageCache\Controller\Block\Esi->execute() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#38 Magento\PageCache\Controller\Block\Esi\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#39 Magento\PageCache\Controller\Block\Esi\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#40 Magento\PageCache\Controller\Block\Esi\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Controller/Block/Esi/Interceptor.php:23]
#41 Magento\PageCache\Controller\Block\Esi\Interceptor->execute() called at [vendor/magento/framework/App/Action/Action.php:111]
#42 Magento\Framework\App\Action\Action->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#43 Magento\PageCache\Controller\Block\Esi\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#44 Magento\PageCache\Controller\Block\Esi\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Webkul/Marketplace/Plugin/App/Action/Context.php:56]
#45 Webkul\Marketplace\Plugin\App\Action\Context->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#46 Magento\PageCache\Controller\Block\Esi\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#47 Magento\PageCache\Controller\Block\Esi\Interceptor->___callPlugins() called at [generated/code/Magento/PageCache/Controller/Block/Esi/Interceptor.php:32]
#48 Magento\PageCache\Controller\Block\Esi\Interceptor->dispatch() called at [vendor/magento/framework/App/FrontController.php:245]
#49 Magento\Framework\App\FrontController->getActionResponse() called at [vendor/magento/framework/App/FrontController.php:212]
#50 Magento\Framework\App\FrontController->processRequest() called at [vendor/magento/framework/App/FrontController.php:147]
#51 Magento\Framework\App\FrontController->dispatch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#52 Magento\Framework\App\FrontController\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#53 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-store/App/FrontController/Plugin/RequestPreprocessor.php:99]
#54 Magento\Store\App\FrontController\Plugin\RequestPreprocessor->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#55 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [app/code/Litespeed/Litemage/Model/App/FrontController/LitemagePlugin.php:54]
#56 Litespeed\Litemage\Model\App\FrontController\LitemagePlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#57 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/module-page-cache/Model/App/FrontController/BuiltinPlugin.php:71]
#58 Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#59 Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#60 Magento\Framework\App\FrontController\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/FrontController/Interceptor.php:23]
#61 Magento\Framework\App\FrontController\Interceptor->dispatch() called at [vendor/magento/framework/App/Http.php:116]
#62 Magento\Framework\App\Http->launch() called at [vendor/magento/framework/Interception/Interceptor.php:58]
#63 Magento\Framework\App\Http\Interceptor->___callParent() called at [vendor/magento/framework/Interception/Interceptor.php:138]
#64 Magento\Framework\App\Http\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/graycore/magento2-cors/Plugin/FastLauncher.php:70]
#65 Graycore\Cors\Plugin\FastLauncher->aroundLaunch() called at [vendor/magento/framework/Interception/Interceptor.php:135]
#66 Magento\Framework\App\Http\Interceptor->Magento\Framework\Interception\{closure}() called at [vendor/magento/framework/Interception/Interceptor.php:153]
#67 Magento\Framework\App\Http\Interceptor->___callPlugins() called at [generated/code/Magento/Framework/App/Http/Interceptor.php:23]
#68 Magento\Framework\App\Http\Interceptor->launch() called at [vendor/magento/framework/App/Bootstrap.php:264]
#69 Magento\Framework\App\Bootstrap->run() called at [pub/index.php:26]
Settings
Currency
GBP - British Pound
Account

Schwarzkopf - Bonacure Color Freeze Treatment (500ml)

Be the first to review this product
£39.00
Out of stock
SKU
U_SCHWARZKOPF_4045787724233
Add to Wish List Add to Compare
Schwarzkopf - Bonacure Color Freeze Treatment (500ml)

No Related Posts

A restoring, creamy hair treatment from Bonacure Color Freeze, specially formulated for colour-treated hair. With no silicones or artificial colourants, the treatment provides in-depth care to intensively repair coloured hair. Hair is restored to its optimal pH level to perfectly freeze colour pigments inside the hair matrix, preventing fading for long-lasting hair colour.


Vegan* hair product.

More Information
Brands Schwarzkopf
Item Returns This item can be returned
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Copyright © 2013-present Magento, Inc. All rights reserved.