I have applied patch 6788 to magento EE 1.13 and also added block to white list but blocks are not displaying on home page
Thank you so much all of you for your time, my problem was with magestore bannerslider module. after digging into this I found the solution on this url
error was :
SQLSTATE: 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 ‘.
value)= ‘0’) AND (
To solve SQL error change line 60 in app/code/community/Magestore/Bannerslider/Model/Mysql4/Banner/Collection.php as shown in the diff below:
--- Bannerslider/Model/Mysql4/Banner/Collection.php +++ Bannerslider/Model/Mysql4/Banner/Collection.php @@ -59,3 +59,3 @@ } - return parent::addFieldToFilter("IF($field.value IS NULL, main_table.$field, $field.value)", $condition); + $this->getSelect()->where("IF($field.value IS NULL, main_table.$field, $field.value) = 0"); }
Make sure that bannerslider/default block is whitelisted at CMS > Pages or CMS > Static Blocks