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-03-27 14:20:59') 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-03-27 14:20:59') 
#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

Yankee Candle 扬基 香氛蜡烛椰子米糕中号 411g

Be the first to review this product
£36.99
Out of stock
SKU
U_YANKEE_5038581111148
Add to Wish List Add to Compare
Yankee Candle - Coconut Rice Cream Medium Jar (411g)

No Related Posts

One of Little House of Fragrance favourites, we love this Yankee Candle Coconut Rice Cream Medium Jar! A creamy sweet treat with fragrance of aromatic rice and coconut! Fragrance Notes Top – Bamboo Rice, Steamy Rice Vapor Middle – Rice Coconut, Watery Floral Base – Sandalwood, Vanilla, Oriental, Sea Musk Burn Time – 65-75 Hours Weight – 411g Dimensions – 10.7cm x 12.7cm
More Information
Brands Yankee Candle
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.